Essentials of MIS (13th Edition)
13th Edition
ISBN: 9780134802756
Author: Kenneth C. Laudon, Jane Laudon
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 12, Problem 8HMP
The Warm and Toasty Heating Oil Company used to deliver heating oil by sending trucks that printed out a ticket with the number of gallons of oil delivered that was placed on customers’ doorsteps. Customers received their oil delivery bills in the mail two weeks later. The company recently revised its oil delivery and billing system so that oil truck drivers can calculate and print out a complete bill for each delivery and leave customers with the bill and a return envelope at the time the delivery takes place. Evaluate the business impact of the new system and the people and organizational changes required to implement the new technology.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Vegan Garden is a little restaurant that may be found in the tranquil village of Dawnsville. It has been five years since the eatery first opened its doors. At the moment, sales are recorded manually via the use of cash registers, and monthly sales reports and other corporate paperwork, such as information on employees and suppliers, are kept in dated filing cabinets. The owner of Vegan Garden has made the decision to develop an information system. He then went and sought the aid of a company that specializes in information technology in order to design an information system that would be suitable for the current commercial operations of the Vegan Garden.You have been given the responsibility of serving as the project manager for the creation of the Vegan Garden information system.As the project manager of the development project, it is your responsibility to advise the owner of Vegan Garden about the information system security issues that exist. Provide an explanation for ANY…
The table below is how Magical Medical Place (MMP) keep track of the medication it givens to
patients and the doctors that prescribed the medication.
Doc ID Doc Name Pat Name Pat contact
321456 John
321457 Sarah
Medication
Price Quantity
Reggy
Samual
0861236548
Penicillin
R200
10
0796549872
Antibiatics
R400
20
Robafen Cough
Doxycycline
Penicillin
Antibiotics
Robafen Cough
R10
40
321459 Mary
321460 Linda
321461 John
321462 Robert
Susan
0116549875
R250
20
Reggy
0861236548
R200
10
0321789654
0987349165
R400
20
Queen
Junior
R10
25
3.1 In which normal form is the above table? Motivate your answer.
3.2 Identify a Primary Key and motivate why the identified attributes were chosen.
3.3 Provide all the dependencies of the given table.
3.4 Convert the table into the second normal form.
3.5 Convert the table into the third normal form.
3.6 Must is the purpose of Normalization?
3.7 Provide two(2) suggestions on how to improve the design of the table after they have
been restructured into third…
Don’s Lumber Company on the Hudson River features a large selection of materials for flooring, decks, moldings, windows, siding, and roofing. The prices of lumber and other building materials are constantly changing. When a customer inquires about the price on prefinished wood flooring, sales representatives consult a manual price sheet and then call the supplier for the most recent price. The supplier in turn uses a manual price sheet, which has been updated each day. Often, the supplier must call back Don’s sales reps because the company does not have the newest pricing information immediately on hand. Assess the business impact of this situation, describe how this process could be improved with information technology, and identify the decisions that would have to be made to implement a solution.
Chapter 12 Solutions
Essentials of MIS (13th Edition)
Ch. 12.2 - Prob. 1CQ1Ch. 12.2 - Prob. 2CQ1Ch. 12.2 - Prob. 3CQ1Ch. 12.4 - Prob. 1CQ2Ch. 12.4 - Classify and describe the people, organization,...Ch. 12.4 - Prob. 3CQ2Ch. 12.4 - Why do you think the implementation of Snohomish...Ch. 12 - Prob. 1IQCh. 12 - Prob. 2IQCh. 12 - Prob. 3IQ
Ch. 12 - Prob. 4IQCh. 12 - Prob. 5IQCh. 12 - What are the core problem-solving steps for...Ch. 12 - Prob. 2RQCh. 12 - Prob. 3RQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - The Warm and Toasty Heating Oil Company used to...Ch. 12 - Prob. 9HMPCh. 12 - Prob. 11HMPCh. 12 - Prob. 12CSQCh. 12 - What problems was the Philly311 project designed...Ch. 12 - Prob. 14CSQCh. 12 - Prob. 15CSQCh. 12 - Prob. 18MLMCh. 12 - Prob. 19MLM
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
For each of the following activities, give a PEAS description of the task environment and characterize it in te...
Artificial Intelligence: A Modern Approach
Finish the program that takes a word as a command-line argument and looks up the word to see whether it is in t...
Programming in C
Body Mass Index Program Enhancement In Programming Problem 6 in Chapter 3, you were asked to create an applicat...
Starting out with Visual C# (4th Edition)
Consider the following skeletal C program: void fun1(void); / prototype / void fun2(void); / prototype / void f...
Concepts of Programming Languages (11th Edition)
ofstream file; file.open (info.dat, ios::tin); if (file) { cout Could not open file.\n; }
Starting Out with C++ from Control Structures to Objects (8th Edition)
Examine the following program. // This program uses variables and literals, public class BigLittle { public sta...
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
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
- The worksheet shown in the figure below contains two years of sales that will be used to create a PivotChart. The goal is to create a column chart that shows the total sales dollars by year for each month. Given this goal, what would be the best chart area to place the Year field? 1 2 3 4 3 6 7 . 9 10 11 12 13 14 15 Year Month 2017 April 2018 April 2017 August 2018 August 2017 December 2018 December 2017 February 2018 February 2017 January 2018 January 2017 July 2018 July 2017 June 2018 June VALUES O LEGEND AXIS FILTERS Total Sales Dollars $ 50,970.00 $ 48,400.00 $ 52,470.00 $ 50,700.00 $112,425.00 $120,000.00 $ 56,205.00 $ 56,850.00 $ 59,940,00 $ 62,950.00 $19.980.00 $ 18,500.00 $ 22.485.00 $ 21,000.00arrow_forwardNomenclature is a system for giving names to things within a particular profession or field. The XYZ Exporters and Co. is a new firm in Pakistan having two units in Karachi & Lahore. They decided to generate employee numbers using a specific pattern by applying nomenclature. This pattern consists of unit identification, department identification, employee appointment month, year and he/she will be having a unique registration number. The top management of XYZ Exporters and Co. has approved the following pattern for the employee numbers. Unit Code - Department Code / Joining Month Code - Joining Year - Employee Unique Number This Firm currently has five departments, HR, IT, Exports, Accounts & Finance, & Production, and two units Karachi & Lahore and their codes are as under: Department Name Department CodeHuman Resource 01Information Technology 02Export 03Accounts & Finance 04Production 05 Unit Name Unit CodeKarachi 1Lahore 2 Month Month CodeJanuary M01February…arrow_forwardTyler Richardson set up a house alarm system when he moved to his new home in Seattle. For security purposes, he has all of his mail, including his alarm system bill, mailed to his local UPS store. Although the alarm system is activated and the company is aware of its physical address, Richardson receives repeated offers mailed to his physical address, imploring him to protect his house with the system he currently uses. What do you think the problem might be with that company’s database(s)?arrow_forward
- Study the scenario and complete the question(s) that follow: Pearson Institute of Higher Education Library BooksThe Pearson Institute Library is comprised of many books covering various subjects. Students borrow these books to aid them in their studies. The Pearson Library team would like to know the ten most borrowed books by students. They have approached you as a Java Developer to help them to develop an app that will provide them with these statistics. They keep records of the borrowed books and the number of times they have been borrowed. Below is sample data from the Books.txt file that you have been provided with: Sample data – Books.txtIntroduction to Java programming; Daniel Liang; 25The C# Programming Yellow Book; Robert Miles; 12Learning Python; David Ascher; 10The C++ Programming Language; Bjarne Stroustrup; 21Programming PHP; Rasmus Lerdorf; 15 Create a Java application for the Pearson Library. The application must consist of a Book class that is composed of the book…arrow_forwardAn agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel Н4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. i. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.arrow_forwardAn university has decided to grant loans for the students. For this the financial administrator has to check with the number of students apply for loan with "Manage Loan and Grants" view. Student can enroll themself and apply for loan. Financial administrator will check whether the students has cleared the tuition fees up to last year, if the student is applying loan for current year tuition fee and enrollment was done for courses like seminars, etc. Professor will be allotted for the course once students got enrolled for subject. The actors involved in the system are student, scheduler, financial administrator and professor. The packages that are linked in the system are manage loan and grants, manage fees, manage seminars, enrollment. Identify the dependencies between one element and the other by drawing a package diagram forarrow_forward
- There have been several actors who have played the titular character in the British sci-fi series Doctor Who since the show began in the early 1960s. In 2005 the series was rebooted and Christopher Eccleston, David Tennant, Matt Smith, Peter Capaldi, and Jodie Whittaker have all played the Doctor since. Several Whovians (fans of the show) were asked to rank the actors of the Doctor from their favorite to their least favorite. The results are in the preference schedule below using the initials of each actor (so CE = Christopher Eccleston; DT = David Tennant; etc.). 6 8 12 16 17 18 23 20 1st Choice CE DT DT DT MS MS PC JW 2nd Choice MS CE PC PC JW CE JW CE 3rd Choice DT JW CE JW CE DT DT PC 4th Choice PC MS JW MS PC PC CE DT 5th Choice JW PC MS CE DT JW MS MS Is there a Condorcet winner?Answer: Explain: Do any of the voting methodsPlurality Method, Instant…arrow_forwardThe State of New York certifies firefighters through- out the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique fire- fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieu- tenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervi- sors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.arrow_forwardThere have been several actors who have played the titular character in the British sci-fi series Doctor Who since the show began in the early 1960s. In 2005 the series was rebooted and Christopher Eccleston, David Tennant, Matt Smith, Peter Capaldi, and Jodie Whittaker have all played the Doctor since. Several Whovians (fans of the show) were asked to rank the actors of the Doctor from their favorite to their least favorite. The results are in the preference schedule below using the initials of each actor (so CE = Christopher Eccleston; DT = David Tennant; etc.). 6. 8 12 16 17 18 23 20 1st Choice DT DT DT MS MS PC JW CE 2nd Choice CE PC PC JW CE JW CE MS 3rd Choice JW СЕ JW CE DT DT PC DT 4th Choice PC MS JW MS PC PC DT PC MS CE DT JW MS MS 5th Choice JW a. Is there a Condorcet winner? Answer: Explain: b. Do any of the voting methods Plurality Method, Instant Runoff Voting Method, Borda Count Method, Copeland's Method violate the Majority Criterion? Answer: Explain:arrow_forward
- Cozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person. Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff. The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office 1.When the Cozy Inn decides to use online systems, what is the customer-related information that needs to be protected and what are the major ways by which they should protect individual privacy of…arrow_forwardCozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person. Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff.The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office. 1.Identify and briefly discuss three main issues that Cozy Inn could face in the absence of an information system to integrate the business processes. 2.Discuss briefly how Cozy Inn can make use of…arrow_forwardCozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person. Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff. The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office. List and briefly discuss five of the business processes in the organisation.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Dynamic Programming - Learn to Solve Algorithmic Problems & Coding Challenges; Author: FreecodeCamp.org;https://www.youtube.com/watch?v=oBt53YbR9Kk;License: Standard YouTube License, CC-BY