Assignment GDB Solution: CS614 Data Warehousing


CS614 Assignment 2 Solution Fall 2018

Consider the following table (Data File): BookID BookTitle ISBN Author Publisher 1 Modern Operating Systems 978-0133591620  Tanenbaum,A Prentice Hall 2 Building the Data Warehouse 0-471-14161-5 W. H. Inmon John Wiley & Sons Inc., NY. 3 Data Warehousing Fundamentals 0-471-41254-6 Paulraj Ponniah John Wiley & Sons Inc., NY. 4 Operating System Concepts   978-0470128725 Silberschatz,A, Galvin,P, […]

CS614 Assignment 1 Solution Fall 2018

Question:                                                                                                                                                                            Consider the following part of an ERD of Hotel Reservation System. Table Collapsing and Pre-Joining are two important techniques of de-normalization. You are required to perform following tasks: Task 1: Identify all such relations from above given ERD on which Table Collapsing technique can be applied. After that apply table collapsing techniques […]

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