CC6052ES MSS Coursework
CC6052ES MSS Coursework
CC6052ES MSS Coursework
Title:
“Integrated System for Lakderana Hotel chain Management” - Requirements Outline and Design
Specification with Software
Weighting: 100%
Interim Report Submission: 13th November 2021
Final Report Submission: 02nd January 2022
Presentation of Assignment
You are required as a team to carry out a spoken presentation (10 minutes - including a
demonstration of your database - and produce a written report to support this.
You should ideally be in a group of THREE or FOUR students. Discuss first with your tutor if you
wish to form a group of a different size.
******************************************************************************************************************
The team report should be combined together with the individual reports and submitted to the
ESOFT ICMS on or before the given deadline.
The team report should be combined together with the individual reports and handed (Soft-copy) to
the workshop tutor at the end of your group presentation.
The names and student London Met ID numbers of all members of the team should be printed on the
front (title) page of the report. Each member should sign against his/her details to confirm that they
are correct.
Each page of the team part of the report should be initialed by every team member as 'Checked and
agreed'
Every page of the individual part of the report should be headed with the author’s name/id.
The softcopy of the documentation should be submitted on or before the given deadline according to
the given instructions by the course administration.
DATABASE APPLICATION
Full documentation –softcopy of the database application should be provided – tables, SQL scripts,
printed reports, screenshots, etc.
Course Work Tasks and Report Structure
See also the “Integrated System for Lakderana Hotel chain Management” Case Study
1. Present a draft version of your report –interim report together with a plan for your spoken
presentation. 20%
2. During Week 11 make a spoken presentation and hand-in the final version of your team report to
your workshop tutor.
Requirements outline
1. Organization chart
(Suggested length: up to 3 pages, 1 page diagram and two page description)
Provide a clear diagram indicating the details of each member of the staff, including the staff id,
name, job title and to whom they report. There should be supporting text describing key
features of the organization chart, including any changes/corrections required to the data
provided. You can use some external for the staff members with assumptions if necessary.
Identify a number of important management decisions that could be informed by information from
Integrated System for Lakderana Hotel chain Management. (You should identify Two decisions for
each member of your group).
In this section, you must identify which group member is responsible for each choice of management
decision your decision support system will support, and offer brief justification for this selection.
5. Conclusion
Provide a coherent critique of the development process you have undertaken (what you have done
well, what you could have done better, etc.) and of the application you have developed (what is good
about it, what needs improving, etc.).
1. Create Database tables in accordance with your ERD and populate these with the firm’s
data.
******************INDIVIDUAL**************************************************************************
2. Each group member should produce SQL code to carry out their chosen queries
**********************************************************************************************************
3. Produce a test plan for the full application (i.e. all queries) and a test log indicating the actual
results for the completed version. This is should be complemented by screen shots of the relevant
code, query and results. If there are any errors these should be commented.
1. Individual Contributions (up to 1 page per team member and signatures of whole team) (1
marks) Provide a brief, clear outline of what each team member contributed to the project.
2. Create commercial level application module for any department with proper layered and
modularized based on the designs made in the group report
3. Create test plan above application for cover all workflows
4. Identify the important matrixes for define objective for above department.
5. Define acceptable KPI’s and Benchmarks to satisfy above objectives.