Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 5.19CS5
Explanation of Solution
Procedures that Dean needs to create and follow to keep his
The below are the procedures that Dean needs to create and follow to keep his database up to date:
- A routine check for the pianos needs to be made ensuring that any changes that happened in the piano need to be updated
- Any alteration that is be made regarding the condition of piano that is any repair or modification made needs to be updated.
- If any piano gets disposed from or added to the storage area it needs to be updated in the inventory where the information is stored...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A Database administrator is involved with maintaining the database of a company with thousands of users. Illustrate how the DBA can perform: Creating new database users, altering and dropping existing users, And Briefly Explain how He'll handle any redundancy in DataBase?
Keeping a database in a steady state is the key to making it work well.
Don't forget to talk about why database backup and recovery are so crucial. The next thing to do is to go at the necessary steps for creating a backup and recovery plan.
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
Similar questions
- What are the four most common causes of database failures, and how do you propose to handle them to avoid data loss?arrow_forwardIt is possible that the database management system that is currently being used will have an effect on the way risks are handled.arrow_forwardTalk about the importance of database backup and recovery procedures and what they do. Then, go over the steps that backup and recovery plans need to have.arrow_forward
- If your database system has failed, what should you do? Describe the database recovery method, as well as the usage of deferred-write and write-through strategies, if any are used.arrow_forwardYou've deduced from your observations of the neighborhood minimart that it keeps its records on spreadsheets. Is it OK to suggest in less than one paragraph that they utilize database management software rather than a spreadsheet program?arrow_forwardExists a way to assess your database to see whether it is performing at its highest potential?arrow_forward
- In other words, why bother with database security? You know that you need to use at least two distinct ways to ensure the security of your database, right?arrow_forwardWhy is Access more effective than Excel in administering these data in this instance?arrow_forwardWhat are the four most prevalent causes of database failures that you plan to address in order to prevent any loss of data, and how do you intend to do so?arrow_forward
- Don't bother checking in on that database right now; just assume it's broken. You should be familiar with database recovery strategies like deferred writing and write-through.arrow_forwardHow will you avoid the four most common database failures?arrow_forwardWhat are the four most typical reasons of database failure, and how do you intend to handle them to prevent data loss?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning