The most common application of term “Finance” involves raising money to acquire_________. ACC501
CS614 Assignment 1 Solution and Discussion
-
Assignment No. 1
Semester: Fall 2019
CS614 – Data Warehousing
Total Marks: 15Due Date:
November 14, 2019Objectives:
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 techniqueInstructions
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).Assignment
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)
Deadline:
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.
-
@zareen said in CS614 Assignment 1 Solution and Discussion:
Assignment No. 1
Semester: Fall 2019
CS614 – Data Warehousing
Total Marks: 15Due Date:
November 14, 2019Objectives:
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 techniqueInstructions
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).Assignment
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)
Deadline:
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.
-
Recent Topics
-
CS301 Quiz 1 Solution and Discussion
CS301 – Data Structures5 -
UNSOLVED MTH404 Assignment 2 Solution and Discussion
MTH404 - Dynamics5 -
org.jetbrains.kotlin.util.KotlinFrontEndException: Exception while analyzing expression
Android Development4 -
SOLVED MTH304 Assignment 2 Solution and Discussion
MTH304 - Statics4 -
STAT408 Assignment 1 Solution and Discussion
STAT408 - Experimental Design Analysis4 -
SOLVED FIN725 GDB 1 Solution and Discussion
FIN725 - Credit & Risk Management3 -
SOLVED MGT713 GDB 1 Solution and Discussion
MGT713 - Production / Operations Management3 -
SOLVED MTH633 Assignment 1 Solution and Discussion
MTH633 - Group Theory3 -
SOLVED CS510 Assignment 2 Solution and Discussion
CS510 - Software Requirements and Specifications2 -
UNSOLVED BIF501 Assignment 1 Solution and Discussion
BIF501 - Bioinformatics II2 -
SOLVED BNK603 Assignment 1 Solution and Discussion
BNK603 - Consumer Banking2 -
SOLVED CS510 Assignment 1 Solution and Discussion
CS510 - Software Requirements and Specifications2 -
SOLVED MTH621 Assignment 1 Solution and Discussion
MTH621 - Real Analysis I2 -
UNSOLVED BNK601 Quiz 2 Solution and Discussion
BNK601 - Banking Laws & Practices2 -
MTH101 Assignment 1 Solution and Discussion
MTH101 - Calculus And Analytical Geometry1 -
SOLVED How to Netinstall RouterBoard/OS System
Tutorials1 -
BIO734 Assignment 1 Solution and Discussion
BIO734 - Advances in Cell Biology1 -
BIF604 Assignment 1 Solution and Discussion
BIF604 - Special Topics in Bioinformatics1 -
UNSOLVED BIF601 Assignment 1 Solution and Discussion
BIF601 - Bioinformatics Computing I1 -
BIO731 Assignment 1 Solution and Discussion
BIO731 - Advanced Molecular Biology1