InvoiceNormalization-APA.docx - Running head UNIT 2 1 Unit...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Running head: UNIT 2 1 Unit 2 - Normalization American InterContinental University 4/10/2018
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
UNIT 2 2 Unnormalized to Normalized Invoice UNF 1NF 2NF 3NF Orders: Orders: Customers: Order_id Order_id (pk) Order_id (pk) Customer_id (pk) Order_date Order_date Order_date Customer_name Customer_id Customer_id Customer_id Customer_addre ss Customer_name Customer_name Customer_name Customer_city Customer_addre ss Customer_address Customer_addre ss Customer_state Customer_city Customer_city Customer_city Customer_state Customer_state Customer_state Orders: Item_id Order_id (pk) Item_description Items: Order_Item: Customer_id (fk) Item_qty Item_id (pk) Order_id (pk) order_date Item_price Item_description Item_id (pk) Order_total_pric e Item_total_price Item_qty item_qty Order_total_pric e Item_price Order_Item: Item_total_price Items: Order_id (fk) P K Order_total_price Item_id (pk) Item_id (fk) Item_description item_qty Item_price item_total_price Items: Item_id (pk) Item_description Item_price
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern