Assume the simplified problem statement for sales company database

The company sells a number of different products.

Each product is identified by a is Product$\_$ID $($NUMBER$(3)),$ and would have Name

$($P$\_$Name $($VARChar$2(30)))$ and price $($P$\_$Price $($NUMBER $(3))$ attributes.

We can assume that no two customers have the same Customer$\_$ID $(($NUMBER$(3)),$ so

the Customer$\_$ID is the key.

Other attributes include Customer Name $($C$\_$Name Varchar$2(30))$ and Customer

Address $($C$\_$Address $($VARCHAR$2(30)).$

Customers place orders for products. The identifier for an order is Order$-$ID

$($NUMBER $(3)),$ and another attribute is Order$\_$Date.

A customer may place any number of orders, but need not place any orders.

Each order is placed by exactly one customer.

A given customer order must request at least one product.

Any product may not be requested on any order. or may be requested on one or more

orders.

An attribute associated with each order and product is Quantity $($

the number of units requested.

Exercise $1$

Transfer the verbal description of the sales company database into an ERM $($using

ERDPlus.com$)$

Exercise $2$

Transfer the ERM into a RM

Exercise $3$

Create the required database tables