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)
- 1)Modeling: Make a CDM from the following scenario: * A retail company wants to manage their sales activity. We have the following information- The date of sale, with the possibility of rolling up to the week, month, quarter and year- the store where the sale was made: store name, brand, address, city, department and region. - The employee associated with each sale: surname, first name, date of birth, social security number. Each employee is associated with a store.the customer who purchased the product surname, first name, date of birth, address. The product sold product name, d - iption, category, unit price. The order: quantity sold, amount of turnover, amount of margin. A transaction can consist of one or more orders. The indicators (quantity, turnover, margin) can be negative if it is a reimbursement. 2) In your MCD above, what are the dimension tables? * 3)In your MCD above, what are the fact tables?arrow_forwardARENA is a multi-user, Web-based system for organizing and conducting tournaments. ARENA is game independent in the sense that organizers can adapt a new game to the ARENA game interface, upload it to the ARENA server, and immediately announce and conduct tournaments with players and spectators located anywhere on the Internet. Organizers can also define new tournament styles, describing how players are mapped to a set of matches and how to compute an overall ranking of players by adding up their victories and losses (hence, figuring out who won the tournament). To recoup their operational costs, organizers can also invite potential sponsors to display advertisement banners during games. USE-CASE DIAGRAM: A. Identify Actors and Use Cases for the Arena Game System. Draw the Use Case Diagram that details the high-level functionality of the system. Make sure to have includes and extends relationships between use cases where relevant. B. Pick any 2 use cases from your diagram and provide…arrow_forwardQuestion 2: When the customer reaches the ticket booth, he/ she see the menu on the screen. In this menu there are four sections. 1.Lahore 2.Karachi 3.Peshawar 4.Quetta. The programmer usually travels from Rawalpindi railway station to rest of the cities. For traveling to the following cities software engineer can select any one of the categories: 1.Rawalpindi to Lahore a.Executive Class b.Lower A/C c.Economy 2.Rawalpindi to Karachi a.Executive Class b.Lower A/C c.Economy d.First Class Sleeper e. Economy Sleeper 3.Rawalpindi to Quetta a.First Class Sleeper b.Economy Sleeper 4.Rawalpindi to Peshawar a. Executive Class b.Lower A/C c.Economy User can choose any of the above mentioned choices to go to different cities. From these choices further he can choose what sort of bogie he wants. Each bogie hasits own respective price. Once passenger has chosen the bogie. This price also has 15% of tax which has to be included. Define the price for different bogies and destination by…arrow_forward
- Question 1: Suppose you have the following scenario: The Palm Tree System is a system that offers multiple services to farmers. The farmer can search for product, buy product and reserve appointment for consultation. Also, he can add comments on the services provided for him. An expert can answer questions and post advices. Both of them need to log in to the system. By using Star UML tool, draw a Use Case diagram for the above scenario.arrow_forwardimagine that as example We have a transportation company operates individual taxis and shuttles. It uses its taxis for transporting in the form of an individual or small group from one location to another. On the other hand, the shuttles have different scenario. They are used to pick up individuals from separate locations and provide them conveyance to several destinations. Any individual can call the company from anywhere. It may be a hotel, a mall, entertainment venue or any tourist company. When the company receives a call from such individuals, it tries schedule any available taxi for pickup service for fee-based If There's no available taxi, it does not operate any form of queuing system. Means " If there is no available car, the order is lost " If the vehicles are available, the individual confirms for pick-up. After arrival at the pick-up place the driver notify the company that it has picked up the passenger. The driver notifies the company again at the time of dropping him…arrow_forwardTesta Inc. is a company specializing on self-driving electric vehicle (EV) production. In Testa, a self-driving EV is represented as a model, which is identified by its Model_No and has the attributes of Model_Desc (description), Production_Date, and Model_Cost. Each model uses one to many parts in its production; each part may be used in zero to many models. The number of parts (Num_Parts) is recorded for each part used in a model. Each part is identified by Part_No and has the attributes of Part_Name, Part_Cost, and Effective_Date. Each part may consist of zero to many other parts; each part may be a component of zero to many other parts. The nearby entity-relationship diagram shows the aforementioned situation. Testa is asking you to develop a MySQL database to manage its part and model data. You will create the tables and their data in your MySQL account and upload the MySQL script here. First, you are required to download a text file (click here) and then open it using a text…arrow_forward
- This is the problem Create a complete ERD in Crow’s Foot notation that can be implemented in therelational model using the following description of operations. Hot Water (HW) is asmall start-up company that sells spas. HW does not carry any stock. A few spas areset up in a simple warehouse so customers can see some of the models available, butany products sold must be ordered at the time of the sale.• HW can get spas from several different manufacturers.• Each manufacturer produces one or more different brands of spas.• Each and every brand is produced by only one manufacturer.• Every brand has one or more models.• Every model is produced as part of a brand. For example, Iguana Bay Spas is amanufacturer that produces Big Blue Iguana spas, a premium-level brand, andLazy Lizard spas, an entry-level brand. The Big Blue Iguana brand offers severalmodels, including the BBI-6, an 81-jet spa with two 6-hp motors, and the BBI-10,a 102-jet spa with three 6-hp motors.• Every manufacturer is…arrow_forwardConsider an airport management system. Each airport has a unique id (e.g. Montreal:YUL). Let us introduce the types AIRPORT and CITY . We also introduce variable airports that contains associations between airport id’s and their corresponding host cities. A possible state of the system is shown below:airports ={YUL → Montreal,LCY → London_UKLHR → London_UK,MIL → Milan,SFO → San_Francisco,SDQ → Santo_Domingo}1. Provide a declaration of variable monitored that holds all airport id’s. 2. What kind of variable is airports? Provide a formal definition together with any and all applicable properties. 3. Describe what data structure you would deploy to model variable airports. Note that you may not use a Dictionary. Should this be an ordered or an unordered structure? Discuss. 4. Provide a formal specification of the state of the system in terms of a Z specification schema. 5. Provide a schema for operation AddAirportOK that adds a new airport to the system. With the aid of success and error…arrow_forwardMake a UML Class Diagram based on the following scenario: As a Software Analyst in Techno Bhd., you have been assigned by your Project Manager to model an SUV Rental Provider App using UML. The SUV Rental Provider App has two types of system users namely Client and Admin. The client, who can be Member or Non-Member can search for SUV models and daily rental. Each SUV model consists of SUV model details and daily rental. Thus, the Client can choose to view the SUV model details such as description and images and daily rental based on the types of the selected model. Only Member and Admin are required to log in to access the system. Member gains access to additional services. The additional services for members are: manage a reservation, check membership details, change password, manage credit card and banking information, and log out. Each Member is entitled to reserve up to 10 SUVs. When a member makes a reservation, he/she has to specify the selected SUV model and the number of rental…arrow_forward
- Ending:The clinic runs in two six hour shifts (7a.m to 2p.m) and (2p.m to 8p.m). Managershould be able to schedule doctors, nurses, and secretaries for shifts. Doctors arepaid by the government but the Manager is supposed to pay salary to all otheremployees based on their hours worked. The system should be able to store thisinformation and the manager should be able to generate a bi weekly report for thehours worked by the nurses and secretaries and therefore calculate their salaries(assume reasonable hourly rates for nurses and secretaries). QUESTION:Create a query that returns a list of all patients and their family member(add a column primary member id in the patient table; make one patientas the primary member and then create another column calledrelationship and add husband, wife, son, daughter etc.)arrow_forwardIn Bangladesh Premier League (BPL) player selection system, each team ownerpossesses a numbered paddle that is used to indicate a base price for a player. The BPLmanaging committee then starts the proceeding by mentioning the base price, and checkswhen a paddle is raised to accept that price to buy that player. As a result, the acceptanceof the player’s base price changes which is broadcast to all the team owners in the formof a new bid.Which design pattern is applicable here and why? Which design pattern is applicablehere and why?arrow_forwardConsider a books ordering system in order to purchase books. Process order is elaborate below in order to define the logical functions ofthe system. First, incoming orders are checked for correct book titles, author's names, and other information and then batched into other book orders from the same bookstore to determine how may copies can be shipped through the ware house. Also, the credit status of each book stores is checked before shipment is authorized. Each shipment has a shipping notice detailing the kind and numbers of booked shipped. This is compared to the original order received (by mail or phone) to ascertain its accuracy. Thedetails of the order are normally available in a special file or data store, called "Bookstore Orders”. Following the order verification and credit check, a clerk batches the order by assembling all the book titles ordered by the bookstore. The batched order is sent to the warehouse with authorization to pack and ship the books to the customer.…arrow_forward
- Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole