MySQL Sample Database Diagram

Run the following queries to create the complete database.
Check the order in which you need to create the database.
Make sure to consider the Primary and Foreign Key constraints

 

Transcribed Image Text:

TH productlines productLine textDescription htmlDescription image employees employeeNumber lastName firstName extension email officeCode reports To job Title offices "officeCode city phone addressLine1 addressLine2 state country postalCode territory HHH products productCode productName productLine productScale productVendor product Description quantityInStock buyPrice MSRP customers "customerNumber customerName contactLastName contactFirstName city state phone addressLine1 addressLine2 postalCode country salesRepEmployeeNumber creditLimit HHH HHH H+ et et orderdetails orderNumber *productCode quantityOrdered priceEach orderLineNumber orders orderNumber order Date requiredDate shippedDate status comments customerNumber payments customerNumber *checkNumber paymentDate. amount TH productlines productLine textDescription htmlDescription image employees employeeNumber lastName firstName extension email officeCode reports To job Title offices "officeCode city phone addressLine1 addressLine2 state country postalCode territory HHH products productCode productName productLine productScale productVendor product Description quantityInStock buyPrice MSRP customers "customerNumber customerName contactLastName contactFirstName city state phone addressLine1 addressLine2 postalCode country salesRepEmployeeNumber creditLimit HHH HHH H+ et et orderdetails orderNumber *productCode quantityOrdered priceEach orderLineNumber orders orderNumber order Date requiredDate shippedDate status comments customerNumber payments customerNumber *checkNumber paymentDate. amount

Answer rating: 100% (QA)

The order of creation of database is as follows PRODUCTLINES CUSTOMERS PRODUCTS ORDERDETAILS ORDERS ... View the full answer