BIT231 Databases Systems Assignment | Melbourne Polytechnic

Added on -2020-02-18

| BIT231| 15 pages| 1318 words| 163 views

Trusted by 2+ million users,
1000+ happy students everyday

Showing pages 1 to 4 of 15 pages

BIT231 Databases SystemsStudent ID: 1452842Student Name: Surpreet Singh
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

Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

Premium

$45

Q&A Library Access

Chat support

12

Document Unlocks

4

Answer Unlocks

Students who viewed this