Business Rules BIT231 Databases Systems Student ID: 1452842
15 Pages1318 Words472 Views
Melbourne Polytechnic
Databases Systems (BIT231)
Added on 2020-02-18
About This Document
Third Normal Form 12 References 15 Question 1 Business Rules MPoly Airline flight is uniquely identified by the flight number with date. Entities, Attributes and Relationships Entity Relationship Diagram Data Dictionary Relational Data Model Question 2 Countries Relation Citizen Dictator CitizenID CitizenName DOB CountryBorn 1 Eric Ambler 3/31/1976 Canada 2 Peter Chandler 3/31/1976 Australia 3 Peter Fleming 3/31/1976 UK 4 Peter Fleming 3/31/1976 Australia 5 Peter Chandler 3/31/1976 Australia 6 John Ellroy 8
Business Rules BIT231 Databases Systems Student ID: 1452842
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
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.
2.Entities, Attributes and Relationships
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database System for MPoly Airlines: Business Rules, ER Diagram, Data Dictionary, SQL Statements and Output Screenslg...
|20
|1724
|138
MyPoly Airlines - Databaselg...
|14
|1586
|168
BIT231: Database Systems - ERD Diagram, Entities, Attributes, SQL Commands and Insert Commandslg...