ICTPMG501_Assessment_2 docx resulto coursehero - Carlos D

Vista previa del material en texto

ICTPMG501 Manage ICT Projects
Unit Assessment Pack (UAP) – Cover Sheet 
Student and Trainer/Assessor Details
Student ID 0000007380
Student name Ashley Lacson
Contact number
Email address lacson.ashley1@gmail.com
Trainer/Assessor name Bhuwan KC
Course and Unit Details 
Course code ICT50118
Course name Diploma of Information Technology Networking
Unit code ICTPMG501
Unit name Manage ICT Projects
Assessment Submission Method 
☐ By hand to trainer/assessor ☐ By email to
trainer/assessor
 Online submission via
Learning Management System (LMS)
☐ By Australia Post to RTO ☐ Any other method
_________________________________________________
 (Please mention here)
Student Declaration 
● I certify that the work submitted for this assessment pack is my own. I have clearly
referenced any sources used in my submission. I understand that a false declaration is a
form of malpractice; 
● I have kept a copy of this assessment pack and all relevant notes, attachments, and
reference material that I used in the production of the assessment pack;
● For the purposes of assessment, I give the trainer/assessor of this assessment the
permission to: 
● Reproduce this assessment and provide a copy to another member of staff; and 
● Take steps to authenticate the assessment, including communicating a copy of this
assessment to a checking service (which may retain a copy of the assessment on its
database for future plagiarism checking).
Student signature: AshleyLacson 
Date: 07/02/2020
1 | Page
 ICTPMG501 Manage ICT Projects
Assessment 2
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; 
2 | Page
 ICTPMG501 Manage ICT Projects
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. 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 powerpoint presentation. Each group is to give a 5 minutes 
presentation on their plans.
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. 
3 | Page
 ICTPMG501 Manage ICT Projects
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) 
4 | Page
 ICTPMG501 Manage ICT Projects
We assume that you have gathered all relevant information from previous 
assessments. 
Complete all given tasks. 
Task 1
Identify the Scope, Time, and Cost constraints for the Amazing Restaurant project. Develop 
project charter and obtain sign-off. 
Background 
The increase in customers makes it harder for the employees to manage the table booking, 
orders, day-to-day activities and maintaining customers manually. Therefore, Mr. Amazing 
decided to contact the consultation company to set up a database that deals with everyday 
activities of the restaurant. The database presents opportunities such as allowing the 
managementto ensure that the data stored are current, updated and more accurate than 
the manual system. Furthermore, Mr. Amazing can get useful output and information from 
the data in database and produce a variety of useful reports. 
Goals 
● Create a JAVA application for user login, POS system, customer registration and 
employee registration.
● Create database for the customer, menu and employees. 
● Enable Mr Amazing to publish a recipe book in the system. 
Scope 
● Create a GUI for each JAVA application such as the user or employee login, customer 
registration, POS system and employee registration.
● Create database for the customer, menu and employees. 
● Ensure that security is implemented for the database and JAVA application.
● Ensure that the dashboard is accessible to staff and understandable. 
● Database validation is implemented.
● The programming for the JAVA applications is properly written.
● Ensure that the GUI for the system allows the customers and employees to put their 
details accurately and properly.
● Ensure that each data is properly connected to each other.
● Ensure that there is enough storage for the database to accommodate the 
employees, customers and menu information.
● Create a system where the customers can book their seats and ensure that double 
booking is not possible. 
● However, updating the data in the database is not part of the project.
Key Stakeholders 
Client Mr Amazing (owner)
Sponsor Amazing Restaurant 
Project manager Ashley Lacson
Project team members Mr. Danny Poneglyp as the Programmer, Mrs. Anna Crain as the Database 
5 | Page
 ICTPMG501 Manage ICT Projects
