Sample Exercises and Examination Questions - Database Systems - page 400

4. The following atomic data elements were taken from the data

dictionary of an inventory system:

Group the attributes into related entities. Then for each entity, identify
the FDs, then normalize it. Grade may be assigned as follows:

Identification of all possible FDs. {11}

Putting the elements into normalized relations. You may
introduce elements as required with appropriate explanation.

{44}

26.4 Sample Assignment 3A
1.

Define the following terms:

Candidate key {02}

Foreign key {02}

Functional dependence {03}

Transitive dependence {03}

2.

Give the primary key and the highest normal form of each of
the following relations. State any assumptions made and give
reasons for your answers.

Student {Student#, Name, Address, Gender, Age DOB}

{03}

Flight {Flight#, Date, Seats-Available, Flight-Time,
From-City, To-City} {03}