Archives

Guide IV Part 1 Background Chapter 1 Introduction to Databases 1.1 A database management system provides a number of facilities that will vary from system to system. Describe the type of facilities you might expect, especially those that aid the […]

– Part III Chapter 1 Introduction to Databases Review Questions 1.1 List four examples of database systems other than those listed in Section 1.1. Some examples could be: A system that maintains component part details for a car manufacturer; An […]

Guide IV Part 3 Database Analysis and Design Techniques Chapter 10 Database Planning, Design, and Administration 10.1 Explain the procedures and techniques needed to achieve a conceptual data model. The answer should discuss the different stages that might be identified, […]

– Part III Chapter 10 Database System Development Lifecycle Review Questions 10.1 Describe the major components of an information system. Database, database software, application software, computer hardware including storage media, and people using and developing the system. 10.2 Discuss the […]

– Part III Chapter 11 Database Analysis and the DreamHome Case Study Review Questions 11.1 Briefly describe what the process of fact-finding attempts to achieve for a database developer. Attempts to uncover facts about the business and the users of […]

– Part III Chapter 12 Entity-Relationship Modeling Review Questions 12.1 Describe what entity types represent in an ER model and provide examples of entities with a physical or conceptual existence. eal world with the same properties (see Section 12.1). Examples […]

Guide IV Chapters 12 13 (Enhanced) Entity Relationship Modeling 12.1 Represent each of the following requirements with an ER diagram: (a) A company called Perfect Pets runs a number of clinics. A clinic has many staff and a member of […]

– Part III 15 Chapter 13 Enhanced Entity-Relationship Modeling Review Questions 13.1 Describe what a superclass and a subclass represent. A superclass is an entity type that includes one or more distinct subgroupings of its 13.2 Describe the relationship between […]

Guide IV Chapters 14 – 15 Normalization 14.1 Explain the purpose of data normalization and describe the main steps in the normalization process. 14.2 The table shown below displays the details of the roles played by actors/actresses in films. filmNo […]

– Part III 19 Chapter 14 Normalization Review Questions 14.1 Describe the purpose of normalizing data. The purpose of normalization is to identify a suitable set of relations that support the data requirements of an enterprise. The characteristics of a […]

– Part III 29 Chapter 15 Advanced Normalization Review Questions 15.1 Describe the purpose of using inference rules to identify functional dependencies for a given relation. Even if we restrict our attention to nontrivial functional dependencies with one-to-one (1:1) relationships […]

– Part III Chapter 16 Methodology – Conceptual Database Design Review Questions 16.1 Describe the purpose of a design methodology. A structured approach that uses procedures, techniques, tools, and documentation aids, to support and facilitate the process of design. A […]

PART IV (f) Approximately 50 new video orders are placed each week. The details of video orders are destroyed two years after the creation of the record. The types and average number of record searches (a) Searching for the details […]

PART IV FastCabs Sample ER Model Staff staffNo WorksAt 1..* Manager Driver Owner Office officeNo Manages 1..1 1..1 Taxi vehRegNo TaxiDriver Owns 1..* 1..1 1..* 1..* 1. .1 1..1 Has Drives 1..1 Job jobID Contract contractNo BusinessClient bClientNo PrivateClient pClientNo […]

Guide IV Part 4 Methodology Chapters 16 – 19 Methodology Conceptual, Logical, and Physical Database Design Case Study 1 – Adult Education Department An Adult Education Department runs various courses during the daytime and evenings, and at Monday evenings or […]

– Part III Chapter 17 Methodology – Logical Database Design for Relational Model Review Questions 17.1 Discuss the purpose of logical database design. For the purpose of logical database design see Section 17.1. 17.2 Describe the rules for deriving relations […]

– Part III 24 Chapter 18 Methodology – Physical Database Design for Relational Databases Review Questions 18.1 Explain the difference between conceptual, logical, and physical database design. Why might these tasks be carried out by different people? Conceptual database design […]

– Part III Chapter 19 Methodology Monitoring and Tuning the Operational System Review Questions 19.1 Describe the purpose of the main steps in the physical design methodology presented in this chapter. Step 7 of physical database design considers denormalizing the […]

– Part III Chapter 2 Database Environment Review Questions 2.1 Discuss the concept of data independence and explain its importance in a database environment. See Section 2.1.5 2.2 To address the issue of data independence, the ANSI-SPARC three-level architecture was […]

Guide IV Chapter 2 Database Environment 2.1 Discuss the reasons for the three-level architecture for a Database Management System. 2.2 Security and recovery are two important functions of a Database Management System, which are also of interest to Database Administration. […]

PART IV Part 5 Selected Database Issues Chapter 20 Security and Administration 20.1 Describe a general plan of action for initiating a security policy, elaborating on each stage that might be undertaken. First of all, the need for one must […]

