DATABASE ARCHITECTURE AND DESIGN

 

IT 8100 DATABASE ARCHITECTURE AND DESIGN

“Contract-Supplier System”

ERD Conceptual Model

Group Activity 2 “Contract-Supplier System”

3

• A company negotiates contracts with suppliers to provide certain amount of items at a fixed price

 • Orders are placed against any of the already  negotiated contracts 

• A contract could provide items to any number of  orders.

 • An order may include any number of items negotiated in the contract

 • Orders should not exceed the maximum amount of items quoted in the contract 

• All items in an order must be provided as part of a single contract and a single project ERD Conceptual Model

Group Activity 2 “Contract-Supplier System”

Create the Entity Relationship Diagram (ERD) Conceptual Design