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 solution
Students have asked these similar questions
If the database is not verified or if obsolete information is added into the database, there may be serious consequences. What issues might arise if a student database is not kept up to date?
There can be significant problems if the database is not checked or outdated information is inserted in the database. What problems might occur if a student database is not maintained?
Keeping a database in a steady state is the key to making it work well.
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
- Mini-Case Organization Description:You work for a national healthcare society. Your society regularly collects information from hospitals and clinics nationwide regarding both inpatient and outpatient procedures. This data is stored in a large database, which is accessible by members of hospitals or clinics who contribute any information. Additionally, your society performs other member services, such as organizing a national conference and publishing a journal of information articles relevant to the society.Assume the society headquarters is in St. Louis, Missouri and leases floors in a high-rise multitenant office building located center city. The servers holding the national database of procedures occupy most of one of the leased floors. Other floors hold offices for the elected officers and hired staff, a library, and meeting rooms. Each floor has either a receptionist or guard (on the server floor). Except for the server floor, society members and the officers may access the…arrow_forwardMini-Case Organization Description:You work for a national healthcare society. Your society regularly collects information from hospitals and clinics nationwide regarding both inpatient and outpatient procedures. This data is stored in a large database, which is accessible by members of hospitals or clinics who contribute any information. Additionally, your society performs other member services, such as organizing a national conference and publishing a journal of information articles relevant to the society.Assume the society headquarters is in St. Louis, Missouri and leases floors in a high-rise multitenant office building located center city. The servers holding the national database of procedures occupy most of one of the leased floors. Other floors hold offices for the elected officers and hired staff, a library, and meeting rooms. Each floor has either a receptionist or guard (on the server floor). Except for the server floor, society members and the officers may access the…arrow_forwardMini-Case Organization Description:You work for a national healthcare society. Your society regularly collects information from hospitals and clinics nationwide regarding both inpatient and outpatient procedures. This data is stored in a large database, which is accessible by members of hospitals or clinics who contribute any information. Additionally, your society performs other member services, such as organizing a national conference and publishing a journal of information articles relevant to the society.Assume the society headquarters is in St. Louis, Missouri and leases floors in a high-rise multitenant office building located center city. The servers holding the national database of procedures occupy most of one of the leased floors. Other floors hold offices for the elected officers and hired staff, a library, and meeting rooms. Each floor has either a receptionist or guard (on the server floor). Except for the server floor, society members and the officers may access the…arrow_forward
- Maintaining the database is important in ensuring the good performance of the database to ensure the transaction can be performed smoothly. There are three types of maintenance that one needs to be perform on the database namely corrective maintenance, adaptive maintenance and perfective maintenance. Develop a plan and strategies on how you will perform each maintenance which includes risks and challenges which are associated with each of type maintenancearrow_forwardWhat is the reason for reorganizing the database?arrow_forwardThe database has not been normalized to its full extent. Please explain how. What kind of complications may this potentially cause?arrow_forward
- modern methods you would implement to harden your database environment.arrow_forwardWhat happens if the integrity of your database is not enforced? Where are mistakes most likely to happen?arrow_forwardMake a list of all of the databases that have information about you and your prior activities and keep this list handy. What approaches are used to collect the data for each database and how are they different? While it is important for each database to be updated on a regular basis, who is in charge of doing so? You have the option of printing the contents of any database that you use on a regular basis. Are you concerned about the security of your personal information?arrow_forward
- Make a list of all the databases that have information on you and your previous activity and keep it ready. What methods are utilised to acquire data for each database, and how do they differ? While it is critical that each database be updated on a regular basis, who is responsible for doing so? You may print the contents of any database that you use on a regular basis. Do you have concerns regarding the safety of your personal information?arrow_forwardWhat are the four most common causes of database failures that you plan to address to avoid data loss, and how will you do so?arrow_forwardAccess is an extremely flexible program. Can end users go online and view the database? What is the most effective way to make the database available online?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning