Question
1.Please create a datawarehouse; (20 points) IF YOU CAN I WOULD BE VERY HAPPY, THANK YOU VERY MUCH IN ADVENCE. :D I NEED TO PASS
1.Please create a datawarehouse; (20 points) IF YOU CAN I WOULD BE VERY HAPPY, THANK YOU VERY MUCH IN ADVENCE. :D I NEED TO PASS THIS COURSE :d about a subjects (for exp. Students, Employees, Products, Properties, Sales,Customers,Books, Club_Memberships, Hobbies, etc.) Min. three tables (one fact table, two dimention table) (star schema) Fact table has min. two foreign keys, dimention tables have primary key,unique,not null and check constraints.
Write or paste SQL commands (create table ..) and describe (structure of tables) below:
2. Create a complex view that joining three tables with group by rollup. (10 points) Write or paste SQL commands below:
3.Create a non-unique index on fact table for foreign key columns. (10 points) Write or paste SQL commands below:
4. Create a sequence for primary key column on dimention tables. (10 points) Write or paste SQL commands below:
5.Insert any 3 records to each table. (10 points) Write or paste SQL commands below:
6.Update at least one record on each table. (10 points) Write or paste SQL command/s below:
7.Create a blank copy for your fact table. Merge the records from original fact table to copy table. (10 points) Write or paste SQL command/s below:
8. Write odd or even in case of last character of primary key value. (10 points) Write or paste SQL command/s below:
, 9. How to lists top 3 records for any column on your tables. (10 points) Write or paste SQL command/s below:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started