Computer Science Homework Solutions
Problem
#139194

Domain/Key

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

Attached file(s):
Attachments
DK_NF.doc  View File

Attachment Content Summary (Note: view attachment at the above link before purchasing. Actual attachment content may vary slightly from that shown below.)

DK_NF.doc
Transform the following 2 relations into Domain/Key Normal Form (DK/NF).
Make and state the appropriate assumptions about functional
dependencies and domains.

A. EQUIPMENT (Manufacturer, Model, AcquisitionDate, BuyerName,
BuyerPhone, PlantLocation, City, State, ZIP)

B. INVOICE (Number, CustomerName, CustomerNumber, CustomerAddress,
ItemNumber, ItemPrice, ItemQuantity, SalespersonNumber, SalespersonName,
Subtotal, Tax, TotalDue)
Solution
What is this?
By OTA - Overall OTA Rating
Himanshu Kundliya, MSc - 4.5/5
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
  • Plain text response
  • Attached file(s):
    • Posting ID_139194.doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • IP Addresses - When a person types in a domain name such as http://www.ibm.com, how is this recognized by the computer as an IP address? How are IP addresses used?
  • Act as an IT consultant to a new nonprofit organization, Free Flu - I need help here. Please make sure is from 200-300 words. Thanks Act as an IT consultant to a new nonprofit organization, Free Flu, which provides flu shots to the elderly. The organization needs a d ...
  • Domain Name Service for Non profit Organization - I would appreciate some help in what direction to go with this • Act as an IT consultant to a new nonprofit organization, Free Flu, which provides flu shots to the elderly. The organization needs a ...
  • Study Questions - These questions were given as a guide to study from. What would be the correct way to answer these? I guess there is no real right or wrong answer but would like to know how you would solve. Thanks ...
  • Relational Databases - Look for an example of a one-to-one relationship, an example of a one-to-many relationship, and an example of a many-to-many relationship in a newspaper, magazine, book, or everyday situation you enco ...
Browse