Explore BrainMass
Share

Relational schema and set of dependancy

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Write the relational schema and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions and create new entities and attributes as necessary.

I have attached a jpg of the table and problem I'm having trouble with number 9.

© BrainMass Inc. brainmass.com March 21, 2019, 2:13 pm ad1c9bdddf
https://brainmass.com/computer-science/security/relational-schema-set-dependancy-117374

Attachments

Solution Preview

Please see the attached file.

Q8.
Item_line
Functional Dependancies:
Item_Id - primary key
Item_id  Item_label , Bldg_name, Bldg_manager, ...

Solution Summary

Write the relational schema and create a set of dependency diagrams that meet 3NF requirements.

$2.19