Administrator and Mr. Clark Saundes as the System Designer 
Project Milestones 
Tasks Start Date End Date Invoicing dates
Gather data and information about the 
business and also perform requirement 
modelling. 
Oct 15 2019 Oct 21 2019 Oct 18 2019
Translate the business requirements into 
technical specifications. 
Oct 22 2019 Nov 11 2019 Nov 01 2019
Present the project plan to get approval 
from the management prior to 
implementation. Including the plan for the 
restaurant’s database, online interface and 
access point (with login). Also, the design 
interface for administration, staff and 
customers.
Nov 18 2019 Dec 06 2019 Nov 22 2019
Maintain and monitor the restaurant’s 
system.
Dec 09 2019 Dec 15 2019 Dec 14 2019
Project Budget 
Items Costs Quantities Total Cost
SQL Server 2016 $7414 1 $7414
Server $1537 1 $1537
Employee salary
Name Job role Salary 
Ashley Lacson Project Manager $40 per hour
Anna Crain Database Administrator $30 per hour
Clark Saundes System Designer $35 per hour
Danny Poneglyp Programmer $24 per hour
Constraints, Assumptions, Risks and Dependencies 
6 | Page
 ICTPMG501 Manage ICT Projects
Constraints The team’s skills is not the right one for the project 
The resources is not enough to implement the project
Making some changes with the system should be done in the early 
stages of the project 
There’s not enough time for the project 
The employees of Amazing restaurant is reluctant with the new changes
Assumptions The resources available is the correct item to finish the project
The allocated time is enough to finish the project 
The team members encounters minor risks throughout the project’s 
phase
The system and hardware is easy to operate 
Risks and 
Dependencies
The technical specifications must be defined as specific as possible in 
order to create the system
The management approval is important before proceeding with the 
project 
Approval Signatures 
 
 
 
Mr. Amazing Amazing Restaurant Ashley Lacson 
Project Client Project Sponsor Project Manager 
Task 2.
Feasibility Study 
Technical
The technology available in the market makes the project feasible and it makes it 
possible to upgrade the database and the ordering system. Furthermore, the software 
needed can be easily acquired in the market as well.
Operational 
The employees who use the system will receive proper training about the new system 
and the new hardwares implemented within the project. Furthermore, the customers 
will be notified about the changes in the restaurant and how they can use it to suit 
their needs. 
Economical
The money is worth it because if the upgrade is successful then the services provided 
will improve the restaurant’s system and making it more efficient. 
The Project’s budget is $20,000
7 | Page
AshleyLacson
 ICTPMG501 Manage ICT Projects
Items Costs Quantities Total Cost
SQL Server 2016 $7414 1 $7414
Server $1537 1 $1537
Employee salary
Name Job role Salary 
Ashley Lacson Project Manager $40 per hour
Anna Crain Database Administrator $30 per hour
Clark Saundes System Designer $35 per hour
Danny Poneglyp Programmer $24 per hour
Schedule 
- The project duration given by the restaurant is 2 months. 
Tasks Start Date End Date Invoicing dates
Gather data and information about the 
business and also perform requirement 
modelling. 
Oct 15 2019 Oct 21 2019 Oct 18 2019
Translate the business requirements into 
technical specifications. 
Oct 22 2019 Nov 11 2019 Nov 01 2019
Present the project plan to get approval 
from the management prior to 
implementation. Including the plan for the 
restaurant’s database, online interface and 
access point (with login). Also, the design 
interface for administration, staff and 
customers.
Nov 18 2019 Dec 06 2019 Nov 22 2019
Maintain and monitor the restaurant’s 
system.
Dec 09 2019 Dec 15 2019 Dec 14 2019
Task 3. 
Prepare short interview questions to ask the director of Amazing restaurant. Ensure 
the interview questions are of high standard. 
1. What kind of system do they want to develop?
2. What are the contents that they want to include in the database and 
application?
3. What policy do they want to implement regarding the database and application
design?
4. How do they want us to handle the data?
8 | Page
 ICTPMG501 Manage ICT Projects
