logo

Database Design and Entity Relationship Diagrams

   

Added on  2020-02-18

15 Pages1318 Words472 Views
 | 
 | 
 | 
BIT231 Databases SystemsStudent ID: 1452842Student Name: Surpreet Singh
Database Design and Entity Relationship Diagrams_1

Table of ContentsQuestion 1...................................................................................................................................................31.Business Rules.................................................................................................................................32.Entities, Attributes and Relationships..............................................................................................43.Entity Relationship Diagram............................................................................................................54.Data Dictionary................................................................................................................................65.Relational Data Model.....................................................................................................................7Question 2...................................................................................................................................................81.Countries Relation...........................................................................................................................82.First Normal Form..........................................................................................................................103.Second Normal Form.....................................................................................................................114.Third Normal Form........................................................................................................................12References.................................................................................................................................................15
Database Design and Entity Relationship Diagrams_2

Question 11.Business Rules1.MPoly Airline flight is uniquely identified by the flight number with date.2.Each flight also records its actual arrival and departure time.3.Passenger who flow on the flight is uniquely identified by passenger number.4.Passenger’s details are also recorded like his or her name, address and telephone number.5.Company records the details like fare and date of reservation of the passenger.6.Each passenger may have taken 1 or more flights.7.Every flight can carry many passengers.8.Each pilot is uniquely identified by Pilot/Employee number.9.Each pilot’s details are recorded like first name, last name, date of birth and hire date.10.Pilot may or may not have flown the flights.11.Airplane is uniquely identified by serial number.12.Airplane also records manufacturer name, passenger capacity and built year.13.Each flight uses one airplane on a particular whereas each airplane may or may not be flownon more than one flight and date.14.Airplane’s maintenance procedure is uniquely identified by procedure number. 15.Maintenance procedure also records procedure name, frequency of procedure. 16.Maintenance of each airplane records date of procedure, maintenance location and duration.
Database Design and Entity Relationship Diagrams_3

2.Entities, Attributes and Relationships
Database Design and Entity Relationship Diagrams_4

End of preview

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

Related Documents