What is the primary key, candidate keys, foreign keys, and non-key columns in these two tables? In which normal form is the logical design of the purchases database?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

What is the primary key, candidate keys, foreign keys, and non-key columns in these two tables? In which normal form is the logical design of the purchases database?

PURCHASE
InvoiceNumber InvoiceDate PreTaxAmount CustomerID
2014-05-05 155.00
2014-05-07
203.00
2014-05-11
75.00
2014-05-15
67.00
2014-05-15
330.00
2014-05-16 25.00
2014-05-26
45.00
2014-06-06
445.00
2014-06-07
72.00
1
2
WN
3
4
in 50
5
7
8
9
1
2
3
4
5
1
3
1
6
Transcribed Image Text:PURCHASE InvoiceNumber InvoiceDate PreTaxAmount CustomerID 2014-05-05 155.00 2014-05-07 203.00 2014-05-11 75.00 2014-05-15 67.00 2014-05-15 330.00 2014-05-16 25.00 2014-05-26 45.00 2014-06-06 445.00 2014-06-07 72.00 1 2 WN 3 4 in 50 5 7 8 9 1 2 3 4 5 1 3 1 6
PURCHASE_ITE
InvoiceNumber
1
NMT
2
3
4
4
in in 17
5
5
6
8
8
8
00
9
InvoiceLineNumber
1
1
1
1
2
1
2
1
1
1
2
WN
3
1
ItemNumber
1
2
367
4
00
8
10
11
5
9
24
12
14
Retail Price
155.00
120.00
75.00
35.00
32.00
240.00
90.00
25.00
45.00
175.00
215.00
55.00
72.00
Transcribed Image Text:PURCHASE_ITE InvoiceNumber 1 NMT 2 3 4 4 in in 17 5 5 6 8 8 8 00 9 InvoiceLineNumber 1 1 1 1 2 1 2 1 1 1 2 WN 3 1 ItemNumber 1 2 367 4 00 8 10 11 5 9 24 12 14 Retail Price 155.00 120.00 75.00 35.00 32.00 240.00 90.00 25.00 45.00 175.00 215.00 55.00 72.00
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education