Assignment GDB Solution: CS614 Data Warehousing


CS614 Assignment 2 Solution Spring 2018

  Question Statement: “Auto Mart” is web based Auto Parts Shop that offers purchase service of auto parts to the webpage visitors online. It offers different variants of a single part. The administrative staff can update auto parts information, and manage categories of products. Main categories includes Engine parts and Body parts. The buyer or […]

CS614 Assignment 1 Solution Fall 2018

Problem Statement: 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 […]

CS614 Assignment 2 Solution Spring 2018

Question: [05 Marks] Amdahl’s Law is a statement of the maximum theoretical speed-up you can ever hope to achieve. Amdahl’s law (given below) assumes that a program consists of a serial part and a parallelizable part. The sequentially computed fraction of the program is 15% and Speedup is 6.543. For which number of processors do […]

CS614 Data Warehousing Assignment 1 Solution Fall 2017

Question 1:    Consider the following schema and convert into second normal form.   Employee_Branch (Emp_id, EmpName, Designation, BranchID, BranchName, BranchLocation, Project)  The following functional dependencies exist for above table.    Emp_id, BranchID -> Project   Emp_id -> EmpName, Designation   BranchID -> BranchName, , BranchLocation    Question 2:      Consider the following four tables in normalized form. […]

CS614 Assignment 3 Solution Feb 2015

Consider the below applicant table: Applicant_ Info   .Question: Apply all three steps of Basic Sorted Neighborhood (BSN) method to find out the duplicate records in the table. Records will be considered duplicate if the value of “Applicant_id ” column is same in these records. Use the following rules for the key: Key: Key will […]

CS614 Data Warehousing Assignment 2 Solution Fall 2014

Question No. 1 [10] You are given ERD as shown below. Perform appropriate de-normalization technique to any of the one-to-one and one-to-many relations. Question No. 2 [10] Consider the below given tables: Student_ Info Suppose we need to run the below given query more frequently. But the problem is that the given query links two […]

CS614 Data Warehousing Assignment 1 Solution Fall 2014

VUScholarship Management system VUScholarship is a financial grant database for students from all areas of Pakistan. We will secure all corners of the country to locate awards that will design to assist students who want to gain financial add/grant regarding higher education and professional degrees. Our system will mainly manage two types of scholarship: Scholarship […]

CS614 Data Warehousing GDB Solution Spring 2014

Consider the following table structure: ProductID (Primary key, Integer, Not NULL) ProductName (String, Not NULL) ManufacturingDate (Date, Not NULL) ExpiryDate (Date, Not NULL) Category (Integer, Not NULL, Refers to Category column in Category table) UnitPrice (Float, Not NULL) Question: Suppose we want to create index (primary) on this table. Identify the indexing technique, you think is best to consider […]

CS614 Data Warehousing Assignment 4 Solution Spring 2014

Consider the following table: Student_Subjects StudentID SubjectCode ExamCenter 124 CS614 PVC001 455 CS001 PVC002 367 CS614 PVC001 486 CS403 PVC001 524 CS101 PVC003 657 CS614 PVC002 Question: Use bitmap index to execute the following queries: Select * from Student_Subjects where SubjectCode=”CS614” and ExamCenter=”PVC001” Select * from Student_Subjects where SubjectCode=”CS001” and ExamCenter=”PVC001” Note: You need to specify […]

CS614 Data Warehousing Assignment 2 Solution Spring 2014

Assignment No. 2 Consider the business process “exams_sessions_papers_aggregate”. The entities involved in the process are shown in above portion of ERD. The process calculates the information that can be sampled as follows: “Totally 100 papers were conducted in exam center “VU001” in morning session in Fall 2013 exam”. “Totally 110 papers were conducted in exam center “VU002” in evening […]