Assignment No. 1
Semester: Fall 2019
CS614 – Data Warehousing
Total Marks: 15
November 14, 2019
After completing this assignment the students will be able to:
• Identify Database entities from a given scenario
• Understand the database table structure
• Normalize a database table up to 2nd normal form
• De-normalize relationships using collapsing table technique
Please read the following instructions carefully before submitting assignment:
It should be clear that your assignment will not get any credit if:
o Assignment is submitted after due date.
o Submitted assignment does not open or file is corrupt.
o Assignment is copied (From internet/ to from students).
o Assignment is submitted other than word format (.doc, .docx).
Question No. 1
Consider the following schema related to a Social Media website named as ‘userPosts’. You have to perform following tasks related to the provided schema:
1- Identify appropriate keys for following structure (Primary and/or foreign key(s))
2- Convert this schema into 2 NF
userPosts (userID, userName, password, address, postId, postDate, postContent)
Question No. 2
Consider the following schemas relevant to a hotel booking website. You are required to De-Normalization the given schemas using Collapsing Tables Technique.
roomVisitor (roomID, visitorCNIC, dateTime)
roomCharges (roomID, spentDays, roomRent)
Your assignment must be uploaded on VULMS on or before November 14, 2019. While November 15, 2019 will be a bonus day for assignment submission. After the bonus day, no assignment would be entertained via email.
How aggregates awareness helps the users?
Anybody can describe?
The existence of aggregate tables does not help user queries. Users must access the summary tables, ideally automatically with awareness built into the BI tool or the RDBMS to force the query to be processed in the most efficient way. In recent years, BI vendors have debated if aggregate awareness belongs in the BI tool or in the RDBMS. Business Objects is the only BI tool that has built-in functionality to take advantage of RDBMS aggregate tables in a way that is seamless to users.
CS508 Quiz 2 Solution and Discussion
CS508 - Modern Programming Languages9
CS202 Assignment 3 Solution and Discussion
CS202 - Fundamentals of Front End Development6
MGT201 Assignment 1 Solution and Discussion
MGT201 - Financial Management6
CHE301 Assignment 2 Solution and Discussion
CHE301 - Analytical Chemistry & Instrumentation5
CS601 Assignment 3 Solution and Discussion
CS601 - Data Communication5
CS204 Assignment 3 Solution and Discussion
CS204 - Cyber Law4
CS304 Assignment 3 Solution and Discussion
304 - Object Oriented Programming4
BT605 Assignment 2 Solution and Discussion
BT605 - Biosafety & Bioethics4
CS311 Assignment 3 Solution and Discussion
CS311 - Introduction to Web Services Development3
UNSOLVED CS601 Assignment 1 Solution and Discussion
CS601 - Data Communication3
CS310 Assignment 3 Solution and Discussion
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)3
CS402 Assignment 3 Solution and Discussion
CS402 - Theory of Automata3
CS615 Assignment 3 Solution and Discussion
CS615 - Software Project Management3
ENG509 Assignment 2 Solution and Discussion
ENG509 - Morphology and Syntax3
CS507 Assignment 3 Solution and Discussion
CS507 - Information Systems2
Do you recommend the pharmaceutical companies in Pakistan to replace the conventional health literacy campaigns with the online health literacy campaigns? Write four logical arguments to prove your point.
MGT602 - Entrepreneurship2
STA643 Assignment 2 Solution and Discussion
STA643 - Experimental Designs2
PSY511 Assignment 1 Solution and Discussion
PSY511 - Environmental Psychology2
SOLVED HRM624 Assignment 1 Solution and Discussion
HRM624 - Conflict Management2
SOLVED HRM613 Assignment 1 Solution and Discussion
HRM613 - Performance Management2