{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Week 5 Assignment - CompanyName AcctBalance AcctLimit...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Week 5 Assignment – User Form: Complete database exercise by converting user form located the evaluation procedures section of the syllabus into 1NF and 2NF. Remember to identify your primary keys for 1NF and 2NF. Your 1NF and 2NF response should use the shorthand representation of the tables (See page 32 of the textbook). . Explain the table characteristics identifying correct conversion into 1NF and 2NF. You can provide your response in a word document. 1NF: Invoice CompanyName, AcctBalanace, AcctLimit, Part1, Quantity1, Price1, Part2, Quantity2, Price2 2NF: Invoice (Part1, Quantity1, Price1)(Part2, Quantity2, Price2)
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CompanyName AcctBalance, AcctLimit Invoic e CompanyName Acct Balance Acct Limit Part1 Quantity 1 Price1 Part2 Quantity2 Price2 87 Mary’s IT Services 5000 20000 Bolt 50 10 Nut 40 20 72 Mel’s Hotdogs 7200 7200 Bolt 100 10 Screw 45 30 57 Brookings 500 12000 Screw 60 30 Bolt 65 10 67 Parker’s 1000 5000 Nut 70 20 3 Action Computer’s 1000 10000 Screw 40 30 7 Kline’s 8000 9999 Bolt 30 10 9 John’s 10000 30000 Nail 25 50 17 Lee’s 700 1000 Bolt 75 10 Nail 120 50 19 Al’s 7000 7000 Screw 110 30 20 Al’s 7000 7000 Nut 90 20...
View Full 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