Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 10, Problem 10.27PAE
Program Plan Intro
To discuss the type of data transformations needed to build the data mart for the given company.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these 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?
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?
The 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:
Chapter 10 Solutions
Modern Database Management (12th Edition)
Ch. 10 - Prob. 10.1RQCh. 10 - Prob. 10.2RQCh. 10 - Prob. 10.3RQCh. 10 - What are the key activities that are often the...Ch. 10 - What are the key components of a data governance...Ch. 10 - Prob. 10.6RQCh. 10 - Prob. 10.7RQCh. 10 - Prob. 10.8RQCh. 10 - Prob. 10.9RQCh. 10 - Prob. 10.10RQ
Ch. 10 - Prob. 10.11RQCh. 10 - Prob. 10.12RQCh. 10 - Prob. 10.13RQCh. 10 - Prob. 10.14RQCh. 10 - Prob. 10.15RQCh. 10 - What are the major differences between the data...Ch. 10 - Prob. 10.17RQCh. 10 - List six typical characteristics of reconciled...Ch. 10 - Prob. 10.19RQCh. 10 - Prob. 10.20RQCh. 10 - Prob. 10.21RQCh. 10 - Prob. 10.22RQCh. 10 - Describe some field-level and record-level data...Ch. 10 - Prob. 10.24PAECh. 10 - Prob. 10.25PAECh. 10 - Prob. 10.26PAECh. 10 - Prob. 10.27PAECh. 10 - Prob. 10.28PAECh. 10 - Prob. 10.29PAECh. 10 - Prob. 10.30PAECh. 10 - Prob. 10.32PAECh. 10 - Prob. 10.33PAE
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
- John 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_forwardThe term "database as a service," or DaaS for short, refers to this model. What is it actually, and how does it carry out its duties? What are some of the benefits and drawbacks of using a technique that is based on DevOps, and how can it be implemented?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_forward
- The 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_forwardFor the aviation industry, "snapshot isolation" serves as an example of a database design. In the case that airlines improve their overall performance, is it appropriate to choose a strategy that does not lend itself to serialization?arrow_forwardHow do serialization frameworks deal with data versioning?arrow_forward
- Draw er diagramarrow_forwardThe term "database performance tuning" refers to the process of improving the performance of a database.What is the main focus of the vast majority of performance-tuning efforts, and why is this a top priority for the vast majority of people?What precisely are database statistics, and why are they so important to understand? What is a database statistic?arrow_forwardWhat are the benefits of using a transaction to group database operations together that need to either all complete or be rolled back so none of them complete? Here is an example of when a transaction should definitely be used to be helpful: When any bank / financial institution processes a transfer of money from one account to another account, the operations involved are always (1) to subtract a given amount of money from the source account and (2) add that same amount of money to the destination account. They have to be sure the software doing the transfer groups the above 2 required database operations in a transaction to ensure that if there is any system error/problem during these operations there is no way that money could be accidentally subtracted from an account but not added to the account it is supposed to be transferring to or customers will be very upset at the loss of money!arrow_forward
- Imagine for a moment the culture of a small or medium-sized business. Is there anything that, due to social or cultural considerations, stands in the way of the general adoption of a big data application or a NoSQL database? If this is the case, how should we approach dealing with them in the years to come?arrow_forwardYou are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with the owners to discuss their business and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore, there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices for them are based on the quantity of their shipment and the past business they have done with…arrow_forwardIs there a single mechanism that database designers should be aware of that has the potential to have a major influence on a database's performance when employed under certain conditions?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 EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable 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