With he lecture please answer What steps would you take to evaluate this as a system change requests? How would you undertake a preliminary investigation for this project?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

With he lecture please answer

 

What steps would you take to evaluate this as a system change requests?

How would you undertake a preliminary investigation for this project?

Part 3: Mario's Place is Growing
Mario's Place has been growing at a very fast pace over the last two years. Three
new stores have opened (all near local College campuses), one closed, a new office
has been set up (unintentionally), new catering services have been added, and
several new staff members have joined the senior management team, including
Rosalina as their Marketing Manager. Through many changes Pauline has never lost
sight of the goal to serve only the best coffee, but she has had some challenges.
Main
Street
UBC
Campus
Gastown/
Vcc
Langara
/HQ
Downtown
(original)
Robson/
Career
Colleges
Currently, each store has a cash register and a credit/debit card terminal. The
amount of each product purchased is entered into the cash register. The cashier is
responsible to ensure that taxable transaction is entered in properly, separate keys are provided to enter each item that
is taxable or non-taxable. If the transaction is a cash transaction, the cash transaction total is entered, and the cash
drawer will open. If the transaction is using credit or debit, the credit transaction button is pushed, and the transaction
is finalized. The cashier enters the amount of the transaction into the credit card terminal and the customer pays the
transaction. This is a confusing and error-prone process.
In a meeting with Yoshi, Pauline started seeing problems in their revenue collection. Yoshi told her that often he cannot
read the daily cash deposits, and the bank has been sending deposit correction notices on deposits. The bank is only
sending him summarized transaction reports for the credit and debit machines, so store managers have not been able to
balance store sales. He is feeling a sense of growing frustration because he's being asked to confirm information which
he truly can't accurately confirm. Pauline recognizes that the current system is not sufficient for the future. She has
asked Yoshi to start a project to purchase a Point of Sale (POS) system that will move Mario's Coffee into the future.
Yoshi knew that eventually any new system would have to integrate with an accounting system, his first priority was to
ensure that he was getting accurate transaction data from each location. He was hoping that the new terminals would
be accessible remotely, but felt it was more critical that the system provided complete and accurate daily transactions
and summary information. It was also his hope that he would be able to confirm that each location sales and incoming
cash and card transactions balanced each day.
Yoshi visited each of the café locations to meet with café managers, each expresses similar requests of the new system.
Inventory continued to be problem; they often weren't certain what products were selling. They insisted the system be
able to track individual products sold and whether the transaction is cash or bank card. It was also important that the
system identified which cashier was responsible for each transaction. They wanted to be able to quickly balance at the
end of the day.
The coordinator, Isabella, indicated it would be great if the system could manage the event transactions as well. They
are almost always by credit card, but periodically, are paid for by cheque. The transactions are complicated though as
there are generally 10-15 products and services that make up an event invoice.
Rosalina insisted the system be able to automatically apply discounts and promotional pricing to ensure consistent
product pricing and it would be nice for it to be able to allow cashiers to sign up customers into a customer loyalty
program.
Transcribed Image Text:Part 3: Mario's Place is Growing Mario's Place has been growing at a very fast pace over the last two years. Three new stores have opened (all near local College campuses), one closed, a new office has been set up (unintentionally), new catering services have been added, and several new staff members have joined the senior management team, including Rosalina as their Marketing Manager. Through many changes Pauline has never lost sight of the goal to serve only the best coffee, but she has had some challenges. Main Street UBC Campus Gastown/ Vcc Langara /HQ Downtown (original) Robson/ Career Colleges Currently, each store has a cash register and a credit/debit card terminal. The amount of each product purchased is entered into the cash register. The cashier is responsible to ensure that taxable transaction is entered in properly, separate keys are provided to enter each item that is taxable or non-taxable. If the transaction is a cash transaction, the cash transaction total is entered, and the cash drawer will open. If the transaction is using credit or debit, the credit transaction button is pushed, and the transaction is finalized. The cashier enters the amount of the transaction into the credit card terminal and the customer pays the transaction. This is a confusing and error-prone process. In a meeting with Yoshi, Pauline started seeing problems in their revenue collection. Yoshi told her that often he cannot read the daily cash deposits, and the bank has been sending deposit correction notices on deposits. The bank is only sending him summarized transaction reports for the credit and debit machines, so store managers have not been able to balance store sales. He is feeling a sense of growing frustration because he's being asked to confirm information which he truly can't accurately confirm. Pauline recognizes that the current system is not sufficient for the future. She has asked Yoshi to start a project to purchase a Point of Sale (POS) system that will move Mario's Coffee into the future. Yoshi knew that eventually any new system would have to integrate with an accounting system, his first priority was to ensure that he was getting accurate transaction data from each location. He was hoping that the new terminals would be accessible remotely, but felt it was more critical that the system provided complete and accurate daily transactions and summary information. It was also his hope that he would be able to confirm that each location sales and incoming cash and card transactions balanced each day. Yoshi visited each of the café locations to meet with café managers, each expresses similar requests of the new system. Inventory continued to be problem; they often weren't certain what products were selling. They insisted the system be able to track individual products sold and whether the transaction is cash or bank card. It was also important that the system identified which cashier was responsible for each transaction. They wanted to be able to quickly balance at the end of the day. The coordinator, Isabella, indicated it would be great if the system could manage the event transactions as well. They are almost always by credit card, but periodically, are paid for by cheque. The transactions are complicated though as there are generally 10-15 products and services that make up an event invoice. Rosalina insisted the system be able to automatically apply discounts and promotional pricing to ensure consistent product pricing and it would be nice for it to be able to allow cashiers to sign up customers into a customer loyalty program.
Part 2: Mario's Coffee Expands
Pauline very much enjoyed working in the shops. When she was a teenager, she had worked with her Grandfather
learning how to make the various coffee drinks. Most of the many cousins in the family had worked at Mario's at some
point - several still worked here part-time. Mario had instilled into all of them his goal to serve only a perfect coffee
(several had also picked up his love of telling good stories!). Most of her time had been spent working closely with new
baristas, ensuring product quality, and with learning the other aspects of the busy cafés. There were a few problems,
service was sometimes slow, and they would periodically run out of supplies, but business was still good.
After a few weeks, she was feeling more confident in her role, so Pauline started focusing on growing the business. Her
first business opportunity came when she had lunch with a high-school friend, Daisy Mathes. Daisy owned a catering
company. Pauline, remembering her grandfather had started out providing a coffee service at weddings, saw an
opportunity. After much discussion, they decided to work together. Daisy would offer a coffee service as part of an
event package and Pauline would sub-contract when the service was requested.
Another opportunity presented itself when her leasing agent found a perfect location for her to expand. The location
was close to a local college and was large enough that she could provide a lounge space for customers. Working with her
agent, she negotiated a long-term lease and started working on renovations and hiring staff. Pauline was elated that all
her strategies were coming together, but at the same time was overwhelmed with the amount of work that she was
doing. She needed help.
She decided to hire for some key positions:
1.
General Manager (Mona): responsible for overall daily
operations, and the coordination of facilities and equipment,
and their related suppliers. The GM will consistently travel
between the different locations, ensuring that things are
working well.
2. Café Managers (Daisy, Morton): responsible for the day-to-day
operation of each of the coffee shops, the Manager would work
on all front-line operations, ensuring proper staffing, training,
and product quality was maintained.
3. Coordinator (Isabella): the coordinator would manage catering
event bookings and ensuring supplies for catering events are
ready and shipped to and from events. They also manage event
payments, collecting supplier invoices, and ensuring that they
are distributed for authorization of payment, or sent to the
accountant for payment.
4. Accountant (Yoshi): The coordinator would also collect sales
receipts from each store, ensure invoices were collected,
prepare payments for bills, enter all transactions in a spreadsheet.
General
Manager
MARTO
Cafe
Managers
Baristas
Customer
Service Reps
Pauline
(CEO)
Coordinator Accountant
Catering Co.
Transcribed Image Text:Part 2: Mario's Coffee Expands Pauline very much enjoyed working in the shops. When she was a teenager, she had worked with her Grandfather learning how to make the various coffee drinks. Most of the many cousins in the family had worked at Mario's at some point - several still worked here part-time. Mario had instilled into all of them his goal to serve only a perfect coffee (several had also picked up his love of telling good stories!). Most of her time had been spent working closely with new baristas, ensuring product quality, and with learning the other aspects of the busy cafés. There were a few problems, service was sometimes slow, and they would periodically run out of supplies, but business was still good. After a few weeks, she was feeling more confident in her role, so Pauline started focusing on growing the business. Her first business opportunity came when she had lunch with a high-school friend, Daisy Mathes. Daisy owned a catering company. Pauline, remembering her grandfather had started out providing a coffee service at weddings, saw an opportunity. After much discussion, they decided to work together. Daisy would offer a coffee service as part of an event package and Pauline would sub-contract when the service was requested. Another opportunity presented itself when her leasing agent found a perfect location for her to expand. The location was close to a local college and was large enough that she could provide a lounge space for customers. Working with her agent, she negotiated a long-term lease and started working on renovations and hiring staff. Pauline was elated that all her strategies were coming together, but at the same time was overwhelmed with the amount of work that she was doing. She needed help. She decided to hire for some key positions: 1. General Manager (Mona): responsible for overall daily operations, and the coordination of facilities and equipment, and their related suppliers. The GM will consistently travel between the different locations, ensuring that things are working well. 2. Café Managers (Daisy, Morton): responsible for the day-to-day operation of each of the coffee shops, the Manager would work on all front-line operations, ensuring proper staffing, training, and product quality was maintained. 3. Coordinator (Isabella): the coordinator would manage catering event bookings and ensuring supplies for catering events are ready and shipped to and from events. They also manage event payments, collecting supplier invoices, and ensuring that they are distributed for authorization of payment, or sent to the accountant for payment. 4. Accountant (Yoshi): The coordinator would also collect sales receipts from each store, ensure invoices were collected, prepare payments for bills, enter all transactions in a spreadsheet. General Manager MARTO Cafe Managers Baristas Customer Service Reps Pauline (CEO) Coordinator Accountant Catering Co.
Expert Solution
Step 1:system change requests steps:

