1. Write the SQL query to create the table structures for the
entities shown in Figure1 ER-Diagram. The structure should contain
the attributes specified in Figure1. Use data types that are
appropriate for the data that will need to be stored in each
attribute. Enforce primary key and foreign key constraints as
indicated by the diagram.
1 Write The Sql Query To Create The Table Structures For The Entities Shown In Figure1 Er Diagram The Structure Should 1 (54.01 KiB) Viewed 77 times
LGCUSTOMER PK Cust Code Cust Frame Cust Lname Cust Street Cust City Cust State Cust ZIP Cust, Balance place LGINVOICE PK Inv Num FK1 Cust Code Inv Date Inv Total FKZ Employee ID completes LGEMPLOYEE PK Emp Num Emp Frame Emp_Lname | Erip Ertunit Emp Phone Emp Hiredate Emp Title Emp_Comm FK1 Dept Num employs manbges LGDEPARTMENT PK Dept Num FK1 Emp Num Dept Name Dept Mail Box Dept Phone contains has LGLINE Inv Num Line Num Prod_SKU Line Qty Line Price LGSALARY HISTORY PK,FK1 Emp Num Sal From Sal End Sal Amount +PK PK.FKI PK FK2 appears of 1 LGBRAND PK Brand ID PK Brand Name Brand Type inclides LGPRODUCT Pred SKU Prod Descript Proc Type Proc Base Proc Category Prod Price Prod QOH Prod_Min FK1 Brand ID provided by LGSUPPLIES PK,FK1 Vend ID PK,FK2 Prod SKU provides LGVENDOR PK Vend ID Vend Name Vend Street Vend City Vond State Vend ZP
Register for solutions, replies, and use board search function. Answer Happy Forum is an archive of questions covering all technical subjects across the Internet.