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 (13th 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 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…arrow_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_forwardA library wants to build a simple online recommendation system for a summer reading programme. The system involves people reading and recommending books and authors. • Readers (people) have a screen name as well as a real name and contact information, including an unknown number of phone numbers they can be contacted at. • Books have a title, ISBN, genre and reading level. • An author has a name and nationality. They can write zero or more books. • Assume that Books are written by only one author. • The database records what books a reader has read. • Readers can “like” books. • Readers can “like” authors independent of the books the author has written. Create a hand-drawn, conceptual entity relationship diagram (like the last lab, except that you’re including attributes) describing this circumstance for a database designer.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_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_forwardThe 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_forward
- RentQualityComputers is a computer company that specializes in renting computers, printers, scanners, network equipment, game consoles, and games. They rent to businesses, nonprofit organizations and individuals. They want to keep better track of its customers and inventory. A unique customers number is assigned by the store to each of the customers. The store also need to know last and first names, e-mail address, phone number, mailing address (including city, state and zip code) and customer type for each customer. Each non-profit organization and business customer has a contact person and for each individual customer the store wants to know his or her title(Mr./Mrs./Ms./Dr.). The store has 500 laptops, 200 tablets, 50 printers, 30 scanners, 20 routers, 40 switches, 500 game consoles and 1600 games in the inventory, each individually identified. The store maintains 200 game titles, so in average there are eight copies of each game in the inventory. For each indivdual item the store…arrow_forwardLuxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to theWashington, D.C. area. In recent years, LOST has grown quickly and is havingdifficulty keeping up with all of the various information needs of the company. Thecompany’s operations are as follows:LOST offers many different tours. For each tour, the tour name, approximatelength (in hours), and fee charged is needed. Guides are identified by anemployee ID, but the system should also record a guide’s name, home address,and date of hire. Guides take a test to be qualified to lead specific tours. It isimportant to know which guides are qualified to lead which tours and the datethat they completed the qualification test for each tour. A guide may be qualifiedto lead many different tours. A tour can have many different qualified guides.New guides may or may not be qualified to lead any tours, just as a new tour mayor may not have any qualified guides.Every tour must be designed to visit at least three…arrow_forwardLuxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…arrow_forward
- can i get answer for this with simple code?arrow_forwardA rich uncle owns about a dozen classic automobiles. He keeps them in several garages around town and actually drives them for different events. At a recent family holiday get-together, he mentioned that he struggles to remember the maintenance schedules for all of the vehicles. He has records for all of the service work, including oil changes, tune-ups, and other repairs. But currently, they are just paper receipts and he needs a way to track and schedule the maintenance so that any of the cars will be available for use when he wants it. He also would like to plan his usage so that he doesn’t have to get all of the cars serviced at the same time. You suggested that it would be a good application for a database. Actually, you are really hoping he will let you borrow one of them for a date; but first you have to design the database.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
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage