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)
- The Happy Tails Pet Store wants to create an online system for their customers, so they can buy a pet through their system. The customer can create an account, search pet kinds, choose a pet and pay for their pet that he/she chose. Each Pet has an ID, name, type, gender and colour. Each pet can be either b cat, a dog or a rabbit. The customer can buy one pet or more. The supplier provides the store with the pets. Each supplier has a name, phone number company address. The pet store deals with several suppliers. However, eve supplier must provide one type of pet. The supplier adds the provided pet t- the system. The customer must fill the required pet type, colour and gender, then the system will display all available pets based on the customer choice. The customer must pay for the system online through her/his visa card or the pe will not be delivered to the customer. After paying for the pet, the system w display a thank you message. The functions supported by the system: • Create an…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_forwardMany of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…arrow_forward
- Many of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…arrow_forwardUse the following scenario to answer the questions that follow. A hotel that delivers food to customers would like to develop an information system that will help them serve their clients efficiently. Currently they run a manual system whereby a customer calls to make an order. The calls are usually received by the receptionist who looks at the menu list and tells the customer the amount of money he/she is supposed to pay, and how long it will take to prepare the order. Once the customer agrees to the terms and conditions of the delivery. The receptionist writes down the order and the customer details in a piece of paper and gives the piece of paper to the caterer. The caterer prepares and packs the order and sticks the order details he/she received from the receptionist to the food package. The packed order is then handed over to the delivery person who will deliver the order in a motorbike. The receptionist usually has contact details of the motorbike guys whom she would call to…arrow_forwardConsider the process of reserving a bus ticket over the phone and write a step by step use case description/ elaboration of the case study given below: When a customer calls the Agent on the phone, they are asked about the Arrival date and time, and the Destination city. The agent then informs the customer about the available route timings. The customer then selects the appropriate route timings and number of seats he wants to reserve. The agent confirms if seats are available, then asks the customer for his name and phone number. Finally, the agent informs to the customer about successful reservation.arrow_forward
- Algonquin Homes is a new home builder in Eastern Ontario. They specialize in detached homes on larger lots with quality finishes. They currently have 3 communities that they are building; Westgrove, Apple Hills and Wild Meadow. Each community has a site plan which shows the location of the community within the larger region, the location of each lot in the community including a lot number, and the street names and addresses within that community. Each of these communities has a different number of lots for sale. A number of model homes are available to be built on a lot. Larger lots will allow for a home with a three car garage, while smaller ones will allow only a two car garage. Each model has a number and a name. Each lot has a lot number and lot dimensions – metres wide by metres long. Sometimes, a community sells out fast leaving only 2 or 3 lots unsold. In this case, the builder can reduce the base price of the lot and model home as an incentive to make the sale. The community…arrow_forwardA restaurant chain has several locations in a city (with a name and zip code stored for each), and each is managed by one manager. Each manager manages multiple restaurants. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, items can appear on multiple menus, and each menu has a price on it. A customer can visit multiple restaurants and a restaurant can have multiple customers. Represent this situation of restaurants with an E-R diagramarrow_forwardThe State of New York certifies firefighters throughout 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 firefighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieutenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervisors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.arrow_forward
- A local veterinarian hospital keeps record about the different pets they see over time, as well as information about the owners and treatment provided.The following tables represent a sample of the information recorded about owners, pets, and treatments. Owners LastName FirstName Phone Downs Marsha 555-537-8765 James Richard 555-537-7654 Frier Liz 555-537-6543 Pets PetName Type Breed Weight King Dog Std. Poodle 25.5 Teddy Cat Cashmere 10.5 Fido Dog Std. Poodle 28.5 King Horse Border Collie 25.0 Treatments Name Anesthesia Required Vaccine No Dental Yes Surgery Yes A veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital. For each of the visit, it is essential to record the various information…arrow_forwardJoziCleaners is local cleaning service that is looking to upgrade their current operations by making use of a database to keep track of the teams, houses, clients and billings of each client per/week. Each house is cleaned by one or more teams. A team goes out to a particular house on a certain day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day, except the team leader who earns a unique amount. The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a spreadsheet in Figure 1 below. Day Client Client Name Team Members Team Leader Leader Total Code ID Wage Monday Aeliana Gebahard T3 6. Jaymes Merrickson R 350 R 850 C10 Alfher Dareia T1 Geoffrey Glover R 250 R 750 C8 Felina Diodotus T2 Elmer Victorson R 300 R 700 Brutus Sigihild Sigibert Quirinus Brutus Sigihild C9 T4 Norris Mamadou R 400 R1 000 Tuesday CS T3 Jaymes Merrickson R 350 R 850 C9 T2 5 Elmer Victorson R 300 R 700 Alfher Dareia Duncan Gardyner Geoffrey Glover…arrow_forwardEach publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.arrow_forward
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage