You will also begin the creation of a data warehouse database for Online Vehicle Sales (OVS), Inc....

Question

You will also begin the creation of a data warehouse database for Online Vehicle Sales (OVS), Inc. The full data warehouse is comprised of 4 dimension tables and a fact table based on the Star Schema diagram posted in LEO’s Week #6 area. Your OLTP database tables and star schema tables will reside in the same Oracle schema. This assignment is based on the fully populated tables from Homework #2 so it assumes you’ve completed all work for that assignment. You can perform this assignment based on a database on Nova or any other Oracle system you wish, but you must use the Oracle RDBMS. You should use one or more SQL script files to complete this assignment. Your script files should contain all your SQL and PL/SQL code. Do NOT submit your SQL script files. Doing so may result in confusion and will result in lost points. Everything for this assignment must be in a single file. If you are using SQL*Plus you must put all your SQL, PL/SQL, and results together in a single SPOOL file. If you are using SQL Developer or other GUI, put all your screen snapshots in a single file for both your SQL statements and PL/SQL as they executed and the results. Failure to include all your SQL, PL/SQL, and all your results along with them will result in lost points. Do NOT submit additional files
	
Document Preview: Project 3 
In this assignment you will be performing some additional queries against your Online Vehicle Sales 
(OVS), Inc. online transaction processing (OLTP) database and also creating some simple anonymous 
PL/SQL blocks.  
You will also begin the creation of a data warehouse database for Online Vehicle Sales (OVS), Inc.  The 
full data warehouse is comprised of 4 dimension tables and a fact table based on the Star Schema 
diagram posted in LEO’s Week #6 area.  Your OLTP database tables and star schema tables will reside in 
the same Oracle schema. 
This assignment is based on the fully populated tables from Homework #2 so it assumes you’ve 
completed all work for that assignment. 
You can perform this assignment based on a database on Nova or any other Oracle system you wish, but 
you must use the Oracle RDBMS. 
You should use one or more SQL script files to complete this assignment.  Your script files should contain 
all your SQL and PL/SQL code.  Do NOT submit your SQL script files.  Doing so may result in confusion 
and will result in lost points. 
Everything for this assignment must be in a single file.  If you are using SQL*Plus you must put all your 
SQL, PL/SQL, and results together in a single SPOOL file.  If you are using SQL Developer or other GUI, 
put all your screen snapshots in a single file for both your SQL statements and PL/SQL as they executed 
and the results.  Failure to include all your SQL, PL/SQL, and all your results along with them will result in 
lost points. 
Do NOT submit additional files as this only complicates the grading, and will result in lost points. 
Here are the specific assignment steps.  In order to earn full credit you must keep your steps in order, 
number your steps, and put everything in a single file. 
1)     Execute SELECT COUNT(*) FROM ; statements for all 6 of your OVS, Inc. OLTP 
tables.  You should have at least the following counts: CUSTOMERS table – 100 rows, VEHICLES table – 
50 rows,...

Robert · Accepted Answer

A) CREATE TABLES: 
a) Create DEALERSHIPS TABLE:
b) Rename Vehicles table:
c) Combinations of Make and Model (Showing 17 different combinations):
B) INSERT SQL statements
C) SELECT SQL statements and other Anonymous Blocks: 
1) Count of rows: 
a) CUSTOMERS Table:
b) VEHICLES Table:

You will also begin the creation of a data warehouse database for Online Vehicle Sales (OVS), Inc. The full data warehouse is comprised of 4 dimension tables and a fact table based on the Star Schema...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment