ICTPMG505_Assessment 2 (1) - Carlos D

Vista previa del material en texto

Assessment 2 - Unit Project
Unit Project
Case Study:  Amazing Restaurant 
The world-renowned curry chef Mr Amazing opened the Amazing Restaurant in 2017. The restaurant provides authentic dishes from the foothills of the Himalayas to the hot seas of the Indian Ocean.  The restaurant has a seating capacity for 300 customers.  
 
The restaurant’s recent growth no longer makes it feasible to maintain customer, table booking, order and day-to-day activities using its manual systems. With the data stored in the database, management will be able to ensure that data are current and more accurate than in the present manual systems. In addition, Mr Amazing will be able to obtain answers to their questions concerning the data in the database easily and quickly, with the option of producing a variety of useful reports.  
 
In lieu of this, Mr Amazing, has decided to contact your consultancy company to set up a database to deal with the day to day running of the business.  After careful investigation and analysis, your consultants realise that it is not all as calm as is first perceived.   
The restaurant has a booking service where customers can book their tables beforehand and also book a certain table if they wish. Customers need to provide their title, full name (first and last), city and phone number. The staff checks if the customer is in the database and uses the existing record.  
 
If the customer is booking for the first time, a new record is created.  When making the booking, the date, time, number of people that will dine in and table number (optional) information are requested. The name of the staff who took the booking must be recorded. Each booking has a default 2-hour timeslot, which can be changed in case the customer wants to stay longer.  
 
Upon entering the establishment, customers need to speak to a receptionist, who checks whether they already have a booking. If the booking exists, the customers are taken to their table. If the customer does not have a booking, the receptionist checks the availability, if the customer is in the database and if there are tables to accommodate, the receptionist adds the booking for the customer before taking them to the table.   
 
Once settled, customers then are served by a staff member who takes the orders.   
Mr Amazing also wishes to publish a recipe book and because of this he needs to know what ingredients are needed in the different dishes. Mr Amazing also thinks that this would help in training new staff and if the chef leaves then he would not take all the knowledge away with them.   
 
Specific Requirements:  
In order to meet the business needs required to design the following database element: structure, indexes, queries and or reports 
To ensure consistency of the data in the database you are required to develop data validation rules to ensure the correctness of data entered into the database table; identify referential Integrity constraint and database constraints.  
Below is a list of checks you should implement:   
1. Staff gender should be recorded as ‘M’ or ‘F’.   
2. Ensure that every customer has a telephone number which is unique  
3. Staff numbers should be generated automatically using a sequence. 
 
· Design and develop database for amazing restaurant
· Design and implement Front end interface using java standard widget toolkit SWT for following:
· User Login – must request username and password 
· Dashboard (users should only view the options according to their access level) – the dashboard should display the buttons for Booking, Table Assignment, Table Order, Total Bill and Create Staff (admin users only) 
· Make Booking – performs a table booking at the restaurant 
· Booking list – searches for bookings on a particular date, allows to edit the booking (amend dates and delete bookings) 
· Table assignment – assigns a table to the booking 
· Table order – GUI only 
· Total bill – GUI only 
· Create staff – only admin users will be able to access and create a new staff user. 
· Edit Staff - only admin users will be able to access and edit a staff user 
· Connect the Java application to the database using JDBC 
Time frame for the project completion is 2 months. Available budget is 20,000.
Students are asked to form groups of 3 -5 students – with one student acting as a Project manager. You are the manager and the others are fictitious names.
Your primary tasks are:
1. Prepare a Project Plan for design and develop database for amazing restaurant.
2. Design and implement Front end interface using java standard widget toolkit SWT
3. Test the application
4. Prepare a full report that consists of all given information. Compile the answers to the given tasks, and format them with project report template. 
5. Prepare a power point presentation. Explain the plan.
 
The assumed milestones are: 
· You will gather data/information about the business and perform requirement modelling.
· You will translate the business requirements into technical specifications.
· You will present your project plan to the management for final approval prior to implementation.
· You will maintain and monitor the amazing restaurant system. 
The assumed requirements are: 
· You will plan for designing an interface for administration, staff and customers.
· You will plan for building amazing restaurant database system using either MySQL or MS-ACCESS or other tools of your choice. 
· You will plan for building online interface and access point (with login facilities) 
We assume that you have gathered all relevant information from previous assessments. 
Complete all given tasks. 
Task 1.	Visit the link and read what Project governance is and follow its processes to confirm Amazing Restaurant Governance Policy? (https://www.pmi.org/learning/library/project-governance-critical-success-9945) and Confirm business problem or opportunity and project objectives according to organisational needs
Task 2. Identify the Scope, Time, and Cost constraints for the Amazing Restaurant project. Develop project charter and obtain sign-off. 
Background
The increased number of clients makes it more difficult for personnel to manage table bookings, orders, day-to-day operations, and customer retention manually. As a result, Mr. Amazing decided to approach the consulting firm in order to put up a database that deals with the restaurant's day-to-day operations. The database provides options for management, such as ensuring that the data saved is current, up-to-date, and more accurate than the manual approach. Mr. Amazing can also obtain relevant output and information from the database data and generate a range of useful reports.
Scope
· Create a graphical user interface (GUI) for each JAVA application, such as user or employee login, customer registration, POS system, and employee registration.
· Make a database for the client, the menu, and the personnel.
· Ensure that the database and JAVA program are both secure.
· Ensure that the dashboard is easily accessible and understood to personnel.
· Database validation is in place.
· The JAVA apps' programming is well-written.
· Ensure that the system's graphical user interface allows consumers and staff to enter information reliably and correctly.
· Check that each data point is appropriately related to the others.
· Ascertain that the database has adequate storage to support the staff, customers, and menu information.
· Create a system that allows clients to buy their tickets while preventing multiple bookings.
Stakeholders
· Client: Mr Amazing owner
· Sponsor: Restaurant
· Project Manager
· Project Team members
	Items
	Costs
	Quantities
	Total Cost
	SQL Server
	$8200
	1
	$8200
	Server
	$1400
	1
	$1400
	Project manager
	$40 per hour
	160
	$6400
	Database Administrator
	$30 per hour
	160
	$4800
	System Designer
	$35 per hour
	160
	$5600
	Programmer
	$25 per hour
	160
	$4000
Task 3. Conduct Feasibility Study and outline if the project is technically and operationally feasible? 
Technical
The market technologymakes the project practical and allows for the upgrade of the database and ordering system. Furthermore, the required software is easily available on the market.
Operational
Employees who will utilize the system will be properly trained on the new system and the new hardware implemented as part of the project. Customers will also be informed about the improvements in the restaurant and how they may utilize it to meet their requirements.
Economical
The investment is worthwhile since, if the update is successful, the services given will improve the restaurant's system, making it more efficient.
The budget for the project is $37,000.
Task 4. Use your information-gathering techniques to collect more information about the project. Search for competitors (Other education providers) and find their services.
 Which type of questions is more appropriate (e.g. open ended, closed ended, range of answers)? 
 Prepare short interview questions to ask the director of Amazing Restaurant. Ensure the interview questions are of high standard. 
· What type of system do they intend to create?
· What material do they want to add in the database and application?
· What database and software design policies do they wish to put in place?
· What are their expectations for how we should manage the data?
· When do they want the system to be completed?
· How do they want the information in the database and the JAVA program to be structured?
· How are the information's linked to one another?
Task 5. Define System Development Life Cycle (SDLC) in your own words. Describe how different phases of SDLC may be applied in your project.
· The first phase of the SDLC, analysis, occurs in the early phases of the project, when the scope, time, and budget are established.
· Once the analysis is completed and the system's problems have been addressed, the team will begin planning a solution to the problems.
· The planned system has been created. The physical building, operating systems, programming, and security plans are complete.
· During this phase, the new system is being developed. The resources required to carry out the strategy must be procured, and user training is being carried out.
· All system components must be tested, and any necessary adjustments must be made at this stage.
· During this phase, the new system must be implemented.
· System maintenance entails improvements required to guarantee that the system is always in top working order. For example, ensuring that the system's security is up to date to lessen the likelihood of a hack. Users must also be kept up to know on the most recent modifications.
Task 6. Prepare project work breakdown and schedule for your project. 
Task 7. Build and present Gantt chart to your trainer.
 (Note- You can simply use online Smartsheet with the following link to create Gantt chart easily. https://www.smartsheet.com/gantt-chart-software
 OR 
 You can use Excel, MS Project or any other open-source software available on your Desktop.)
Amazing restaurant.gan
Task 8. Prepare necessary documents of project management plan by following standard protocols to get approval from appropriate person.
Documents include Gantt project
Task 9. Identify and select the team members (including the manager). 
 Create a table that shows the team members, their roles and responsibilities. 
	Team Members
	Job Roles
	Responsibilities
	Ashley Lacson
	Project manager
	· Activity Planning and Scope Definition Planning and Scheduling 
· Resource Management
· Creating Budget Documentation
· Making Charts and Scheduling
· Risk Analysis
· Progress Monitoring and Reporting 
· Strategic Leadership in a Team
· Working with Vendors Quality Control
	Anna Crain
	Database Administrator
	· Create and construct a database based on the information requirements of the end user.
· Define users and enable data dissemination to the relevant user in the suitable format and on time.
· Use fast transaction recovery solutions and backup your data.
· Create, implement, and document database policies, processes, and standards.
· Monitor database performance, make modifications, and install new patches and versions as needed.
	Danny Poneglyp
	Programmer
	· Debugging and coding.
· Creating and testing computer architectures.
· Troubleshooting system problems.
· Creating computer programs.
· Upkeep of operating systems.
· Algorithm profiling and analysis.
· Building systems are being implemented.
· Providing technical assistance.
	Clark Saundes
	System Designer
	Work with analysts to determine the feasibility of a conceptual design by using technical requirements prepared by the analyst and creating system components to meet the set requirements. Create detailed design documentation, including charts and diagrams that show the various components involved. Prepare instructions for programmer implementation.
Task 10. Determine and discuss the training and support needs of your client.
Training:
- Teach them how to troubleshoot common and simple problems with DBS and the Java application.
- How to use the database.
- How to record or create a new record.
- How to produce a report. 
- How to access the information. 
- What type of information do they need to write in the database?
Support 
- They may call helpdesks to request troubleshooting; they can even contact us if they require assistance with the entire system, such as the DBS or the program itself.
Task 11. Determine teams’ values and expected behaviours for project teams members.
(go to this link : https://www.pmi.org/learning/library/project-team-performance-expected-behaviors-6759) and Document team members, role allocation, training and submit to seek feedback from required personnel.
· Treat others with dignity and respect
· Support and promote intra- and inter-departmental teamwork
· Understand and consider the needs and impacts of your own work on others
· Demonstrate an ability to problem-solve and make timely decisions
· Actively seek and receive feedback for improvement
· Consistently share knowledge and information
Task 12. Monitor delivery of the project by evaluating results of team member’s efforts and manage each individual of the team.
	Team members
	Team member’s assigned tasks
	Project delivery
	
Anna Crain
	· Create and construct a database based on the information requirements of the end user.
· Define users and enable data dissemination to the relevant user in the suitable format and on time.
· Use fast transaction recovery solutions and backup your data.
· Create, implement, and document database policies, processes, and standards.
· Monitor database performance, make modifications, and install new patches and versions as needed.
	Team member had great performance developing her assigned tasks in a timely manner
	
Danny Poneglyp
	· Debugging and coding.
· Creating and testing computer architectures.
· Troubleshooting system problems.
· Creating computer programs.
· Upkeep of operating systems.
· Algorithm profiling and analysis.
· Building systems are being implemented.
Providing technical assistance.
	Team member was able to perform most of his task properly however was unable to troubleshoot some errors.
	Clark Saunders
	Work with analysts to determine the feasibility of a conceptual design by using technical requirements prepared by the analyst and creating system components to meet the set requirements. Create detailed design documentation, including charts and diagrams that show the various components involved. Prepare instructions for programmer implementation.
	Performed properly and in a timely manner
Task 13. Monitor and control the quality of project deliverables against the requirements.
	Project deliverables 
	Requirements
	Need Change?
	
· Gather database information.
· Develop and present project plan
· Implement plan
· Maintain and monitor restaurant system
	· Have a database engineer
· Have an expert project manager
· Define a departmentthat ensures plan implementation will be simple.
· Develop a system to monitor plan implementation perofrmance
	Get software for information storage and improve website.
Task 14. When the deliverables change during the project the current budget and deadlines are adjusted to reflect the additional work. 
 (a)Amazing restaurant decided to put their system on Cloud with full backup services. 
 (b)Identify the cost and additional requirements to accommodate the above changes.
 (c)Monitor and control project scope changes, risks, and issues.
	Cost
	Storage
	$400 per year
	Website
	$6800
Task 15. Test the functionality of Database (Amazing Restaurant) by following testing protocols to meet requirements and hand over to amazing restaurant staff.
Testing made over file attached
Task 16. Prepare IT support plans and support documents for Amazing restaurant database.
Determine the IT support requirements: Determine the sorts of IT assistance needed for the database. Help desk support, user training, software maintenance, hardware maintenance, and database management are all possible.
Define the IT support procedures: Define the IT support processes, such as incident management, issue management, change management, and release management.
Document the IT support protocols: Document the IT support procedures, including how to report events, escalate problems, and seek improvements. This will aid in the delivery of IT assistance in a timely and effective manner.
Produce user guides and training materials: Produce user guides and training materials to assist users in understanding how to use the database. Step-by-step instructions, video tutorials, and frequently asked questions may be included.
IT team will have to communicate through a slack secure channel.
Task 17. Prepare project closure by following tasks:
(A) Obtain final project Sign-off with required personnel
(B) Conduct post project review and document lessons learned
(C) Review and update disaster recovery plan
(D)Close the project by proper document signing with appropriate person.
Client sign off request,
Dear Mr Amazing
This form is used to officially sign off on the conclusion of your project with us. Please finish as quickly as possible and return it to us.
Thank you very much.
Project Name: Amazing Restaurant Plan
Project Manager: Ashley Lacson
Start Date: 9/3/23
End Date: 8/5/23
Scope
· Create a graphical user interface (GUI) for each JAVA application, such as user or employee login, customer registration, POS system, and employee registration.
· Make a database for the client, the menu, and the personnel.
· Ensure that the database and JAVA program are both secure.
· Ensure that the dashboard is easily accessible and understood to personnel.
· Database validation is in place.
· The JAVA apps' programming is well-written.
· Ensure that the system's graphical user interface allows consumers and staff to enter information reliably and correctly.
· Check that each data point is appropriately related to the others.
· Ascertain that the database has adequate storage to support the staff, customers, and menu information.
· Create a system that allows clients to buy their tickets while preventing multiple bookings.
Deliverables
· Gather database information.
· Develop and present a project plan
· Implement plan
· Maintain and monitor the restaurant system
By signing this form, I certify that I have completed all of the mentioned deliverables.
-------------------------
Project Manager
-------------------------
Mr. Amazing
Date: 
Task 18. What could be the possible risk? Create Risk Management plan for your project. 
	Risk #
	Date of risk
	Brief description
	L
	M
	H
	Mitigation Action
	1
	11/3/23
	Missing information about market
	X
	
	
	Improve the market research and analysis made.
	2
	16/3/23
	Not defined requirements
	
	X
	
	Ensure internal department will review company information deeply
	3
	4/4/23
	Plan not approved
	
	
	X
	Present plan with enough time in order to be able to apply changes
	4
	26/4/23
	Team members unable to implement plan
	
	X
	
	Provide clear guidelines in order to make it easier for the team members.
	5
	6/5/23
	Failure in monitoring program
	
	X
	
	Ensure we will work on program definition in order to ensure it will be a very reliable program.