Ask a question from expert

Ask now

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

   

Melbourne Polytechnic

   

Databases Systems (BIT231)

   Added on 2020-02-18

BookmarkShareRelated Documents
BIT231 Databases SystemsStudent ID: 1452842Student Name: Surpreet Singh
Business Rules BIT231 Databases Systems Student ID: 1452842_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
Business Rules BIT231 Databases Systems Student ID: 1452842_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.
Business Rules BIT231 Databases Systems Student ID: 1452842_3
2.Entities, Attributes and Relationships
Business Rules BIT231 Databases Systems Student ID: 1452842_4

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 Screens
|20
|1724
|138

MyPoly Airlines - Database
|14
|1586
|168

BIT231: Database Systems - ERD Diagram, Entities, Attributes, SQL Commands and Insert Commands
|25
|2168
|381

Introduction to Database Systems Assignment
|2
|511
|241

ICT284 Systems Analysis and Design
|12
|1661
|469

Situational Analysis Assignment - WAA airlines
|17
|3972
|93