Complete the following data model by creating an Entity Relationship Diagram in PowerArchitect. Transform your ERD data model into a database design by creating a Relational Schema Diagram (RSD) in PowerArchitect. Using the Tools menu, forward engineer your diagram into a SQL script for Oracle 9i/10g. Save the script as MakeCAP.sql in a folder you create (example C:\MyScripts). Log in to Oracle using SQL*Plus and execute the MakeCAP script. Then execute the LoadCAP.sql script given to you by your instructor. Create a spool file showing the contents of each table. Modify your database design to allow a customer to specify more than one product on a single order. Submit three files: MakeCAP.sql, CAPDB.lst, and CAP.pdf. See Tips for Completing the Unit 4 Assignment.

CUSTOMERS A table containing information about customers

cid char(4) unique identifier

cname up to 13 characters name of a customer

city up to 20 characters city where customers headquarters is located

disnct number(4,2) customers discount

AGENTS A table containing information about agent employees

aid char(3) unique identifier

aname up to 13 characters last name of agent

city up to 20 characters city where agent is based

percent number(3) percentage commission agent receives on a sale

PRODUCTS A table containing information about products for sale

pid char(3) unique identifier

pname up to 13 characters descriptive name of product

city up to 20 characters city where this product is warehoused

quantity number(10) quantity on hand for sale

price number(3,2) wholesale price of each product

ORDERS A table containing information about orders

ordno number(6) unique identifier

month char(3) three character abreviation for month order was placed

cid customer placing order

aid agent handling customers order

pid product ordered

qty number(6) quantity of product (pid) on this order

dollars number(6,2) cost in dollars of this order

RELATIONSHIP			CARDINALITY
PARENT	CHILD	TYPE	MAX	MIN
CUSTOMERS	ORDERS	Strong Non ID-dependent	1:N	M-O
AGENTS	ORDERS	Strong Non ID-dependent	1:N	M-O
PRODUCTS	ORDERS	Strong Non ID-dependent	1:N	M-O