LEARN MORE...

Access over 20 million homework & study documents

Create the VEHICLES star schema dimension table via SQL Change your

Content type
User Generated
Rating
Showing Page:
1/3
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 colum n
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. (I\'m needing help with using the
sequence to populate the description and using the cursor
in a loop!!) Star Schema for OVS, Inc. Data Warehouse
VEHICLES Vehicle Code (PK) SALES FACTS Description
TIME Sale_Day (FK) Vehicle_Code (FK) Plan_Code (FK)
Dealer_ID (FK) Vehicles Sold Gross Sales Amt Sale_Day
(PK) Day_Type DEALERSHIPS PK of a fact a single fact
Dealer ID (PK) Location Region_ID calculated values for
each fact Street Address City State Zip Code Phone Sq Ft
Opened Date Manager District ID FINANCING PLANS Plan
Code (PK) Loan_Type Institution Nam e -oan Perc_ Rate
Min Down Max Loan Amount Max Term

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/3
Solution
1. CREATE TABLE VEHICLES ( VECHILE_CODE
VARCHAR2(50) PRIMARY KEY, DESCRIPTION
VARCHAR2(100));
2. RENAME TABLE OLTPVEHICLES TO OLTP_VEHICLES;
3. ALTER TABLE SALES DROP CONSTRAINT
VEHICLE_CODE;
4. ALTER TABLE SALES ADD CONSTRAINT
VEHICLES.VEHICLE_CODE ENABLE NOVALIDATE;
5. CREATE SEQUENCE VEHICLE_SEQUENCE
start with 1
increment by 1
minvalue 1
maxvalue 10000;
6. DECLARE DESC VARCHAR2;
CURSOR v_data is
select description
from OLTP_VEHICLES;
BEGIN

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
Name: Description: ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Honor Code
flag Report DMCA

Review

Review

Honor Code
flag Report DMCA
Anonymous
I use Studypool every time I need help studying, and it never disappoints.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents

reflection on "lottery"
Read the short story "The Lottery" (it's an easy read) that is in Backpack Literature book and share two or three literary...
NRS451VN Grand Canyon University Effective Approaches in Leadership Essay
In this assignment, you will be writing a 1,000-1,250 word paper describing the differing approaches of nursing leaders an...
The kid was a brat, english assignment help
Below is a Screenshot of the assignment and a screen shot of an example. Thanks for the help.Isabella...
Lifespan assignment
please fill out these papers , make sure to use the textbook that needed.Let me know if you've any questions.TEXTBOOK: EXP...
HU The Best Duration of Treatment of Antibiotic Infections Summary
Please summarize article....
UWG Use of Offender Profiling Evidence in Criminal Cases Discussion
Correct use of APA and grammar is worth 20% of this paper.Here is a helpful website with APA citation: https://owl.english...
Pioneering work in science can be dangerous Give examples of scient
unbeknownst to them, been hazardous to their health and potentially to that of their children. Do you think that such...
Ppsc lecturer economics mcqs past papers pdf
For PPSC, FPSC, SPSC,BPSC,NTS, OTS, Lecturers, Educators, Police, Motor ways, ASF, Patrol officers etc. Jobs preparations,...
Framing Persuasion
Framing persuasion is the process in which a source of communication defines or constructs a political or social issue to ...