Request any supporting materials

You want the person who is making the change to be as specific as possible. Ask that person to put their request in writing and provide any supporting materials that might be helpful.

Have that person articulate why they are requesting this change and what the anticipated benefit of their change request is. This will help your team determine whether or not the change request is worth the effort.
Determine whether the change request is in inside or outside the scope

It is a good idea to consider what the scope of the change request is. If your team chooses to implement this change, what new requirements will this put on the project? You will want to consider all aspects of the project that will be impacted by implementing this change request.

If the request is outside of the scope, a lot of problems might end up popping up – going over-budget, for example. Or having to waste too much time on a project you’d never even agreed on.
Have your team assess the priority of the change request

Before your team implements any changes to the project you should consider any possible risks. What is the expected benefit of the change being proposed? Is this change request the result of an actual need to respond to a change in the marketplace or would it simply be nice to have?

You can consider the opinion of the person who proposed the change request, but at the same time, use common sense. The client might not know what’s in their own best interests.

Have clearly defined guidelines for evaluating the urgency as there may be varying opinions amongst team members.
Approve or reject the change request

Now that you know how important (or unimportant) the change request is and understand the impact it will have on the project, the team can either approve or reject the request.

Different organizations will have different ways of going about the approval process. Generally, a change request that will require minimal additional work can be approved within the team. Whereas a change request that would require a month’s worth of additional work may require executive approval.
Decide on a course of action going forward

If the change request is approved then the project deliverables will need to be updated. This can include plans and schedules, business process documents, and the requirements documents.

Once these updates have been made, the project manager can communicate the new course of action to everyone who will be impacted. Now you can delegate the necessary tasks to the people in charge of implementing these new changes.

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Prototyping Systems
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education