CUSTOMER ( CustomerID, CustomerName, CustomerAddress, CreditLimit)

ORDER (OrderID, CustomerID, CustomerPoNumber, OrderDate, DueDate, ShipDate)

PRODUCT( ProductID, ProductDescription, UnitPrice, StockQuentity)

ORDERLINE(ProductID, OrderID)

Business Rules:

Each customer may place multiple orders, and each order may consist of multiple products

Each Customer is serviced by a Sales Representative that is an employee of PSC. A Sales Rep may service multiple customers.

Employees that are Sales Reps are paid commission on their sales based on a commission rate for the Sales Representative. Different Sales Reps may have different commission rates.

All products are purchased from suppliers, and multiple suppliers can provide each product; however, some products can also be fabricated by PSC. Different suppliers charge different amounts for the products. Fabricated products consist of a Bill of Materials that describes the components (parts) of each product. Component parts are products too.

Each employee is required to complete a series of PSC courses. It is essential to document the courses employees complete, as these skills are used to evaluate promotion eligibility.

In Deliverable 2, You will add additional relations and relationships to the relational schema. You must maintain 3rd Normal Form in this enhanced model. Be sure to list your relations in alphabetical order, and be sure to include the relationships between the relations (all of these lines may look a little messy). Also, keep in mind that all of the relations must be shown flush left against the left margin of the page and in alphabetical order. Be sure to use the correct capitalization formatting with RELATION names being singular and in ALL CAPS while attributes are presented using ProperCamel notation. Remember that this logical schema is a listing of the relations and relationships, and it is not in the same format as an ERD.