Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 9, Problem 9.51PAE
Program Plan Intro
To determine the types of data pollution/cleansing problems that can occur in the given OLTP system data.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
I understand the purpose of a database, which is to make data record-keeping easier for any company. And I'm aware of the hardware requirements. The concept of programming the rules and structure of a database is the area in which I am most confused. A database, in my mind, is a chart (or many charts) containing fields that are used to hold records. Then, of course, those records in one chart interweave with those in other charts, necessitating the creation of chart linkages. The concept of developing a framework for the data to fit into is where I get stuck. Are we creating metaphysical venues to store data, or are we just recording relationships between data saved on a variety of platforms?
Suppose your task as a software engineer at Big-University is to design a data mining system to
examine their university course database, which contains the following information: the name,
address. And status (e.g.. undergraduate or graduate) of each student, the courses taken, and their
cumulative grade point average (GPA).
Describe the architecture you would choose. What is the purpose of each component of this
architecture.
Notown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer.• Each musician that records at Notown has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone.• Each instrument used in songs recorded at Notown has a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, B-flat, E-flat).• Each album recorded on the Notown label has a title, a copyright date, a format (e.g., CD or MC), and an album identifier.• Each song recorded at Notown has a title and an author.• Each musician may play several instruments, and a given instrument may be played by several musicians.• Each album has a number of songs on it, but no song may appear on more than one album.• Each song is performed by one or more musicians, and a musician may perform a number of songs.• Each…
Chapter 9 Solutions
Modern Database Management
Ch. 9 - Prob. 9.1RQCh. 9 - Prob. 9.2RQCh. 9 - Prob. 9.3RQCh. 9 - List the five major trends that necessitate data...Ch. 9 - Prob. 9.5RQCh. 9 - Prob. 9.6RQCh. 9 - Prob. 9.7RQCh. 9 - Prob. 9.8RQCh. 9 - Prob. 9.9RQCh. 9 - Prob. 9.10RQ
Ch. 9 - List four objectives of derived data.Ch. 9 - Prob. 9.12RQCh. 9 - Prob. 9.13RQCh. 9 - Explain the pros and cons of logical data marts.Ch. 9 - Prob. 9.15RQCh. 9 - What is a helper table, and why is it often used...Ch. 9 - Describe the characteristics of a surrogate key as...Ch. 9 - Prob. 9.18RQCh. 9 - What is the purpose of conformed dimensions for...Ch. 9 - Prob. 9.20RQCh. 9 - Prob. 9.21RQCh. 9 - Prob. 9.22RQCh. 9 - Prob. 9.23RQCh. 9 - Prob. 9.24RQCh. 9 - Prob. 9.25RQCh. 9 - Describe the current key trends in data...Ch. 9 - Discuss the benefits of offering data warehousing...Ch. 9 - Prob. 9.28RQCh. 9 - List six typical characteristics of reconciled...Ch. 9 - Prob. 9.30RQCh. 9 - Prob. 9.31RQCh. 9 - Prob. 9.32RQCh. 9 - Prob. 9.33RQCh. 9 - Describe some field-level and record-level data...Ch. 9 - Prob. 9.35PAECh. 9 - Prob. 9.36PAECh. 9 - Prob. 9.37PAECh. 9 - Prob. 9.38PAECh. 9 - You are to construct a star schema for Simplified...Ch. 9 - Simplified Automobile Insurance Company would like...Ch. 9 - Prob. 9.41PAECh. 9 - Prob. 9.42PAECh. 9 - Prob. 9.43PAECh. 9 - Prob. 9.45PAECh. 9 - Prob. 9.46PAECh. 9 - Prob. 9.47PAECh. 9 - Prob. 9.48PAECh. 9 - Prob. 9.49PAECh. 9 - Prob. 9.50PAECh. 9 - Prob. 9.51PAECh. 9 - Prob. 9.52PAECh. 9 - Prob. 9.53PAECh. 9 - Prob. 9.54PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- I understand the intentions of a database, being to streamline the data record-keeping of any organizations. And I understand the hardware needed to do such. The area I find myself the most lost in is the idea of programming the rules and structure of a database. In my head a database is a chart (or multiple charts) with fields that is used to store records. And then those records stored in one chart intertwine with other charts of course so we need to have relationships between the charts. Where I get lost is in the thought of programming a structure for the data to fit in. Are we making metaphysical locations to store data or are we just writing relationshipds between data that is stored on a plethora of different options?arrow_forwardWhich of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why? a) A training institute needs to maintain a database of 2000 identification numbers of trainees who received an ICDL certification. The goal is to find rapidly whether or not a given ID is in the database. Ordering information among the identification numbers is not important; speed of response is very important; efficient use of memory is also important, but not as important as speed of response. b) A large fixed content of data needs to be maintained. It is sorted and the admin needs to search for and retrieve existing items, but no new/existing items will be inserted/deleted. You may assume that the data can fit inside the memory of the computer. c) A transposition table is a cache of previously seen positions in a game tree generated by a computer game playing program. If a position recurs via a different sequence of moves, the value of the position is…arrow_forwardTakeltAll Inc is a wholesaler company that has just opened up for business. They sell all kinds of technology devices at their store, ranging from graphics cards to fully kitted gaming motherboards. To help them develop the information system needed for their sales operations, they have hired you to design their database. They currently keep a wide variety of products at their warehouse. The usual information stored for each product includes name, manufacturer, and price, etc... Apart from keeping track of their products, they would like you also to keep track of the purchases made by their clients. Purchases made by clients are shown in invoices that list all the client's products and the quantities of each product. The price at which a product was bought should also be recorded at the purchase of the products. TakeltAll has two types of employees they would like to keep track of in their new information system. Namely sales agents and product managers. Each employee can either be a…arrow_forward
- The ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASSarrow_forwardWhich of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why? a) A training institute needs to maintain a database of 2000 identification numbers of trainees who received an ICDL certification. The goal is to find rapidly whether or not a given ID is in the database. Ordering information among the identification numbers is not important; speed of response is very important; efficient use of memory is also important, but not as important as speed of response. b) A large fixed content of data needs to be maintained. It is sorted and the admin needs to search for and retrieve existing items, but no new/existing items will be inserted/deleted. You may assume that the data can fit inside the memory of the computer. To be submitted through Turnitin. Maximum allowed similarity is 15%.arrow_forwardWhich of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why? a. An Exam Center needs to maintain a database of 3000 students' IDs who registered in a professional certification course. The goal is to find rapidly whether or not a given ID is in the database. Hence, the speed of response is very important; efficient use of memory is not important. No ordering information is required among the identification numbers. b. A transposition table is a cache of previously seen positions in a game tree generated by a computer game playing program. If a position recurs via a different sequence of moves, the value of the position is retrieved from the table, avoiding re-searching the game tree below that position.arrow_forward
- The ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Create an ERD to show the relationship between the entities listed in Part (a). If there are any M:N relations, create a composite entity to serve as a bridge.arrow_forwardThe Database Technique is the preferred approach in the business sector nowadays when it comes to database construction. Take into account the following three justifications for why this approach is better than the File Approach:arrow_forwardJohn Deere wants to build a database to track all of the computer hardware assets and software assets they own. Their hardware assets include PCs, network servers, and peripheral devices. Each PC, network server, and peripheral device contains at least one software installed. They want to keep track of software assets, as well as the licenses they own for those assets. Each software asset may have one license or multiple licenses. Some software licenses are for PCs and peripheral devices. Some software licenses (i.e, network licenses) are for network servers. A single network license authorizes a specific number of users. We want to keep track of where software licenses are installed. John Deere keeps track of users’ assignments to certain PCs, network servers, and peripheral devices. Represent this situation with an E-R diagram. State assumptions if any.arrow_forward
- Problem: Your team of Data Analysts have been asked to create a database design for the Boeing X Aircraft Company (BAC), which has two HUD (heads-up display) products: TRX-5A and TRX-5B. The database must enable managers of BAC to track blueprints, parts, and software for each HUD, using the following business rules: For simplicity’s sake, you may assume that the TRX-5A unit is based on two engineering blueprints and that the TRX-5B unit is based on three engineering blueprints. You are free to make up your own blueprint names. All parts used in the TRX-5A and TRX-5B are classified as hardware. For simplicity’s sake, you may assume that the TRX-5A unit uses three parts and that the TRX-5B unit uses four parts. You are free to make up your own part names. BAC wants to keep track of all part price changes and the dates of those changes. BAC wants to keep track of all TRX-5A and TRX-5B software. For simplicity’s sake, you may assume that the TRX-5A unit uses two named software components…arrow_forwardB.The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The HEG administrator gives you the following description of the training group's operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell which ones?) The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers 5 Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to 2 classes or may be assigned to do research only. Each trainee may take up to 2 classes per year. Given that information, do the following: Define all of the entities and relationships. (Use Table 4.4 as your guide.) Describe…arrow_forwardThe database stores an employee table consisting of 500,000 records each of which is 400 bytes long. A SSD has storage capacity of 1 TB, read bandwidth of 1 GB/sec., and a block size of 4096 bytes. The database designer wants to add a large description field of 1,000 bytes to each employee record. However, this field will only have data in it 20% of the time and is only accessed in 25% of the queries. 1)Calculate: The average time (in seconds) to read the whole table when using spanned, fixed records and no splitting. 2)Calculate: The average time (in seconds) to read the whole table when using spanned, variable records. Assume a variable length record requires 20 bytes of overhead to store record information. 3)Calculate: The average time (in seconds) to read the whole table when using spanned records and splitting. Assume using splitting requires 20 bytes of overhead. The large 1000 byte field is only access 25% of the time.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education