Converting user form into 1nf and 2nf

Assignment Help Database Management System

Reference no: EM1352419

Q1) 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. Explain the table characteristics identifying correct conversion into 1NF and 2NF. You can provide your response in a word document.

Invoice CompanyName Acct Balance Acct Limit Part1 Quantity1 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

Reference no: EM1352419

Questions Cloud

Explain if an investment does not fit with an organization : Explain If an investment does not fit with an organization's strategic plan and Under what conditions would this be a true statement?

Manage effectively the competing demands : Explain how exactly would you reconcile and manage effectively the competing demands that are surfacing even before you start your official job duties?

Elucidate information about the economy of nocoin : You are given the following information about the economy of Nocoin: The banks have submitted of $300 billion, two thirds of which is in deposits with the central bank.

Fundamentals of psychology : what are the two first school of thought that emerged in psychology? what did they focus on? what did behaviorism focus on?what was the focus of humaistic psychology?

Converting user form into 1nf and 2nf : Complete database exercise by converting user form located the evaluation procedures section of the syllabus into 1NF and 2NF.

Managing organizational behavior : Dsecribe how these elements of communication can impact individual behavior in managing organizational behavior.

During the collision at the bottom of the elevator shaft : What are the magnitudes of the (a) impulse and (b) average force on the passenger during the collision? If the passenger were to jump upward with a speed of 6.00 m/s relative to the cab floor just before the cab hits the bottom of the shaft, what ..

Hotel performance indicators : How are performance indicators linked to an organization's strategic plans, and how can be used? Please give examples which relate to the hospitality industry, in particular Hotels.

Explain how does your graph relate to the other two graphs : Explain how does your graph relate to the other two graphs. What do any of these graphs have to do with price discrimination.

User Account

All Pages