In which normal form (unnormalised, first normal form, second normal form or third normal form) is each of the below? Clearly motivate your answer

C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter18: Stacks And Queues
Section: Chapter Questions
Problem 18PE
icon
Related questions
Question

In which normal form (unnormalised, first normal form, second normal form or
third normal form) is each of the below? Clearly motivate your answer

19; 20; 21
2021
Q.5.2.1
issued to
1.1
Customer
Invoice
1.*
InvoiceID {PK}
CustomerID {FK}
Number
CustomerID {PK}
Name
Surname
Date
1.1
contains
1.*
InvoiceLine
InvoiceLineID {PK}
InvoiceID {FK}
Description
Price
(3)
Transcribed Image Text:19; 20; 21 2021 Q.5.2.1 issued to 1.1 Customer Invoice 1.* InvoiceID {PK} CustomerID {FK} Number CustomerID {PK} Name Surname Date 1.1 contains 1.* InvoiceLine InvoiceLineID {PK} InvoiceID {FK} Description Price (3)
Expert Solution
steps

Step by step

Solved in 7 steps with 7 images

Blurred answer
Knowledge Booster
Asymptotic Analysis
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
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning