Primary key-entity-aviation database


Question 1: Suppose that you have been presented with the given relation for the Baxter Aviation database: Charters (Pilot, Pilot-name, Aircraft ID, seats, Village, Flight, Flight-date, Flight-time, Customer, Customer-name)

i) How many entities are represented by this relation?

ii) Determine the primary key of this relation?

(Hint: Flight is unique; flight numbers do not repeat as they do on commercial airlines with regularly scheduled flights. Each flight can go to numerous villages and over time a village can receive many flights.)

iii) Give a particular illustration of one insertion anomaly present in this relation.

iv) Give a particular illustration of one deletion anomaly present in this relation.

v) Is this relation in first, second or third normal form? Why?

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Primary key-entity-aviation database
Reference No:- TGS0871

Expected delivery within 24 Hoursrs

2015 ┬ęTutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.