Introduction To Database
21 Pages808 Words193 Views
Added on 2020-12-18
Introduction To Database
Added on 2020-12-18
ShareRelated Documents
Project 4- Database
Table of ContentsINTRODUCTION...........................................................................................................................3TASKS.............................................................................................................................................31). List the new attributes and group them into the existing or new entities. .............................32). Draw the Entity relationship Diagram by using diagramming software. ..............................53). Shows the database tables and their each records. .................................................................6CONCLUSION..............................................................................................................................13REFERENCES..............................................................................................................................14
INTRODUCTIONDatabase is a collection of element that can organize, manage and retrieve the data indatabase management system. It supports the data storage and manipulation of information inproper manner. This assignment will discuss about the entity relationship diagram that representthe overall data functionality in the system. It will describe the database system of Burn 24hourchallenge which based on the annual mountain bike race where many riders were participated inthe racing so that it needs to manage all the information and data through data base system. TASKS1). List the new attributes and group them into the existing or new entities. Entities: Entity is basically a set of groups that can use in the database system. It may bean object with the physical existence and conceptual existences. Attributes: it refers to the properties that characterised an entity set in the relationaldatabase system. According to database system, There are different type of entities and attributes exits inthe relational database system. EntitiesAttributesStaff Staff id (PK)Staff nameStaff ageStaff phone noStaff addressStaff emergency norider id (FK)CaptainCaptain id (PK)captain nameteam id (FK)VolunteerVolunteer id (PK)Volunteer namevolunteer agevolunteer phone novolunteer address
volunteer EMG novolunteer timevolunteer rolestaff id (FK)Rider id (FK)Team Team id (PK)team nameteam categoriesteam score Table – 1Primary key – it is a unique key that represents unique value in the table to create a relationship with another one. In database tables, primary key is consists of unique identifier where each value contain value and cannot repeat. Foreign key- A foreign key is a group and column in the relational database table that provide a link among data in different tables. In staff table:Primary key: staff idForeign key : Rider idIn volunteer table:primary key : volunteer idForeign key : Staff id, Rider id In Rider table:Primary key : Rider id Foreign key : team id
In team table:Primary key : team id In Captain table:Primary key :captain id Foreign Key : team id2). Draw the Entity relationship Diagram by using diagramming software. Figure 1 ER DiagramEntity relationship digram is representing the relationship between the different entities andhaving specific attributes. These entities are sets that store in the database system. In this way, iteasily visualizing that how the information system produces is related to the database. For Example-In Staff table:Staff id is a primary key in the table that shows as a unique value in the database table. It has created a relationship with volunteer table because it is representing as a foreign key in volunteer table. In staff table
Primary key : staff id In volunteer tableForeign key : Staff id3). Shows the database tables and their each records. Database tables-Captain table:Staff table:Illustration 1Illustration 2
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Management System : Doclg...
|22
|1217
|96
Entity Relationship Diagram in Library Management Systemlg...
|25
|2195
|76
Introduction of DBMS (Database Management System)lg...
|28
|2805
|27
Database Design for Tennis Tournament Systemlg...
|38
|4041
|355
Entity Relationship Model : Assignmentlg...
|39
|3339
|277
Database Fundamentals: ER Diagram, BCNF, SQL Queries, Optimization, Security, Web Interfacelg...
|23
|2632
|88