Explore BrainMass
Share

Normalizing Relations to 3NF

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

Normalize the following relation to 3NF. Describe all normal forms, and what must be done to achieve each.

Make Computer Company Computer Store
PC-1 BUSY BUSINESS MACHINES JOYLAND
PC-2 BUSY BUSINESS MACHINES DATALAND
PINEAPPLE COMPUTERS INFOWORLD
WIZ-1 PINEAPPLE COMPUTERS DATASTORE
WIZ-2 PINEAPPLE COMPUTERS DATAJOY.

See attached file.

© BrainMass Inc. brainmass.com March 21, 2019, 4:22 pm ad1c9bdddf
https://brainmass.com/computer-science/algorithms/normalizing-relations-3nf-183182

Attachments

Solution Preview

Business Rules

A Computer Company manufactures many Products
Products are manufactured by ...

Solution Summary

Business rules and tables to normalize given relations to 3NF are provided.

$2.19