Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

Microsoft Visual C#
Microsoft Visual C#
7th Edition
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Joyce, Farrell.
Chapter12: Using Controls
Section: Chapter Questions
Problem 9E
See similar textbooks
icon
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
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
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Normalization
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
Microsoft Visual C#
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
SEE MORE TEXTBOOKS