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.
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
Essentials of MIS (12th Edition)
Additional Engineering Textbook Solutions
Artificial Intelligence: A Modern Approach
Programming in C
Starting out with Visual C# (4th Edition)
Concepts of Programming Languages (11th Edition)
Starting Out with C++ from Control Structures to Objects (8th Edition)
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
- An 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_forwardStudy 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_forwardDon’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.arrow_forward
- 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_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_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 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_forward
- The 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_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_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
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage