Question: Create Table: Using the following Sales Database, create the tables for each table using the CREATE TABLE Command to represent the ABC Sales Database. ABC

 Create Table: Using the following Sales Database, create the tables for

Create Table: Using the following Sales Database, create the tables for each table using the CREATE TABLE Command to represent the ABC Sales Database. ABC Sales Database ERD: LINE +4PK PK,FK1 INV NUMDER LINE NUMBER CUSTOMER INVOICE PK CUS CODE generates. PK HE INV NUMBER od + contains CUS LNANE FK1 CUS_CODE CUS FNANE INV DATE CUS_INITIAL CUS AREACODE CUS PHONE CUS_BALANCE FK2 P CODE LINE UNITS LINE PRICE % is found in VENDOR PRODUCT PKY CODE PK P_CODE HF - Supplies V_NAME V CONTACT V AREACODE V PHONE V_STATE V_ORDER P_DESCRIPT 0 P_INDATE P OOH P MIN P PRICE P_DISCOUNT FK V CODE . The database model reflects the following business rules: A customer may generate many invoices. Each invoice is generated by one customer. An invoice contains one or more invoice lines. Each invoice line is associated with one invoice Each invoice line references one product. A product may be found in many invoice lines. (You can sell more than one hammer to more than one customer.) A vendor may supply many products. Some vendors do not (yet?) supply products. (For example, a vendor list may include potential vendors.) If a product is vendor-supplied, product is supplied by only a single vendor. Some products are not supplied by a vendor. (For example, some products may be produced in-house or bought on the open market.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!