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.
HRM613 Quiz 3 Solution and Discussion
Quiz # 03 Total Questions : 10
Please read the following instructions carefully!
Quiz will be based upon Multiple Choice Questions (MCQs).
You have to attempt the quiz online. You can start attempting the quiz any time within given date(s) of a particular subject by clicking the link for Quiz in VULMS.
Each question has a fixed time of 90 seconds. So you have to save your answer before 90 seconds. But due to unstable internet speeds, it is recommended that you should save your answer within 60 seconds. While attempting a question, keep an eye on the remaining time.
Attempting quiz is unidirectional. Once you move forward to the next question, you can not go back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option.
DO NOT press Back Button / Backspace Button while attempting a question, otherwise you will lose that question.
DO NOT refresh the page unnecessarily, specially when following messages appear
Question Timeout: Now loading next question…
If for any reason, you lose access to internet (like power failure or disconnection of internet), you will be able to attempt the quiz again from the question next to the last shown question. But remember that you have to complete the quiz before expiry of the deadline.
If any student failed to attempt the quiz in given time then no re-take or offline quiz will be held.
Sometimes employee’s performance is highly based on his/her ability to perform; in such situations salaries are based on employee competency. This type of salaries is termed as:
Which of the following are monetary based rewards in response to employee performance?
What are the major functions of a coach in employee development programs?
How effectiveness of performance review meetings can be enhanced?
Which of the following actions describes the legal right of an employee and employer to terminate the job at anytime?
Employment at will:
Company or the employee can terminate the employment relationship at any time, with or without cause, with
or without notice. These clauses must be written and communicated to the employees in prior. Page No. 85
Piece rate pays are the ones in which rewards are allocated on the basis of:
Which of the following characteristics defines an effective 360 degree feedback system?
Which of the following coaching styles focuses more on emotions than facts?
Driver and Analyzer
Conducting 360 degree feedback online has which of the following advantages?
Pay plans are considered effective if:
SOLVED CS605 Assignment 2 Solution and Discussion
CS605 - Software EngineeringII8
UNSOLVED MTH404 Assignment 2 Solution and Discussion
MTH404 - Dynamics5
org.jetbrains.kotlin.util.KotlinFrontEndException: Exception while analyzing expression
SOLVED CS625 Assignment 2 Solution and Discussion
CS625 - Professional Practices4
SOLVED MTH304 Assignment 2 Solution and Discussion
MTH304 - Statics4
STAT408 Assignment 1 Solution and Discussion
STAT408 - Experimental Design Analysis4
SOLVED EDU508 Assignment 1 Solution and Discussion
EDU508 - Teaching of English Language3
SOLVED MGT713 GDB 1 Solution and Discussion
MGT713 - Production / Operations Management3
SOLVED MTH633 Assignment 1 Solution and Discussion
MTH633 - Group Theory3
SOLVED BNK611 Quiz 2 Solution and Discussion
BNK611 - Economic Ideology in Islam3
SOLVED ACC311 Quiz 2 Solution and Discussion
ACC311- Fundamentals of Auditing3
SOLVED FIN725 GDB 1 Solution and Discussion
FIN725 - Credit & Risk Management3
SOLVED BNK603 Assignment 1 Solution and Discussion
BNK603 - Consumer Banking2
SOLVED CS406 Assignment 2 Solution and Discussion
CS406 - Web Based Database Applications2
UNSOLVED BNK601 Quiz 2 Solution and Discussion
BNK601 - Banking Laws & Practices2
SOLVED CS510 Assignment 1 Solution and Discussion
CS510 - Software Requirements and Specifications2
SOLVED CS510 Assignment 2 Solution and Discussion
CS510 - Software Requirements and Specifications2
UNSOLVED BIF501 Assignment 1 Solution and Discussion
BIF501 - Bioinformatics II2
UNSOLVED BIF601 Assignment 1 Solution and Discussion
BIF601 - Bioinformatics Computing I1
پی ٹی اے کے احتجاج کے طور پر ٹویٹر نے پاکستانی صارفین کے اکاؤنٹس معطل کردیئے