Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David M. Kroenke

12th Edition International Edition

1292023422, 978-1292023427

More Books

Students also viewed these Databases questions