Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 5, Problem 5.21MML
Explanation of Solution
Purpose of the
- The main purpose of the database is keeping track of the things.
- It is tool that is used to organize large amount of data.
- It is used in storing and transforming the data into information that can be used in supporting decision making.
Choice of database when preferred with spreadsheets:
- Generally spreadsheets are also used to track things, the circumstance where a database is preferred with spreadsheets are when more information needs to processed to obtain a certain decision.
- Spreadsheets are limited when more details regarding the data collected needs to be added.
- In that case, database are preferred when more data needs to be added to calculate.
Determining database as a better choice:
Managing hundreds of spreadsheet with huge amount of data is really a tedious process for the manager.
- The data that are present in the spreadsheet can be used in an effective way with the help of queries.
- The data contents that are present in the database are processed based on the query, can be protected from the malicious user and data gets stored permanently into the database and the chance of data being lost gets reduced.
Therefore, the choice of using database is recommended in the solving the problems stated.
Developing the database as a centralized database:
Centralized database is a database that stores the data which can be maintained at a single location. Thus, when creating a database as a centralized database it provides the following advantages that are listed below:
- It helps the data that are stored being maintained in consistent way thus ensuring the reliability of the data.
- It provides security to the data that are stored...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What Big O category does the database's execution time fall under? If it's only one more thing, I'll do it. How many deletions may be performed within a single operation? It makes no difference if it will be used for a single advertisement or several advertisements. As a direct result of a single web search?
When it comes to database operations, what class does Big O place them in? Even if there's only one more thing to do, count on me to finish it. How many items are deleted in a single process? A single ad would be fine as an example. due to the results of a single internet search?
Although you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was born, a name (not unique), the type of dog (e.g., Brittany, German Shepard, Collie, etc.), color of the dog’s hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels…
Chapter 5 Solutions
Using MIS (10th Edition)
Ch. 5.2 - Prob. 1EGDQCh. 5.2 - Prob. 2EGDQCh. 5.2 - Prob. 3EGDQCh. 5.2 - Prob. 4EGDQCh. 5.2 - Prob. 5EGDQCh. 5.2 - Prob. 6EGDQCh. 5.2 - Prob. 7EGDQCh. 5.2 - Consider the adage Never ask a question for which...Ch. 5.3 - Prob. 1SAQCh. 5.3 - Prob. 2SAQ
Ch. 5.3 - Prob. 3SAQCh. 5.3 - Prob. 4SAQCh. 5.8 - Prob. 1SGDQCh. 5.8 - Prob. 3SGDQCh. 5.8 - Prob. 4SGDQCh. 5.8 - Prob. 5.1ARQCh. 5.8 - Prob. 5.2ARQCh. 5.8 - Prob. 5.3ARQCh. 5.8 - Prob. 5.4ARQCh. 5.8 - How are data models used for database development?...Ch. 5.8 - Prob. 5.6ARQCh. 5.8 - Prob. 5.7ARQCh. 5.8 - Prob. 5.8ARQCh. 5 - Draw an entity-relationship diagram that shows the...Ch. 5 - Consider the relationship between Adviser and...Ch. 5 - Prob. 5.3UYKCh. 5 - Prob. 5.4UYKCh. 5 - Study Figure 5-28 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-28 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-28 into a...Ch. 5 - Prob. 5.1CE5Ch. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 5.12CE5Ch. 5 - Explain why a one-table database could be stored...Ch. 5 - Prob. 5.14CS5Ch. 5 - Examine the columns in Figure 5-33. Name three...Ch. 5 - Prob. 5.16CS5Ch. 5 - Prob. 5.17CS5Ch. 5 - Explain the statement A database is an abstraction...Ch. 5 - Prob. 5.19CS5Ch. 5 - Prob. 5.2MMLCh. 5 - Prob. 5.21MML
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
- Draw an ER diagram of the following: You are going to set up a database company that builds a product for art galleries. The core of this product is a database that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, we need to record its unique title, the year it was made, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price. An artist may paint many pieces of artwork and a piece of artwork is done by one artist. Pieces of artwork are also classified into groups of various kinds (for example, portraits, works by Picasso, or works of the 19th century). A given piece may belong to more than one group. Each group is identified by a name that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent…arrow_forwardAlthough you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was born, a name (not unique), the type of dog (e.g., Brittany, German Shepard, Collie, etc.), color of the dog’s hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels…arrow_forwardHere's a situation to mull over: two students are interested in enrolling in the same class, but there's only room for one of them. What is it about a database that makes it so they can't sit together?arrow_forward
- How does the database rank in terms of Big O notation for the time it takes to run an operation? In that case, I can handle the extra chore. A typical number of deletions during a single operation is. Even if it were only ever used in a single commercial, it wouldn't matter. Just just doing one online search?arrow_forwardYou set up a database company, MaxData, which builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art (abstract, photorealism, expressionism, impressionism). For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classified into groups of various kinds, for example, portraits, still life’s, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent in the…arrow_forwardWhat is the Big O category of the database execution time? If there's just one more task, I'll do it. In a single operation, how many deletions occur? Even if it were to be used in the context of a single commercial, it would be irrelevant. In direct response to a single Internet search?arrow_forward
- What is the primary distinction between copying a database and splitting it up?arrow_forwardUsing a hierarchical database instead of a relational database provides a number of benefits over using the latter kind. What you should talk about is whether or not the statement above is true.arrow_forwardUsing a hierarchical database instead of a relational database provides a number of benefits over using the latter kind.What you should talk about is whether or not the statement above is true.arrow_forward
- What factors into the database's execution time fall within the Big O category? Consider it finished if there is only one more thing to complete. How many objects are totally eliminated in one operation? What difference does it make if it will only be used in the context of one advertisement? as a direct result of conducting just one online search?arrow_forwardWhat kind of Big O notation does database execution time fall into? Sure, I'll take care of it. If I erase X, how many will be gone? For a single commercial. From a single online search?arrow_forwardA database's logs serve two purposes in a typical setup. I'm not sure I understand what you mean by that.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