– Part III 3 Chapter 20 Security and Administration Review Questions 20.1 Explain the purpose and scope of database security. The purpose is clearly concerned with the protection of the data. However, the scope is wider than 20.2 List the […]

Chapter 21 Professional, Legal, and Ethical Issues in Data Management Review Questions 21.1 Define 21.2 Describe bus considered: (a) illegal and unethical; An example of this is stealing. (b) legal but unethical; Consider a lonely database administrator for DreamHome who […]

PART IV Chapter 22 Transaction Management 22.1 (a) Locking-based algorithms for concurrency control can be employed to synchronize the execution of transactions. Explain what is meant by a serializable schedule and show that the following locking-based schedule is not serializable: […]

– Part III 6 Chapter 22 Transaction Management Review Questions 22.1 Explain what is meant by a transaction. Why are transactions important units of operation in a DBMS? 22.2 The consistency and reliability aspects of transactions are due to the […]

PART IV Chapter 23 Query Processing Case Study 1 InstantBuy Client (clientNo, cName, cAddress, cTelNo, cFaxNo, sex, DOB, officeNo) Item (itemNo, itemDescription, itemSize, itemColor, itemPrice, itemType) ItemType (itemType, typeDescription) 23.1 Using the above relational schema, determine whether the following query […]

– Part III 18 Chapter 23 Query Processing Review Questions 23.1 What are the objectives of query processing? 23.2 How does query processing in relational systems differ from the processing of low-level query languages for network and hierarchical systems? In […]

3 Chapter 24 Distributed DBMSs – Concepts and Design Review Questions 24.1 Explain what is meant by a DDBMS and discuss the motivation in providing such a system. See Section 24.1.1; motivation given at start of Section 24.1. 24.2 Compare […]

PART IV Pet Horizontally derived from Surgery: Pi: Pet surgeryNo Si I = 1 .. 6 Prescription: Horizontally derived from Pet: PRi: Prescription petNo Pi I = 1 .. 6 Owner: Horizontally derived from Pet: Oi: Owner petNo Pi I […]

PART IV Part 6 Distributed DBMSs and Replication Chapter 24 Distributed DBMSs Concepts and Design Case Study 1 Real Estate Agency A large real estate agency has decided to distribute its project management information at the regional level. A part […]

11 Chapter 25 Distributed DBMSs – Advanced Concepts Review Questions 25.1 In a distributed environment, locking-based algorithms can be classified as centralized, primary copy, 25.2 One of the most well-known methods for distributed deadlock detection was developed by Obermarck. See […]

PART IV Chapter 25 Distributed DBMSs Advanced Concepts 25.1 The centralized two-phase commit protocol uses a series of timeouts to prevent unnecessary blocking. Discuss the actions for both coordinator and participants when a timeout occurs. Consideration should be given to […]

Chapter 26 Replication and Mobile Databases Review Questions 26.1 What is data replication? Data replication is the process of generating and reproducing multiple copies of data at one or more sites. 26.2 Identify the benefits of using replication in a […]

– Part III 3 Chapter 27 Object-Oriented DBMSs Concepts and Design Review Questions 27.1 Describe the three generations of DBMSs. First generation is the hierarchical and network DBMSs. 27.2 Compare and contrast the different definitions of object-oriented data models. Discussion […]

– Part III 11 Chapter 28 Object-Oriented DBMSs: Standards and Systems Review Questions 28.1 Discuss the main concepts of the ODMG Object Model. Give an example to illustrate each of the concepts. The ODMG OM is a superset of the […]

PART IV Chapter 28 Object-Oriented DBMSs Standards and Systems 28.1 Discuss the Object Model proposed by the Object Data Management Group. See Section 28.2.2. Case Study 1 Cornucopia Ltd Cornucopia Ltd is a large, multinational oil company that uses contractors […]

PART IV Part 8 Web and DBMSs Chapter 29 Web Technology and DBMSs 29.1 The World Wide Web is a distributed information system based on hypertext. Discuss how the two-tier client server architecture may not be entirely suitable for this […]

– Part III 3 Chapter 29 Web Technology and DBMSs Review Questions 29.1 Discuss each of the following terms: (a) Internet, intranet, and extranet. See start of Section 29.1 and 29.1.1 29.2 What are Web services. Give some examples of […]

– Part III 11 Chapter 3 Database Architectures and the Web Review Questions 3.1 – approach? Compare the client-server architecture with two other architectures. The client is a process that requires some resource, and the server provides the resource. Neither […]

PART IV Chapter 30 Semistructured Data and XML 30.1 Despite the excitement surrounding XML, it is important to note that most operational business data, even for new Web-based applications, continues to be stored in relational DBMSs. This is unlikely to […]

