PVF CUSTOMER ORDER

ORDER N$0$: $61384$

CUSTOMER NO: $1273$

NAME:

ADDRESS:

CITY$-$STATE$-$ZIP:

Contemporary Designs

$1230$ak St$.$

Austin, TX $28384$

PROMISED DATE: $\frac{11}{21}\frac{?}{2015}$

ORDER DATE: $\frac{11}{04}\frac{?}{2015}$

$\backslash$table$[[\backslash$table$[[$PRODUCT$],[$N$0]],$DESCRIPTION,$\backslash$table$[[$QUANTITY$],[$ORDERED$]],\backslash$table$[[$UNIT$],[$PRICE$]]],[$M$128,$Bookcase,$4,200\mathrm{.}00],[$B$381,$Cabinet,$2,150\mathrm{.}00],[$R$210,$Table,$1,500\mathrm{.}00]]$

Based on the above sample customer order, you are required to complete the following tasks with Oracle database and tools:

Develop an $E-$R diagram $($both logical and relational models$)$ with the appropriate cardinality notations; select appropriate data types. The database should be normalized to the third normal form or higher. $(10$ points$)$

Generate DDL from the data model and create tables in the Oracle database. $(10$ points$)$

Write a script to insert test data $($at least $1$ customer, $1$ order and $3$ products$)$ into the tables. The data must be inserted in the correct order to avoid referential integrity violations. $(10$ points$)$

Create a VIEW to show Customer Name, Address $($including street address, city, state, and zip in one field$),$ Order Date, Number of Products Ordered, and Total Price. Write a select statement to test the view. $(10$ points$)$