logo

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
Introduction To Database_1
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
Introduction To Database_2
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
Introduction To Database_3
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
Introduction To Database_4
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
Introduction To Database_5
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
Introduction To Database_6

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Management System : Doc
|22
|1217
|96

Entity Relationship Diagram in Library Management System
|25
|2195
|76

Introduction of DBMS (Database Management System)
|28
|2805
|27

Database Design for Tennis Tournament System
|38
|4041
|355

Entity Relationship Model : Assignment
|39
|3339
|277

Database Fundamentals: ER Diagram, BCNF, SQL Queries, Optimization, Security, Web Interface
|23
|2632
|88