Experiencing MIS
7th Edition
ISBN: 9780134380421
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 18CS
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 need to be made ensuring that any changes that happened in the piano need to be updated.
- Any alteration that is made regarding the condition of piano such as 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
Keeping a database in a steady state is the key to making it work well.
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?
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…
Chapter 5 Solutions
Experiencing MIS
Ch. 5.3 - Prob. 1SWCh. 5.3 - Prob. 2SWCh. 5.3 - Prob. 3SWCh. 5.3 - Prob. 4SWCh. 5.3 - Prob. 5SWCh. 5 - Prob. 1EGDQCh. 5 - Prob. 2EGDQCh. 5 - Prob. 3EGDQCh. 5 - Prob. 4EGDQCh. 5 - Prob. 5EGDQ
Ch. 5 - Prob. 6EGDQCh. 5 - Prob. 7EGDQCh. 5 - Consider the adage Never ask a question for which...Ch. 5 - Prob. 1GDQCh. 5 - Prob. 2GDQCh. 5 - Prob. 3GDQCh. 5 - Prob. 4GDQCh. 5 - Prob. 5GDQCh. 5 - Prob. 6GDQCh. 5 - Prob. 7GDQCh. 5 - Prob. 1ARQCh. 5 - Prob. 2ARQCh. 5 - Prob. 3ARQCh. 5 - Prob. 4ARQCh. 5 - Prob. 5ARQCh. 5 - Prob. 6ARQCh. 5 - Prob. 1UYKCh. 5 - Prob. 2UYKCh. 5 - Prob. 3UYKCh. 5 - Study Figure 5-17 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-17 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-17 into a...Ch. 5 - Prob. 9CECh. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 11CECh. 5 - Prob. 12CSCh. 5 - Prob. 13CSCh. 5 - Prob. 14CSCh. 5 - Prob. 15CSCh. 5 - Prob. 16CSCh. 5 - Prob. 17CSCh. 5 - Prob. 18CSCh. 5 - Prob. 19MLMCh. 5 - Prob. 20MLM
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_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
- What happens if the integrity of your database is not enforced? Where are mistakes most likely to happen?arrow_forwardmodern methods you would implement to harden your database environment.arrow_forwardThe database has not been normalized to its full extent. Please explain how. What kind of complications may this potentially cause?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
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningEnhanced 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 LearningDatabase 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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
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