Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Create the VEHICLES star schema dimension table via SQL

/in /by

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. (I’m needing help with using the sequence to populate the description and using the cursor in a loop!!)

TIMESale_Day (PK)Day_TypeSALES_FACTSSale_Day (FK)Vehicle_Code (FK)Plan_Code (FK)Dealer_ID (FK)Vehicles_SoldGross_Sales_Amt…FINANCING_PLANSPlan_Code (PK)Loan_TypeInstitution_NameLoan_Perc_RateMin_DownMax_Loan_AmountMax_TermDEALERSHIPSDealer_ID (PK)LocationRegion_IDStreet AddressCityStateZip CodePhoneSq FtOpened DateManagerDistrict_IDVEHICLESVehicle_Code (PK)DescriptionStar Schema for OVS, Inc. Data Warehousea singlefactPK ofa factcalculated valuesfor each fact
Background image of page 1
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"