Problems: Q 1) Consider the following requirements for an airline tickets booking system. The system is composed of many airlines. Each airline is identified by a code, name and head quarter’s address. An airline has different mile programs, identified by a type- code, description, and starting date. The different types of flights offered by [...]
Archive for the ‘Assignments’ Category
Assignment: Draw the snow flake schema with possible hierarchies of the following scenario. Sales System In Lahore Mr. Muhammad bin Iqbal has departmental stores with headquarters at Gulberg III. Salesmen deal different types of Items; The Items are identified by their Id, name, description, category name and ManufacturerID. In category they also store [...]
Assignment: Consider the case of pre-join de-normalization. Figure-1(a) shows the schema before de-normalization, and Figure-1(b) shows the schema after de-normalization i.e. sales_master table completely inserted into the sales_detail table to create the new_sales_detail table as shown in Figure-1(b). Assume the following Meta data about the schema of Figure-1: 1:5 record count ratio between [...]
In this part you will develop a software/tool to remove duplicates and to identify siblings in the given data file as follows: Task: Code/implement the BSN (Basic Sorted Neighborhood) method to remove duplicates. Code/implement the BSN (Basic Sorted Neighborhood) method to identify the siblings (people who have the same father i.e. they are brothers and [...]
Assignment Q.1. What is the problem related to the reuse of primary keys? When does it usually occur? [10] Q.2. What is the “clean as you go” method? Is this a good approach for data warehouse environment? [10] Q.3. Name any four types of participants on the data quality team. What are their functions? [10] [...]
Assignment Q.1 Explain the difference between Star schema, Star query and Multi-star schema. [15] Q.2 In what situation Snowflake schemas are better to use than the star schema’s. What are the advantages of using Star schema? [10] Q.3 what are the three main types of parallelisms as implemented in ETL applications? [15] Solution: [...]
Assignment: Q.1 What is the difference b/w OLAP & OLTP, why do we keep warehouse on different server then of OLAP? [10] Q.2 What are Microsoft OLAP cubes? [5] Q.3 What types of join algorithms can you have? [5] Solution: Spring 2007_CS614_2_SOL
Assignment Design a normalized database for employees of “XYZ”. One non-normalized way to represent this data is with the following single table with given fields. Working/regular day of the “XYZ” is of 8 hours. If an employee works for more than 6 hours, it is considered his overtime. Wages of overtime is twice of the [...]
Assignment Draw a Star Schema for Cakes & Bakes. Cakes & Bakes operates an online transactional database for recording information about customer sales and inventory control. It records all the transactions that are processed, including not only the ordering and delivery of stock items from the various warehouses to the supermarkets, but also the recording [...]
Assignment (20) Draw the snow flake schema with possible hierarchies of the above scenario Sales System In Lahore Mr. Muhammad bin Iqbal has departmental stores with headquarters at Gulberg III. Salesmen deal different types of Items; The Items are identified by their Id, name, description, category name and ManufacturerID. In category they also store the [...]
Assignment: Design an “excellent” entity-relationship diagram that describes the following objects in a university application: students, departments, sections taught in the present and future, and courses. Departments have a name that uniquely identifies the department. Students are identified by a unique social security number, zero, one or multiple e-mail addresses, and an optional Gpa (new [...]
Assignment Design a normalized database for Students. One non-normalized way to represent this data is with the following single table with given fields. You normalized the table up to 3rd Normal Form. Employee Record ID Name Add & Ph# DBMS C12 Hashim St no. 5 Mohalaa AbuBakar,5666421 Fox Pro, DB2, O2. C14 Usman St [...]
Assignment: 1. Answers the following questions in precise manner and not acceptable if have more than three lines. Ø What is dimension modeling? Ø What is derived attributes? Ø When we add Redundant Columns”? Ø Give two different definations of data ware house. Solution: Special 2006_CS614_1_SOL
Semester Project This will be a group project, consisting of not more than three students. Part-I In this part you will develop a software/tool to remove duplicates and to identify siblings in the given data file as follows: Task: Code/implement the BSN (Basic Sorted Neighborhood) method to remove duplicates. Code/implement the BSN (Basic Sorted Neighborhood) [...]
Assignment: There are two types of Data Mining. 1. Predictive Data Mining 2. Descriptive Data Mining Define and provide brief explanation of these two types. Give precise answer not more than 200 words for each type. Please also provide references Solution:. CS614_6_SOL
