Assignment GDB Solution: CS614 Data Warehousing


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 […]

CS614 Data Warehousing Assignment 3 Solution Fall 2013

Assignment comprises of 20 Marks. Note that no assignment will be accepted after due date via email in any case (whether it is the case of load shedding or emergency electric failure or internet malfunctioning etc.). Hence, refrain from uploading assignment in the last hour of the deadline, and try to upload Solutions at least 02 days before the […]

CS614 Data Warehousing Assignment 1 Solution Fall 2013

Question#1: Consider the following Many-to-Many relation between “Project” and “Developer”: Each project is assigned many developers and each developer may be assigned many projects at the same time. Apply the “Table Collapsing” technique to denormalize this relation.           Solution: Three tables are created here. Project_table ->project_id number primary key, ->project_name varchar(45) […]

CS614 Data Warehousing GDB Solution Spring 2013

A data mart can be defined as: “An implementation of a data warehouse with a scope of contents and data warehouse functions which are restricted for serving a single department or part of an organization”. So, we can conclude that a data mart is a sub set of data warehouse. Keeping the above facts in mind do you think that same modeling techniques used for data marts are […]