Answered: LGCUSTCMER LGBRAND PK Cust Code PK…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

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.

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 inclldes plafes LGPRODUCT LGLINE PK Prod SKU LGINVOICE PK FK1 Inv Num Line Num Prod_Descript Proc_Type Proc_Base Proc_Calegory Prod_Price Prod_QOH Prod_Min FK1 Brand_I0 PK Inv Num appears on - PK contains 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 Dep 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 Name Vend Street Vend City Vend_State Vend ZP PK Dept Num Dept Name Dept_Mail_Box Dept Phone FK1 Emp_Num HE

Expert Solution