5. When do they want the system to finish?
6. How do they want us to structure the database and the JAVA application?
7. How are the data connected to each other? 
Task 4.
Define System Development Life Cycle (SDLC) in your own words. Describe how 
different phases of SDLC may be applied in your project.
1. The first phase of the SDLC which is analysis happens in the first stages of the 
project wherein the scope, time and budget is identified. 
2. Once the analysis is done and the problems within the system are addressed 
then the team will start planning a solution for the problems. 
3. The proposed system is designed. The plan regarding the physical 
construction, operating systems, programming and security is done. 
4. The new system is developed in this phase. the materials needed to perform 
the plan needs to be obtained and user training is being implemented. 
5. All parts of the system must be tested and if it's necessary, adjustments must 
be made at this stage. 
6. The new system needs to be implemented in this phase. 
7. Maintenance of the system involves upgrades needed to ensure that the 
system is always in its best condition. For example, making sure that the 
system is updated in terms of security to reduce the chances of getting 
hacked. Also, the users need to be kept up-to-date about the latest changes.
Task 5
Project Work Breakdown
Task Start Date Finish date Duration Responsible 
Gather data and information about the 
business and also perform requirement 
modelling. 
15/10/2019 21/10/2019 6 days Ashley Lacson
Translate the business requirements into 
technical specifications. 
22/10/2019 04/11/2019 10 days Clark Saundes
Present the project plan to get approval 
from the management prior to 
implementation. Including the plan for 
the restaurant’s database, online 
interface and access point (with login). 
Also, the design interface for 
administration, staff and customers.
05/11/201920/11/2019 10 days Ashley Lacson
9 | Page
 ICTPMG501 Manage ICT Projects
Implement the plan such as making the 
database, the JAVA application and the 
interface.
21/11/2019 06/12/2019 12 days Anna Clark 
and Danny 
Poneglyp
Maintain and monitor the restaurant’s 
system.
09/12/2019 15/12/2019 5 days Ashley Lacson
Task 6. 
Gantt Chart
Date/
Task
15/
10
18/
10
21/
10
25/
10
28/
10
01/
11
04/
11
08/
11
11/
11
15/
11
18/
11
22/
11
25/
11
29/
11
02/
12
06/
12
09/
12
13/
12
1
2
3 
4
5
No. Task 
1 Gather data and information about the business and also perform requirement modelling. 
2 Translate the business requirements into technical specifications. 
3 Present the project plan to get approval from the management prior to implementation. 
Including the plan for the restaurant’s database, online interface and access point (with login).
Also, the design interface for administration, staff and customers.
4 Implement the plan such as making the database, the JAVA application and the interface.
5 Maintain and monitor the restaurant’s system.
Task 7. 
Create a table that shows the team members, their roles and responsibilities. (See 
appendix C)
Team Members Job Roles Responsibilities 
Ashley Lacson Project 
Manager 
● Planning and Defining Scope
● Activity Planning and Sequencing
● Resource Planning
● Developing a Budget
● Documentation
● Creating Charts and Schedules
10 | Page
 ICTPMG501 Manage ICT Projects
● Risk Analysis
● Monitoring and Reporting Progress
● Team Leadership
● Strategic Influencing
● Working with Vendors
● Controlling Quality
Anna Crain Database 
Administr
ator 
● Design and implement database in 
accordance to end users information 
needs
● Define users and enable data distribution
to the right user, in appropriate format 
and in a timely manner
● Use high-speed transaction recovery 
techniques and backup data
● Determine, enforce and document 
database policies, procedures and 
standards
● Monitor database performance, 
implement changes and apply new 
patches and versions when required
Danny Poneglyp Programm
er 
● Coding and debugging.
● Designing and testing computer 
structures.
● Troubleshooting system errors.
● Writing computer instructions.
● Maintaining operating systems.
● Profiling and analyzing algorithms.
● Implementing build systems.
● Providing tech support.
Clark Saundes System 
Designer
● Work with analysts on the feasibility of a 
conceptual design by taking technical 
specifications prepared by the analyst 
and designing system components to 
meet the set requirements
● Draw up detailed design documentation 
including charts and diagrams that 
indicate the various components involved
● Prepare instructions for programmer 
implementation
● Talk with other team members (analysts 
and programmers) to ensure 
functionality according to systems 
specifications, and develop solutions as 
problems or issues arise
● Design monitoring and performance 
measurement processes.
11 | Page
 ICTPMG501 Manage ICT Projects
