Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2016
    Posts
    2

    Database Normaliztion (1F, 2NF, 3NF)

    Hello all.

    I'm working on a project for my class and having issues wrapping my head around normalizing data.

    I think I was able to get the data into 1NF, but beyond that I'm just lost.

    I've attached the Sales Order Form (from which I'm supposed to extract the data (Not supposed to include Line Total Information)) and my attempt to get it into 1NF.

    There are supposed to be a total of 1 Table in 1NF, 3 Tables in 2NF and 4 Tables in 3NF. In the end there should be 4 resulting tables for Customer Information, Donut Information, Order Information and Order Line Information.

    Here's the instructions:

    Construct a normalized model to represent the donut shop smartphone application database that supports the scenario above by doing the following:
    1. Using the attached “Sales Order Form” (unnormalized order form) for the donut ordering database as a reference, produce the final logical schema for this database by doing the following:

    Note: You can design the tables for the following prompts using any method of your choice (e.g., using a drawing tool using tables).

    a. Design one table that is in first normal form and fulfills the following requirements:
    • The table should have a primary key that uniquely identifies the records.
    • The values in each of the columns should be atomic.
    • There should be no repeating groups.
    i. Explain how you designed the table (suggested length of 1 paragraph).
    b. Design three tables that are in second normal form and fulfill the following requirements:
    • The tables should meet all of the requirements for the first normal form.
    • All functional dependencies should be removed from the tables.
    • Each of the tables should have all primary and/or foreign keys designated.
    i. Explain how you designed the tables (suggested length of 1 paragraph).
    c. Design four normalized tables that are in third normal form and fulfill the following requirements:
    • The tables should meet all of the requirements for the first and second normal forms.
    • All transitive dependencies should be removed from the tables.
    • Each of the tables should have all primary and/or foreign keys designated.
    • Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and Total) in your normalization diagrams.
    • There should be four resulting tables: one for customer information, one for donut information, one for order information and one for order line item information.
    i. Explain how you designed the tables (suggested length of 1 paragraph).

    Can someone show me how this is done, with an explanation about the why it wasn't in the correct form and what was done to get it into the correct form?

    Thanks in advance!
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •