Consider the relational schemas given below and the respective sets of functional dependencies valid in the schemas. For each one of the relational schemas identify its highest normal form. Remember
Specification
Functional Dependency
Consider the relational schemas given below and the respective sets of functional dependencies valid in the schemas. For each one of the relational schemas identify its highest normal form. Remember that the identification of a normal form requires analysis of the valid functional dependencies and the minimal keys.
TRUCK(registration#, type, owner, driver, date-used)
The values of attributes of a relational table TRUCK satisfy the following properties:
- a truck has a unique registration number,
- a truck has only one owner,
- a truck is used only once per day,
- an owner owns many trucks and driver uses many trucks.
Step by step
Solved in 2 steps
I ask you truck question and you reply employee? how can this be possible
by Bartleby Expert
