RSS Feed

• UNIVERSITY OF THE PUNJAB ADmission From
  UNIVERSITY OF THE PUNJAB ADmission From LLB Form combined new Punjab university […]
• Spring2008_CS614_03
    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 […]
• Summer2007_CS614_02
  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 [ […]
• Summer2007_CS614_01
  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 Fig […]
• Spring2007_CS614_05
  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 [... […]
• Spring2007_CS614_04
  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] […]
• Spring2007_CS614_03
  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:   […]
• Spring2007_CS614_02
  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 […]
• Spring2007_CS614_01
  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 […]
• Special2006_CS614_05
  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 rec […]