LGCUSTCMER LGBRAND PK Cust Code PK Brand ID Cust Fname Cust Lname Cust Street Cust City Cust State Cust ZIP Cust Balance Brand Nerne Brand Type indildes
LGCUSTCMER LGBRAND PK Cust Code PK Brand ID Cust Fname Cust Lname Cust Street Cust City Cust State Cust ZIP Cust Balance Brand Nerne Brand Type indildes
Chapter12: Using Controls
Section: Chapter Questions
Problem 9E
Related questions
Question
Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not in Third Normal Form, explain why. Show PK and FK for each relation.
![LGCUSTCMER
LGBRAND
PK Cust Code
PK Brand ID
Cust Fname
Cust Lname
Cust Street
Cust City
Cust State
Cust ZIP
Cust Balance
Brand Name
Brand Type
indildes
LGPRODUCT
LGLINE
Prod_SKU
PK
LGINVOICE
PK.FK1 Inv_Num
PK
Prod Descript
Proc Type
Proc_Base
Proc_Calegory
Prod Price
Prod QOH
Prod_Min
FK1 Brand_ID
PK Inv Num
Line_Num
appears on
contains
%23
FK1 Cust Code
Inv Date
Inv_Total
FK2 Employee_ID
Prod SKU
Line Qty
Line Price
FK2
completes
provided by
LGEMPLOYEE
PK Emp Num
LGSALARY HISTORY
LGSUPPLIES
Emp_Fname
Emp Lname
Emp Email
Emp Phone
Emp_Hiredate
Emp_Title
Emp Comm
FK1 Dept Num
PK, FK1 Emp_Num
PK
PK,FK1 Vend ID
PK,FK2 Prod SKU
has
Sal From
Sal End
Sal Amount
४
provides
employs
manbges
LGVENDOR
PK Vend ID
LGDEPARTMENT
Vend_Narme
Vend Street
Vend City
Vend State
Vend ZP
PK
Dept Num
Dept Name
Dept Mail Box
Dept Phone
FK1 Emp_Num](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc756dd5b-24c2-4ec7-8ec9-ef247ff00e41%2F40786b78-813b-4f4e-af47-320d8691b8a8%2Fffcpwf_processed.png&w=3840&q=75)
Transcribed Image Text:LGCUSTCMER
LGBRAND
PK Cust Code
PK Brand ID
Cust Fname
Cust Lname
Cust Street
Cust City
Cust State
Cust ZIP
Cust Balance
Brand Name
Brand Type
indildes
LGPRODUCT
LGLINE
Prod_SKU
PK
LGINVOICE
PK.FK1 Inv_Num
PK
Prod Descript
Proc Type
Proc_Base
Proc_Calegory
Prod Price
Prod QOH
Prod_Min
FK1 Brand_ID
PK Inv Num
Line_Num
appears on
contains
%23
FK1 Cust Code
Inv Date
Inv_Total
FK2 Employee_ID
Prod SKU
Line Qty
Line Price
FK2
completes
provided by
LGEMPLOYEE
PK Emp Num
LGSALARY HISTORY
LGSUPPLIES
Emp_Fname
Emp Lname
Emp Email
Emp Phone
Emp_Hiredate
Emp_Title
Emp Comm
FK1 Dept Num
PK, FK1 Emp_Num
PK
PK,FK1 Vend ID
PK,FK2 Prod SKU
has
Sal From
Sal End
Sal Amount
४
provides
employs
manbges
LGVENDOR
PK Vend ID
LGDEPARTMENT
Vend_Narme
Vend Street
Vend City
Vend State
Vend ZP
PK
Dept Num
Dept Name
Dept Mail Box
Dept Phone
FK1 Emp_Num
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Microsoft Visual C#](https://www.bartleby.com/isbn_cover_images/9781337102100/9781337102100_smallCoverImage.gif)
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,
![New Perspectives on HTML5, CSS3, and JavaScript](https://www.bartleby.com/isbn_cover_images/9781305503922/9781305503922_smallCoverImage.gif)
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
![Microsoft Visual C#](https://www.bartleby.com/isbn_cover_images/9781337102100/9781337102100_smallCoverImage.gif)
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,
![New Perspectives on HTML5, CSS3, and JavaScript](https://www.bartleby.com/isbn_cover_images/9781305503922/9781305503922_smallCoverImage.gif)
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning