Write SQL statements to create tables. Implement all related data integrity constraints. For each column, use the data type as you think appropriate. Declare all integritgtr constraint at the table level.

 

Transcribed Image Text:

Business rule • A product line may (may not) produce a product. Each product is produced in one product line. • A product line is assigned more than one employee. An employee may (may not) be assigned to a product line. • A product may (may not) be a component of another product. • Minimum quantity of product is 100. The quantity on hand cannot be below 100. The line name in the PRODUCT LINE table and the product name in the PRODUCT table should be distinct. • PRODUCT LINE LineID: UID LineName Location is assigned EMPLOYEE Salary Phone is assigned to EmpID: UID FirstName LastName HirsDate produces PRODUCT ProdNo: UID ProdName Category Size is produced in Price QtyOnHand is composed of is composed of Business rule • A product line may (may not) produce a product. Each product is produced in one product line. • A product line is assigned more than one employee. An employee may (may not) be assigned to a product line. • A product may (may not) be a component of another product. • Minimum quantity of product is 100. The quantity on hand cannot be below 100. The line name in the PRODUCT LINE table and the product name in the PRODUCT table should be distinct. • PRODUCT LINE LineID: UID LineName Location is assigned EMPLOYEE Salary Phone is assigned to EmpID: UID FirstName LastName HirsDate produces PRODUCT ProdNo: UID ProdName Category Size is produced in Price QtyOnHand is composed of is composed of

Answer rating: 100% (QA)

Based on the provided business rules and the entityrelationship diagram ERD we can write the SQL statements to create the tables for the PRODUCTLINE P... View the full answer