Database Management | Assignment Sample

Added on - 15 Jan 2021

  • 21

    Pages

  • 808

    Words

  • 105

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 6 of 21 pages
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.EntitiesAttributesStaffStaff 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)TeamTeam id (PK)team nameteam categoriesteam scoreTable – 1Primary key –it is a unique key that represents unique value in the table to create arelationship with another one. In database tables, primary key is consists of uniqueidentifier where each value contain value and cannot repeat.Foreign key-A foreign key is a group and column in the relational database table thatprovide 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 idIn Rider table:Primary key : Rider idForeign key : team id
In team table:Primary key : team idIn Captain table:Primary key :captain idForeign Key : team id2). Draw the Entity relationship Diagram by using diagramming software.Figure1ERDiagramEntity 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. Ithas created a relationship with volunteer table because it is representing as a foreign key involunteer table.In staff table
Primary key : staff idIn volunteer tableForeign key : Staff id3). Shows the database tables and their each records.Database tables-Captain table:Staff table:Illustration1Illustration2
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document