CS614 Assignment No 1 Solution Spring 2018

CS614 Assignment No 1 Spring 2018

Dear Students, Here you can read or Download CS614 - Data Warehousing Assignment No 1 Solution and Discussion of Semester Spring 2018. Assignment Due Date is 09 MAY, 2018. Total Marks are 20. This assignment covers lesson no. 7-8. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions. CS614 Assignment Solution File has been added. Previously we shared CS614 Assignment no. 02 Solution Fall 2016.

CS614 Assignment No 1 Solution and Discussion Spring 2018

CS614 Assignment Objective:

This assignment has been designed to develop your ability to apply De-Normalization Techniques and principles to de-normalize data/tables.

CS614 Assignment Instructions:

Please read the following instructions carefully before solving & submitting the assignment:

• The assignment will not be accepted after due date. 
• Zero marks will be awarded to the assignment that does not open or the file is corrupt. 
• The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.
• Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet). 
• Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file. 

For any query about the assignment, contact only at CS614@vu.edu.pk 

Assignment Question No 1:

Local Testing Service (LTS) is authorized to conduct special type of Exams such as GAT (General), GAT (Subject) etc. They are using online application for seating arrangement of students who are appearing in any special Exam. Per day, only one type of exam can be conducted. One or more than one invigilators can be assigned Exam duty. Given below is the ERD for part of given scenario. The following ERD shows different entities involved in scenario discussed above. The diagram also shows attributes and relationships between these entities.

You are required to identify all One-to-One and One-to-Many relationships from given ERD and apply appropriate De-Normalization technique on each identified relationship.Fill all tables with your own data and do not add more than 5 rows in each table. Also add relevant foreign keys in each table.

CS614 Assignment No 1 Question

Your resultant table should be two i.e. Resultant Table 1 will be obtained after applying de-normalization technique on one-to-one relationship. Resultant Table 2 will be a single table after applying de-normalization technique on all one-to-many relationships. You need to show all steps of de-normalization for both type of relationships.

Assignment No 1 Solution Spring 2018

You can see the Sample Preview of CS614 Assignment No 1 Solution provided by (Virtual Study Solutions) below. Click on Download Button to Download Solution File in Your PC. Please Share it with your friends. You can also like our Facebook Page or Subscribe Us below for Updates.

Other Subjects Assignment Spring 2018:

• CS601 Assignment No 1 Solution Spring 2018
• MTH501 Assignment No 1 Solution Spring 2018
• CS507 Assignment No 1 Solution Spring 2018
• PAK301 Assignment No 1 Solution Spring 2018

Assignment Solution Sample Preview:

Solution Idea File 1 & 2 Sample Page Preview has been added below with Solution File.

Solution Idea - 1 Sample Preview:

CS614 Assignment No 1 Solution Idea - 1 Sample Preview Spring 2018

Solution Idea - 2 Sample Preview:

CS614 Assignment No 1 Solution Idea - 1 Sample Preview Spring 2018

Assignment Solution Download Link

Download  [ Solution Idea -1 File Upload Status : ✅ ]
Download  [ Solution Idea -2 File Upload Status : ✅ ] 

Please Note : It may not be complete solution but if you find any mistakes please correct them yourself and try to edit it otherwise 0 marks will be given. Thank You.