Experiencing MIS
8th Edition
ISBN: 9780134792736
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 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
Experiencing MIS
Ch. 5.3 - Prob. 1SWCh. 5.3 - Prob. 2SWCh. 5.3 - Prob. 3SWCh. 5.3 - Prob. 4SWCh. 5 - Prob. 1EGDQCh. 5 - Prob. 2EGDQCh. 5 - Prob. 3EGDQCh. 5 - Prob. 4EGDQCh. 5 - Prob. 5EGDQCh. 5 - Prob. 6EGDQ
Ch. 5 - Prob. 7EGDQCh. 5 - Consider the adage Never ask a question for which...Ch. 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. 19MMLCh. 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
- 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_forwardThe database hasn't been fully normalized yet. Please elaborate. What issues may this possibly result in?arrow_forwardMaintaining 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_forward
- What are the importance of data validation. What happens if you do not ensure your data is correct prior to entering it in the database? What are some methods for data validation?arrow_forwardSupervisors are needed to maintain databases. What's involved? A database administrator's usual day?arrow_forwardBy reducing the amount of data that is duplicated across different tables, relationships can lower the total amount of information that must be kept in a database.arrow_forward
- Make 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_forwardIs it absolutely crucial to revamp the database's structure, and if so, why?arrow_forwardMake 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_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 Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author: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
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