Insert
Design
Layout
References
Mailings
Review
X
Calibri (Body)
14
A-A
Aa
B
abe
X
A
Update To keep up-to-date with security updates, fixes, and improvements
Check for
Date: 12/14/2023
PVF CUSTOMER ORDER CUSTOMER NO: 1273
ORDER NO: 61384
NAME: ADDRESS: CITY-STATE-ZIP:
Contemporary Designs 123 Oak St. Austin, TX 28384
ORDER DATE: 11/04/2015
PROMISED DATE: 11/21/2015
PRODUCT NO DESCRIPTION
QUANTITY ORDERED
UNIT PRICE
M128 B381 R210
Bookcase Cabinet Table
4 2 1
200.00 150.00 500.00
Based on the above sample customer order, you are required to complete the following tasks with Oracle database and tools:
1. Develop an E-R diagram (both logical and relational models) with the appropriate cardinality
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)
2. 1
4
Submit screenshots and scripts to show your work.
