Purchase Solution

Domain/Key Normal Form

Not what you're looking for?

Ask Custom Question

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

Attachments
Purchase this Solution
Solution Summary

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

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) ...

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

View More Free Quizzes
Related BrainMass Solutions

  • RECEPTOR TYROSINE KINASE MUTANTS

    The cells also express their own normal form of the receptor from their normal gene, although the mutant genes are constructed so that they are expressed at considerably higher concentrations than the normal gene.

  • Life span development, growth factors

    Physical domain has to do with the normal and typical growth of the individual's body as a healthy individual.

  • Normalize a Table: Sales Invoice Information

    Third Normal Form: A relation R is in third normal form if and only if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key.

  • real world example that demonstrates one of the normal forms

    The Second Normal Form: The second normal form (2NF) requires that all the fields in the database contain data that depends on the entire primary key.

  • database normal form

    19528 Database normal form 1. Find or create a violation of 1st normal form and demonstrate how you would fix it. 2. Find or create a violation of 2nd normal form and demonstrate how you would fix it. 3.

  • Designing a database for university

    Form Third Normal Form refers only to tables with a single key field and requires that each non key field to be a direct description of primary key field.

  • An explanation of database normalization with and example

    There are various levels of normalizations called "normal forms". These are commonly known as First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form, Fourth Normal Form, etc.

  • Literature Review: Cadherin-mediated cell-cell adhesion.

    After transfecting L cells with cDNA encoding the mutant polypeptides, we assayed aggregating activity of these transfectants; all these mutant proteins were shown to have an extracellular domain with normal Ca(2+)-sensitivity and molecular weight.

  • The Relational Model and Data Normalization

    When we do this, the new relations are in some other normal form, depending on the anomalies eliminated. Second normal form: a relation is in second normal form if all its non-key attributes are dependent on all of the keys.

View More Related Solutions