– Part III 8 Chapter 30 Semistructured Data and XML Review Questions 30.1 What is semistructured data? Discuss the difference between structured, semistructured, and structured data. Give examples to illustrate your answer. Semistructured data is data that has some structure, […]

– Part III 3 Chapter 31 Data Warehousing Concepts Review Questions 31.1 Describe what is meant by the following terms, when describing the characteristics of the data in a data warehouse: 31.2 Discuss how Online Transaction Processing (OLTP) systems differ […]

Databas – Part V Part 9 Business Intelligence Chapter 31 Data Warehousing Concepts 31.1 trend in the 1990s. With the advent of the data warehouse, some basic ideas about data management phenomenon is causing such interest in the business world. […]

– Part III 7 Chapter 32 Data Warehousing Design Review Questions 32.1 Discuss the activities associated with initiating an enterprise data warehouse (EDW) project. To begin a data warehouse project, we need answers for questions such as: which user requirements […]

Databas – Part V Chapters 32 Data Warehousing Design 32.1 your answer with a diagram showing the stages of the lifecycle. The Business Dimensional Lifecycle – Principles o Focus on the business e.g. Identify business requirements and their associated value. […]

– Part III Chapter 33 OLAP Review Questions 33.1 Discuss what Online Analytical Processing (OLAP) represents. OLAP is a term that describes a technology that uses a multi-dimensional view of aggregate data to provide quick access to strategic information for […]

Databas – Part V Chapters 33 OLAP The OLAP cube shown in Figure 33.1 has been prepared for a car rental company that rents out cars to customers throughout the UK. The company wishes to explore which manufacturer, model, engine […]

Databas – Part V Chapters 34 Data Mining 34.1 Data mining can provide huge paybacks for companies who have made a significant investment in data warehousing. Describe the advantages that data mining tools offer the business analyst. 34.2 Explain why […]

– Part III 19 Chapter 34 Data Mining Review Questions 34.1 Discuss what data mining represents. Data mining is concerned with the analysis of data and the use of software techniques for See Section 34.1. 34.2 Provide examples of data […]

Guide IV Part 2 The Relational Model and Languages Chapter 4 The Relational Model 4.1 Describe the main characteristics of the Relational Data Model, including the properties of relations and the rules for relational integrity. Relational set of tables (as […]

Databas – Part III Chapter 4 The Relational Model Review Questions 4.1 Discuss each of the following concepts in the context of the relational data model: (a) Relation A table with columns and rows. (b) Attribute A named column of […]

Databas – Part III 6 Chapter 5 Relational Algebra and Relational Calculus Review Questions 5.1 What is the difference between a procedural and non–procedural language? How would you classify the relational algebra and relational calculus? Procedural language: a language that […]

Guide IV Chapter 5 Relational Algebra and Relational Calculus 5.1 Choose any four relational algebra operators and explain how each functions. For example: Select produces a horizontal subset of a relation. Project produces a vertical subset 5.2 Given two relations […]

Guide IV Chapters 6 8 SQL 6.1 What are the main advantages and disadvantages of SQL? Advantages Satisfies ideals for database language (Relatively) Easy to learn Disadvantages Impedance mismatch mixing programming paradigms with embedded access Lack of orthogonality many different […]

Databas – Part III 22 Chapter 6 SQL: Data Manipulation Review Questions 6.1 What are the two major components of SQL and what function do they serve? 6.2 What are the advantages and disadvantages of SQL? Advantages Satisfies ideals for […]

8.1 Write SQL*Plus commands to do the following: CONNECT SalesTracking/sales@OracleDB Make sure that the Autocommit is off; SET Autocommit OFF; Display the name of the current user; SHOW user; List the names of all tables in this schema; SELECT * […]

Databas – Part III Chapter 7 SQL: Data Definition Review Questions 7.1 Describe the eight base data types in SQL. The eight base types are: Boolean, character, bit (removed from SQL:2003), exact numeric, approximate numeric, datetime, interval, large object. See […]

Databas – Part III 42 Chapter 8 Advanced SQL Review Questions 8.1 impedance mismatch. 8.2 Describe the general structure of a PL/SQL block. A PL/SQL block has up to three parts: An optional declaration part, in which variables, constants, cursors, […]

Databas – Part III 52 Chapter 9 Object-Relational DBMSs Review Questions 9.1 Discuss the general characteristics of advanced database applications. Designs of this type have some common characteristics: Design data is characterized by a large number of types, each with […]

Guide IV Chapter 9 Object-Relational DBMSs 9.1 Compare and contrast the two manifestos: Object-Oriented Database System Manifesto based on the object-oriented paradigm (Atkinson et al., 1989a) and the Third Generation Database System Manifesto published by the Committee for Advanced DBMS […]