View more random threads:
- CS408 Human Computer Interaction Assignment No 2 Solution...
- CS403 Database Management System Assignment No. 3 spring...
- CS504 Software Engineering-1Assignment no 2 Fall 16...
- Cs401 Assignment no 5 fall January 2012 solution
- FIN621 Financial Statement Analysis Assignment No.2...
- cs504 assignment no 1 Spring 2011 idea solution of software...
- CS402 Theory of Automata idea solution assignment no 3...
- CS304 Assignment no 3 Solution 20th January 2016
- CS606 Compiler Construction Assignment No.1 Solution Spring...
- CS403 Database Management Systems assign Assignment No. 04...
CS614 Data Warehousing Assignment No.4 Fall Semester 2013 Due Date 23-1-2013
Assignment No. 04
Semester Fall 2012
Data Warehousing-CS614
Total Marks: 15
Due Date: 23/01/2013
Objective:
To learn and understand the physical implementation of “Multi Fact Table Star Schema”.
14. Process of Dimensional Modeling
Instructions:
Please read the following instructions carefully before solving & submitting the assignment:
It should be clear that your assignment will not get any credit (get zero marks) if:
o The assignment is submitted after due date.
o The submitted assignment does not open.
o The submitted assignment is in the format other than MS Access Database (.mdb or accdb).
o The assignment is copied from other student or from internet.
For any query about the assignment, contact at cs614@vu.edu.pk
GOOD LUCK
Q: Physically design the given “Star Schema” in MS Access?
(Star Schema is given on the next page)
Sponsored Links
Instructions
• SQL Queries are not required.
• Use appropriate data types for the table attributes.
• Primary-Foreign key Constraints (Referential Integrity) must be implemented.
• Enter raw data in the tables. Each table should have 2 rows.
• There should not be any “null value” in any table.
• Only MS Access Database files will be accepted.
• Do not send the archived file (.zip/.rar etc).
“Try to upload the assignment before BONUS day”
There are currently 1 users browsing this thread. (0 members and 1 guests)