Explore BrainMass
Share

Domain/Key Normal Form

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

Need help transforming 2 relations into Domain/Key Normal Form. See attached file for full problem description.

© BrainMass Inc. brainmass.com October 16, 2018, 8:08 pm ad1c9bdddf
https://brainmass.com/computer-science/files/domain-key-normal-form-139194

Attachments

Solution Preview

Please see the attached file.

Line Item

1) ItemQuantity (Attribute)
2) ExtendedPrice (Attribute)
3) Invoice Number (FK
to Sales Order Table)
4) ItemNumber (FK to Item
Table) (PK for Line Item)

Equipment/Item

1) ItemNumber (PK)
2) Manufacturer (Attribute)
3) Model (Attribute)
4) PlantLocation (Attribute)
5) City (Attribute)
6) State (Attribute)
7) ZIP (Attribute)
8) ItemPrice (Attribute)

INVOICE

1) Number (PK)
2) AcquisitionDate (Attribute)
3) CustomerNumber (FK to Customer table)
4) SalespersonNumber (FK to Sales Person table)
5) Subtotal (Calculated Attribute)
6) Tax (Calculated Attribute)
7) TotalDue (Calculated Attribute)

Customer

1) CustomerNumber (PK)
2) CustomerName
3) CustomerAddress (Attribute)
4) ...

Solution Summary

Domain/Key Normal Form is used to transform two relations in the solution.

$2.19
Similar Posting

Normalization and Optimization

Do explain the process of Normalization?
Explain the context in which Normalization is used?
What is its purpose?
What are the steps to be taken?
What do we actually do when we normalize?
Would you describe Normalization as Science or Art?

Dedicate your last paragraph to Optimization (de-normalization)

View Full Posting Details