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 solutionStudents have asked these similar questions
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?
What is the primary distinction between copying a database and splitting it up?
The Sports Physical Therapy clinic is having trouble with the performance of their Access database. They would like to split the database between front end and back end to improve performance. How would they do this?
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
- Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…arrow_forwardImagine there are two students who are interested in enrolling in the same class, but there is only place for one additional student. Both of these students may be wondering what it is about the database system that prohibits them from getting the last open spot.arrow_forwardIn your area, you've seen a minimart and found out that it keeps its records on spreadsheets. Does it sound good if I tell them to use database management software instead of a spreadsheet application in less than a single sentence?arrow_forward
- Here'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_forwardUsing a distributed database system, which is better: replication or data fragmentation? What do you think about the idea of combining fragmentation with replication? Are there ways to identify whether a file is fragmented vertically or horizontally? You need to provide me an example to back up your claim.arrow_forwardWhich is better in distributed database systems: replicating data or breaking it up into smaller pieces (data fragmentation)? Do you think it's possible to combine the processes of replication and fragmentation? How different from one another are the vertical and horizontal kinds of fragmentation? Could you supply me with an example to illustrate what you mean?arrow_forward
- Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.arrow_forwardWhat is the main difference between making a copy of a database and breaking it up?arrow_forwardOne of your (hipster) acquaintances thinks he has the next billion-dollar startup idea for an app: Pizza Delivery with Entertainment. He heard from other people that you are following the course on database management, and asks you to design the EER model. Afterwards, he will use the UML model to ask programmers to implement the app. He explains the basic functionality of the app as follows: customers can order pizzas from restaurants to be delivered to a specific address, and if they want to, they can choose a special “entertainment order”. When an order is an entertainment order, the delivery person stays with the customer after delivering the pizza and entertains the customers (e.g., by singing, making jokes, doing magic tricks, etc.) for a certain amount of time. Now follows a detailed explanation of the range of capabilities of the app: when people create an account for the app and become app users, they have to indicate their birthday and fill in their name and address. Every…arrow_forward
- What 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_forwardImagine you’re planning to estimate the price of the average book at your college bookstore. The bookstore carries 13,000 titles, but you plan to sample only 200 books. You will select a sample of 200 books, record the price of each book, and use the average of the 200 books to estimate the average price of the 13,000 titles in the bookstore. Assume that the bookstore can give you access to a database that lists all 13,000 titles that it carries. Based on this information, answer the following questions, thank you so much!! :)) 1. What is the sample in this study, and what is the population of interest? 2. How might you collect a simple random sample of books? 3. Choose one of the following options and discuss how you would collect that type of sample (systematic random sample, cluster sample, multistage sample, or quota sample). 4. Discuss one possible way that you could end up with a biased sample when conducting this study (hint: be sure to discuss how the sample could be…arrow_forwardIn the real world, what components are essential for the creation of a database? Create a list of the messaging services that are used by the largest number of people. In the event that this is the case, do they adhere to the same restrictions as SMS?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