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.
CS602 GDB1 Solution and discussion
Total Marks 5
Starting Date Thursday, August 01, 2019
Closing Date Friday, August 02, 2019
Question Title GDB-CS602
Graded Discussion Board
Anti-aliasing is a technique that eliminates the staircase effect (visual defect) on the edges of objects in images at lower resolution. At moderate resolution, aliasing becomes negligible and can be ignored but the drawback becomes bold when the picture is moving. FXAA (Fast Approximate Anti-Aliasing) and SSAA (Super Sampling Anti-Aliasing) are two famous anti-aliasing algorithms suitable for games.
Discuss which algorithm will be best suitable for the new release of PC video game by ABC software house. Consider more users will generate more revenue and every user has not powerful system.
Read the following instructions carefully before sending your comments:
Your discussion must be based on logical facts and in depth knowledge of topic is must for that.
Your comments should be relevant to the topic i.e. clear and concise. (Maximum 4-5 lines answer).
You should post your comments on Graded Discussion Board & not on the Regular MDB. Both will run parallel to each other during the time specified above.
Books, websites and other reading material may be consulted before posting your comments.
GDB will have weight-age of 5% of your total subject marks.
No extra time will be given for discussion.
You cannot participate in the discussion after the due date or through e-mail.
FXAA is the most interesting group of anti-aliasing techniques, these algorithms perform their duties during scene post-processing, after the rendering process. They are all shader-based and cause little to no performance drop, which is their most important advantage. Image quality can vary from one algorithm to another. For example, FXAA is known to make the image look a bit blurry, obviously to the chagrine of some players. Another commonly used technique is SMAA, which usually provides better quality than FXAA while getting around, or at least reducing, the blur effect. Game developers tend to implement their own post-process anti-aliasing algorithms as well. Some of the notable examples are CMAA in Grid: Autosport, AAA (heavily modified FXAA to eliminate blurring) in Metro: Last Light, and T-AA in Rainbow Six: Siege. There are also “injectors” that enable these techniques in games that don’t support post-process anti-aliasing natively.
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
STAT408 Assignment 1 Solution and Discussion
STAT408 - Experimental Design Analysis4
SOLVED MTH304 Assignment 2 Solution and Discussion
MTH304 - Statics4
SOLVED CS625 Assignment 2 Solution and Discussion
CS625 - Professional Practices4
SOLVED MGT713 GDB 1 Solution and Discussion
MGT713 - Production / Operations Management3
SOLVED EDU508 Assignment 1 Solution and Discussion
EDU508 - Teaching of English Language3
SOLVED MTH633 Assignment 1 Solution and Discussion
MTH633 - Group Theory3
SOLVED ACC311 Quiz 2 Solution and Discussion
ACC311- Fundamentals of Auditing3
SOLVED FIN725 GDB 1 Solution and Discussion
FIN725 - Credit & Risk Management3
SOLVED BNK611 Quiz 2 Solution and Discussion
BNK611 - Economic Ideology in Islam3
UNSOLVED BNK601 Quiz 2 Solution and Discussion
BNK601 - Banking Laws & Practices2
SOLVED BNK603 Assignment 1 Solution and Discussion
BNK603 - Consumer Banking2
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
SOLVED CS406 Assignment 2 Solution and Discussion
CS406 - Web Based Database Applications2
GEN733 Assignment 1 Solution and Discussion
GEN733 - Biometrical Techniques in Genetics1
UNSOLVED STA632 Assignment 1 Solution and Discussion
STA632 - Sampling Techniques1