please can someone help me with this question The following three tables capture

Question

please can someone help me with this question

The following three tables capture part of the information about a small airline operation. On each flight, individual seats are not assigned.

ScheduledFlightInfo:(Flightno, from, to, departureTime, arrivalTime)

ActualFlightInfo: (InfoId, FlightDate, FlightNo, actualDepartureTime, ActualArrivalTime, employeeNo, role, seats-remaining, airplane-serialNo)

Employee: (EmployeeNo, name, phone, jobTitle)

Identify functional dependency (or dependencies) for each numbered paragraph below. Use only fields in a table listed above. Consider all information given together. Identify which table each functional dependency is defined on. Do NOT add columns to the above two tables.

Explanation / Answer

Employee Table,FD:EmployeeName Employee Number,phone,JobTitle

1= Each flight number refers to one flight that goes from Source city to destination city.Flight numbers are unique.The table stores it arrival time and departure time .

2= The arrival and departure time of a flight on a given day are recorded in the ActualflightInfo table.

3=The database records the employeeNo and the role for each crewmember on each actual flight scheduled or flown on a particular date . Each employee serves only one role on a given flight scheduled or flown. An employee may serve different roles on different flights.

4=The number or remaining seat are recorded in database.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.