Assignment No. 02
Deadline date:
Your assignment must be uploaded/submitted before or on November 10, 2009.
Assignment Marks: 20
Assignment Topic:
Topics covered in this assignment are basic data warehouse concepts.
Uploading instructions
Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.
Rules for Marking
It should be clear that your assignment will not get any credit if:
o The assignment is submitted after due date
o The assignment is copied
Objective
o To learn and understand basic data warehouse concepts.
Problems
Q No. 1 20
An automobile Company XYZ has dealerships in different cities. These dealers provide products and services to their customers. Automobile company assesses their dealers with the feed back of their customers through e-mail. On the basis of this evaluation by the customers, Company XYZ makes a decision, whether dealers are providing proper services to their customers or not.
You are required to find the total attributes of all the relations used in this scenario, find the Facts for the fact table and also draw the star schema of the given scenario.
Deadline date:
Your assignment must be uploaded/submitted before or on November 10, 2009.
Assignment Marks: 20
Assignment Topic:
Topics covered in this assignment are basic data warehouse concepts.
Uploading instructions
Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.
Rules for Marking
It should be clear that your assignment will not get any credit if:
o The assignment is submitted after due date
o The assignment is copied
Objective
o To learn and understand basic data warehouse concepts.
Problems
Q No. 1 20
An automobile Company XYZ has dealerships in different cities. These dealers provide products and services to their customers. Automobile company assesses their dealers with the feed back of their customers through e-mail. On the basis of this evaluation by the customers, Company XYZ makes a decision, whether dealers are providing proper services to their customers or not.
You are required to find the total attributes of all the relations used in this scenario, find the Facts for the fact table and also draw the star schema of the given scenario.
Solution can be
Given attributes
car(vin, make, model, year, mileage, price)
dealership(deal_id, deal_name, deal_street, deal_city, deal_state)
salesperson(sales_id, name)
customer(SSN, cust_name, street, city,address)
sale(vin, SSN, sales_id, deal_id, price,date)
car(vin, make, model, year, mileage, price)
dealership(deal_id, deal_name, deal_street, deal_city, deal_state)
salesperson(sales_id, name)
customer(SSN, cust_name, street, city,address)
sale(vin, SSN, sales_id, deal_id, price,date)
regards
Here is hint for you make this one
Post a Comment