Cmis-420 project #2 | Computer Science homework help

In this assignment you will be creating a data warehouse database for Online Vehicle Sales (OVS), Inc.  The data warehouse is comprised of 4 dimension tables and a fact table based on the Project #2 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.


Everything for this assignment must be in a single file. Using SQL*Plus, you must put all your SQL, PL/SQL, and results together in a single SPOOL file.  


The specific assignment steps are listed below.  In order to earn full credit you must keep your steps in the order shown, number your steps, and put everything in a single file.


Your FINANCING_PLANS table should already be created and populated.  Your Plan_ID primary key is the Plan_Code column.  Don’t worry about changing this to Plan_Code or changing any other column names you already have.


1)     Create the DEALERSHIPS star schema dimension table via SQL.  Add at least 2 rows of data via INSERT statement(s).  After populating your DEALERSHIPS table execute a “SELECT * FROM dealerships;” SQL statement to display the entire contents.  Show all your SQL code for this step and the Oracle results from executing it. 


2)     Create the VEHICLES star schema dimension table via SQL.  Change your existing OLTP VEHICLES table to OLTP_VEHICLES via the SQL RENAME command and change your SALES table’s foreign key to reference this new table name.  For the Vehicle_Code primary key column use an Oracle sequence to populate the values.  For the Description column use all concatenated combinations of Make and Model of vehicles you have.  Use a PL/SQL block to populate the Description column by SELECTing the combinations from your OLTP_VEHICLES table and then INSERTing the combinations into your new VEHICLES table, which would best be performed via a cursor in a loop.  After populating your VEHICLES table execute a “SELECT * FROM vehicles ORDER BY vehicle_code” SQL statement to display the entire contents.  Show all your SQL and PL/SQL code for this step and the Oracle results from executing it. 


3)     Create the TIMES star schema dimension table via SQL.  This is “TIME” table in the star schema figure.  The Sale_Day primary key column values should be all dates from your first sale date through and including your last sale date from your SALES table.  The Day_Type values should be ‘Weekday’, ‘Weekend’, or ‘Holiday’ (this trumps Weekday and Weekend).  Set all occurrences of the following days for your date range to be holidays: New Year’s Day, Martin Luther King Jr’s Birthday, President’s Day, Memorial Day, 4th of July, Labor Day, Columbus Day, Veterans Day, Thanksgiving, and Christmas.  Use a PL/SQL block to populate the TIMES table.  After populating your TIMES table execute the SQL statement “SELECT day_type, COUNT(*),MIN(sale_day),MAX(sale_day) FROM time GROUP BY day_type ORDER BY day_type” to show the summarized contents of your table.  Show all your SQL and PL/SQL code for this step and the results.


4)     Create the SALES_FACTS star schema fact table via SQL.  Ensure that you have declared foreign keys of Sale_Day, Vehicle_Code, Plan_Code, and Dealer_ID to reference your TIMES, VEHICLES, FINANCING_PLANS, and DEALERSHIPS tables, respectfully.  Ensure that you have a primary key for the SALES_FACTS table that is a composite of the Sale_Day, Vehicle_Code, Plan_Code, and Dealer_ID columns.  Do a DESC (i.e. DESCRIBE) of your SALES_FACTS table after it’s created.


Your submission MUST be in a single Word or PDF file with all steps numbered and in order.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Be keen on plagiarism.
Customer 454463, March 28th, 2022
Good job
Customer 456821, December 26th, 2022
Business and administrative studies
I received a mastery on this assignment!
Customer 463143, August 31st, 2022
Job well done!!!
Customer 453939, February 24th, 2020
Really beautiful, beautiful work here. Well done! I love this service so much!
Customer 454259, April 11th, 2020
Entertainment & Gaming
Customer 452441, April 29th, 2022
very good job
Customer 456821, August 3rd, 2022
Business and administrative studies
Good work.
Customer 458115, June 9th, 2022
Business Studies
Excellent work
Customer 453413, February 14th, 2020
well done
Customer 463813, May 11th, 2023
Business Studies
Good Job. Thanks
Customer 453413, April 29th, 2020
Just impeccable!
Customer 463001, May 19th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat