Question

Sample data is provided for the database for the sales system. Using the sample data, you will determine the entities, key components of the entities, and business rules for the entities. Using the entities and business rules you will then create an ERD. Tasks:

1. For each entity provide the name, description, fields, data type, primary key, and foreign key.

2. For each direct entity type pair, provide the business rules.

3. Provide the ERD.

Customer Table

Customer ID, Last Name, First Name, Street Address, City, State, Zip Code, Current Balance, Credit Limit, Sales Rep. ID

Sales Representatives Table

Sales Rep ID, Last Name, First Name, Street Address, City, State, Zip, Region, Region Description, Total Commission, Commission Rate

Orders Table

Order ID, Order Date, Customer, Shipping Date,

Order Lines

Order ID, Part ID, Number Ordered, Quoted Price

Part Table

Part ID, Part Description, Units on Hand, Class, Warehouse Number, Unit Price

Answer 1