Task 8. 
Determine and discuss training and support needs of your client.
Training 
- Teach them how to troubleshoot the 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, and 
- What type of information they need to write in the database. 
Support 
- They can contact helpdesks to ask them to troubleshoot.
- They can also contact us if they need help with the whole system such as the 
DBS or the application itself. 
Task 9. 
When the deliverables change during the project the current budget and deadlines are 
adjusted to reflect the additional work. 
● Amazing restaurant decided to put their system on Cloud with full backup 
services. 
● Identify the cost and additional requirements to accommodate the above 
changes.
Cost
For storage $374.62 per year which is 1.25TB in 
iDrive (just download it)
For website $6800 which includes the setup, design, 
maintenance, training and the creation of
the website. 
- Furthermore, the website will take up to 13-14 weeks to build. 
● Monitor and control project scope changes, risks and issues.
Task 10. 
Risk Assessment 
Ris
k #
Date of 
risk 
Brief description of risk L M H Mitigation action Approval
of 
Date of 
Commen
12 | Page
 ICTPMG501 Manage ICT Projects
occurri
ng
Commen
cement
cement
1 21/10/
2019
The technology needed is 
too expensive and hard to 
use 
Ensure that the technology 
needed is defined during the 
technical specifications 
21/10
/2019
21/10
/2019
2 22/11/
2019
Lack of skills to operate the 
devices
Ensure that the team members 
in the project possess the skills 
needed to complete the project. 
22/11
/2019
22/11
/2019
3 09/12/
2019
Resistant to change Make sure that the employees 
knows the benefits of the new 
system.
09/12
/2019
09/12
/2019
4 21/10/
2019
The software is not 
compatible with the 
technology they currently 
have 
Ensure that the system is 
compatible with the hardware in
the restaurant 
21/10
/2019
21/10
/2019
5 09/12/
2019
The customers may not like 
the change or upgrades in 
the system 
Ensure that the customers are 
aware of the changes happening
in the restaurant. 
09/12
/2019
09/19
/2019
6 22/11/
2019
The project might interfere 
with their work, for example 
if they have a data breach, 
data lost or the system 
suddenly stop working 
because of the project.
Ensure that it doesn't interfere 
with the employees work. Such 
as, working when they are not 
working or change the system 
one by one so then they can still 
use the other system. 
22/11
/2019
22//2
019
Very High Risk Do something to control the risk immediately
High Risk
Moderate Risk Do something about these risks
Low Risk These risks do not need immediate attention
13 | Page
 ICTPMG501 Manage ICT Projects
Task 11. 
CLIENT SIGN OFF FORM
Dear Mr Amazing,
This form is to sign-off completion of your project with us. Kindly complete as soon as possible 
and send it back to us.
Thank you.
Project name: ICTPMG501 Assessment 2 Project manager: Ashley Lacson
Start date: Oct 15 2019 Completion date: Dec 15 2019
Project duration: 2 months Sponsor: Amazing Restaurant 
Project goal:
 Create a JAVA application for user login, customer login, POS system, customer registration and employee 
registration. Also, a database for the customer, menu and employees. 
Project deliverables:
• Create a GUI for each application.
• Ensure that security is implemented for the database and JAVA application.
• Ensure that the dashboard is accessible to staff and understandable. 
Client’s remark 
By signing this document, I acknowledge that I have 
delivered all the stated deliverables
By signing this document, I acknowledge that I have 
received all the stated deliverables
Project manager name and signature:
 AshleyLacson
Ashley Lacson
Sponsor name and signature:
_______________
Mr. Amazing
Date: Dec 06 2019 Date: Dec 10 2019
We recommend that you sign and send this form within 7 days. However, if by any chance that you miss the time 
period that is set, then we will assume that it is signed by you and no further actions will be needed from you. If you 
have any questions regarding this form or the project, please don’t hesitate to contact us.
14 | Page
	Unit Assessment Pack (UAP) – Cover Sheet
	Case Study:  Amazing Restaurant 
	Specific Requirements:  
	Task 1
	Task 2.
	Task 3.
	Task 4.
	Task 5
	Task 6.
	Task 7.
	Task 8.
	Task 9.
	Task 10.
	Task 11.