[solved]-1 Write Sql Code Create Table Structure Table Named Lgproject Lgproject Table Structure Su Q38989221
1) Write the SQL code that will create only the table structurefor a table named LGPROJECT. The LGPROJECT table structure issummarized in the following table. Use PROJ_NUM as the primary key.Note that the EMP_NUM is the FK to LGEMPLOYEE so be certain toenforce referential integrity. Your code should also prevent nullentries in PROJ_NAME.
Field: Type:
PROJ_NUM DECIMAL(2,0)
PROJ_NAME VARCHAR(25)
PROJ_VALUE DECIMAL(14,2)
EMP_NUM DECIMAL(6,0)
FIGURE P7.27 THE CHOZ_LARGECO ERD LGCUSTOMER PK Cust Code LGBRAND PK Brand ID Cust_Fname Cust_Lname Cust_Street Cust_City Cust_State Cust_ZIP Cust_Balance Brand_Name Brand_Type 누 includes places LGLINE LGPRODUCT PK Prod SKU LGINVOICE Iny Num PK PK,FK1 Iny Num PK Line Num be appears on H he contains FK2 FK1 Cust_code Inv_Date Inv_Total FK2 Employee_ID Prod_SKU Line_Qty Line_Price Prod_Descript Prod_Type Prod_Base Prod_Category Prod_Price Prod_QOH Prod_Min Brand_ID FK1 completes provided by LGEMPLOYEE PK Emp Num LGSALARY_HISTORY PK,FK1 Emp Num # has KPK Sal From LGSUPPLIES PK,FK1 Vend ID PK,FK2 Prod SKU Emp_Fname Emp_Lname Emp_Email Emp_Phone Emp_Hiredate Emp_Title Emp_Comm Dept_Num Sal_End Sal_Amount FK1 provides employs mankges LGVENDOR PK Vend ID LGDEPARTMENT PK Dept Num Vend_Name Vend_Street Vend_City Vend_State Vend_ZIP Dept_Name Dept_Mail_Box Dept_Phone FK1 Emp_Num Show transcribed image text FIGURE P7.27 THE CHOZ_LARGECO ERD LGCUSTOMER PK Cust Code LGBRAND PK Brand ID Cust_Fname Cust_Lname Cust_Street Cust_City Cust_State Cust_ZIP Cust_Balance Brand_Name Brand_Type 누 includes places LGLINE LGPRODUCT PK Prod SKU LGINVOICE Iny Num PK PK,FK1 Iny Num PK Line Num be appears on H he contains FK2 FK1 Cust_code Inv_Date Inv_Total FK2 Employee_ID Prod_SKU Line_Qty Line_Price Prod_Descript Prod_Type Prod_Base Prod_Category Prod_Price Prod_QOH Prod_Min Brand_ID FK1 completes provided by LGEMPLOYEE PK Emp Num LGSALARY_HISTORY PK,FK1 Emp Num # has KPK Sal From LGSUPPLIES PK,FK1 Vend ID PK,FK2 Prod SKU Emp_Fname Emp_Lname Emp_Email Emp_Phone Emp_Hiredate Emp_Title Emp_Comm Dept_Num Sal_End Sal_Amount FK1 provides employs mankges LGVENDOR PK Vend ID LGDEPARTMENT PK Dept Num Vend_Name Vend_Street Vend_City Vend_State Vend_ZIP Dept_Name Dept_Mail_Box Dept_Phone FK1 Emp_Num
Expert Answer
Answer to 1) Write the SQL code that will create only the table structure for a table named LGPROJECT. The LGPROJECT table structu… . . .
OR
