Q.5. Model FlightPath ustadni
Discussion
Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.
No questions yet — be the first to ask.
More Data and Network Security papers
See all
Paper text
Q.5.
Model
FlightPath
ustadni
C
FPDescription
FLIGHTPATH
CheckPoin
AIRCRAFT
Allocated
ustadni,com
Assigned
Pilot
Train by
PILOT
ustadni.com
Use
SCHEDULE
Assigned
Q.6.
Above shows a conceptual data model of a small airline. SCHEDULE is used to keep track on schedule
flights. On every flights, the dirline needs to know the aircraft, pilots and flightpaths, Pilots in this
airline are normally training in-house by their own senior pilots. If the pilots are trained in-house, airline
wants to know who is the assigned trainer. The SCHEDULE is printed daily starting from the earliest
date (sort by date and time ascending order).
(a) Convert the above ER diagram into relations.
Mary Baker
200 Oak St.
Mountain View, CO 806338
PATIENT N
Mary B
MOUNTAIN VIEW COMMUNITY HOSPITAL
200 Forest Dr.
Mountain View, CO 80638
INVOICE DATE:
ACCOUNT NUMBER:
DUE OATE:
PATIENT A
3249
DATE ADMITTED
10/15/2010
307
413
DESGRIPTION
Room semi-pr
Television
X-ray
Lab tooto
ustadni.com
Patient bill
10/24/2010
000978655
11/14/2010
DATE DISCHARGED
10/18/2010
TOTAL CHARGE
1,800.00
75.00
150.00
200.00
Normalize the above patient bill upto 3d NF. Also write down rules which you are going to supposed
to achieve this normalization.
visit website: ustadni.com