Final Project Documentation
Computer Engineering
PROG 219D
University of Trinidad and Tobago
COHORT 11 FULL TIME
NETD COMPUTER ENGINEERING
Members:
Jeanne Carr
Xavier Daniel
Shalome Perry
Supervisor: Lisa Wharwood
Due Date: 30th July 2011
Executive Summary
Our project is to develop an online web application for the Le Visage Day Spa. The Le Visage Day Spa provides many services and benefits to its members. It may results in mistakes and the process is very inconvenient. As a result, The Le Visage Day Spa needs an online system in order to carry out their business activities. We develop the online day spa system based on the requirements of users.
The Online Day Spa System requires features in order to carry out the process:
(1) to provide a user friendly online system;
(2) to store service information in database to reduce the human mistakes, increase accuracy and also to enhance the flexibility of information processing;
(3) providing appointments as well as orders;
(4) to design the system that is easy to maintain and upgrade.
Acknowledgements
The special thanks go to my helpful supervisor, Ms. Lisa Wharwood. The supervision and support that she gave truly help the progression and smoothness of the final project. The co-operation is much indeed appreciated.
Apart from the efforts of my colleague members and I (Shalome Perry), the success of this final documentation depends largely on the encouragement and guidelines of my supervisor Ms Lisa Wharwood. We take this opportunity to express our gratitude to the people who have been with us in the successful completion of this project.
I would like to show my greatest appreciation to Mr. Ray Phringee, the manager of Le Visage Day Spa, who permitted us to use his company for the final project. I can’t say thank you enough for his tremendous help.
The guidance and support received from all the team members including Jeanne Carr and Xavier Daniel who contributed and are contributing to this project, was vital for the success of the project.
Table of Contents
Topics Page #
Chapter 1
Introduction
Purpose of Project
Project Description
Objectives
Chapter 2
Company background
Existing background
List of Figures and Tables
Figure 1 Topics Page#
Table 1
The following are the list acronyms and keywords used in this document as follows:
LVDS – Le Visage Day Spa Co. Ltd
DFD (Data Flow Diagram) - is used to describe how the system transforms information.
ERD (Entity Relationship Diagram) - is a data modeling technique that creates a graphical representation of the entities, and the relationships between entities, within an information system.
Sitemap – defines the hierarchal structure which provides an overview of website content.
Project Schedule - consists of a list of a project's terminal elements with intended start and finish dates
User Interface Requirement – is part of the system where the users can see and interact with.
Microsoft Visual Studios - a powerful IDE that ensures quality code throughout the entire application lifecycle, from design to deployment.
Database schema - is described in a formal language supported by the database management system (DBMS).
Functional Requirements - define the functions that are requested by the company
Non Functional Requirements - define the operational requirements that are requested by the company
Mind map - a diagram used to represent ideas, tasks, or other items linked to and arranged around a central idea.
CHAPTER 1
INTRODUCTION
As part of our final year (2011), in the completion of our diploma, we, the students of Cohort 11 NETD option were required to undertake an assignment in which we develop and create a web application and also a relational database for a business of choice and present the requirements. It was where we came together as a group/ team to form JXS Co. Ltd.
In this paper, we explain and mention the existing problem, the project scope, the user requirements and the project schedule. Then, we exhibit our solution including the system analysis and the functions of our online system. Finally we evaluate our work in different aspects, present the area for further improvement and conclude our work.
Purpose of Project
The reason for this project is to develop, test, design and implement a functional database and a dynamic web application for The Le Visage Day Spa using Microsoft Visual Studios. Within this database, it will consist of personal information on the employees and clients.
This web application will allow the users to browse for all their necessary information about the services and costs provided, as well as eventually having the ability to schedule appointments on-line. This project will greatly improve on the potential of the company increasing its clientele and its business size by generating a wider market. The software we are using will allow a user to see the schedule and make an appointment in their comfort.
Description of Project
Business IT Project - PROJ 219D
Our final project is a six (6) credit course, which involves the use of all the skills that we have learned throughout the ICT Diploma: - computer engineering programme. It is designed to test our personal skills to identify a course of action with an acceptable solution to a problem within constraints, specification and project schedules. This final project is to develop, design and implement a functional database and web application using visual studios and also to merge the both of them. This will then be displayed in front of ICT panel with a fully functional web application with the database.
Objectives
The main objective of this project is to provide a demonstration of the requirements needed to design, develop and implement a functional database and dynamic web application for Le Visage Company. This project documents a description of the user requirements which consists of functional and non-functional and the user interface requirements proposed by the manager. It also describes the constraints encountered, project benefits as well as with the other factors that were necessary in providing a complete design of the system.
CHAPTER 2
Company Background
The Le Visage (Home of the Jet Clear Facial) is a small established day Spa owned by Mr. Ray Phringee which is located at 15A Rust Street, St Clair in Port of Spain. It offers a wide variety of mind and body services and products. This spa business is devoted to providing various services including Facials, Manicure, Body Massage, Body Treatment and Pedicure to its clients. The day spa aspect of this business will provide females with any type of day spa services. This is all done in a relaxing serene setting. LVDS always strive continuously to look for improvement in their business as well as their website so that its members can benefit from its services and obtain the best value for money.
The ethics behind this company’s achievements is the warm and welcoming friendly, professional staff which strives to offer you nothing but the best customer service, products and treatment available at competitive prices. Le Visage has many other competitors, such as Sasha Cosmetics, Cher Mere as well as La Vita Day Spa.
Existing Problem
Le Visage Day Spa Company is in the process of moving towards higher recognition. Additionally, clients have been pleading for another way in making appointments, viewing service information accompanied by pricelist that is provided by the company.
Mr. Ray Phringee also claimed that his company’s website was trivial and would like to see his website as a professional one, which attracts his clients.
Therefore Mr. Ray Phringee has decided that the fastest, most reliable and convenient means of doing so would be through suitable website to meet the specifications that he desires.
Scope of Project
A project scope involves the breakdown of the main project deliverables with the features of SMART (specific, measurable, attainable, realistic and timely).
The Le Visage Day Spa requires an online system with a database keeping the appointments from the users that are registered into the system.
The Le Visage Day Spa online system must include these features:
Only accessible by registered members
User friendly for computer illegitimate and
Easy to maintain by web administrators
Mind Map for Le Visage Day Spa website
A mind map is a diagram used to represent ideas, tasks, or other items linked to and arranged around a central idea. Mind maps are used to generate, visualize, structure, and classify ideas, and as an aid to organizing information, solving problems, and making decisions.
CHAPTER 3
Potential Users of our System
LVDS – allows LVDS members to view their appointment schedule. In order to supply a direct appointment way on web, this feature provide a convenience practice which can avoid telephone line busy, or time consuming which cause by forming line at the day spa outlet. LVDS will show out the appointment schedule of the member. The LVDS members only need to select the appropriate treatment or services they desire. The client will clearly know their occupied time and date.
There are two groups of users in our system; they are the registered members and web administrators. They have different authorities in our system which is shown as follows:
Members – This type of user will be able to visit our site and navigate to different pages to get information. They are registered members. They can view detailed service information and their appointments. Besides, they are able to create, view, modify and cancel their Day Spa orders and or appointments.
Administrators –This type of user will be responsible to manage whole site & also content that will be published in site. They are authorized Day Spa staffs to control the system. They are assigned with the authority to maintain the information of appointments, orders, members. In addition, administrators can execute summary reports and be responsible to maintain database that is stored.
CHAPTER 4
SYSTEM ANALYSIS
In this section, we present the user interface requirements, requirement specification, software and hardware requirements for both system developers and system users, process model and data model.
Requirement Specification
In the following, we describe the functional requirements and non-functional requirements of our system.
Functional Requirements
Functional requirements define the functions that are requested by the company. Different functions are needed by different system users. For the registered Le Visage Day Spa members;
Once a member log in the system, it can identify the type of the member. Besides the administrator have different levels of authority to maintain the system information.
Functional Requirements for Members
o Login
o Make appointments
o Receive invoice
o View detailed services
o Search information of product and or services
o Logout
Functional Requirements for Administrators
o Login
o Update information of services
o Update information of member
o Update invoice
o Print Invoice
o Print Report
Non-functional Requirements
Non-functional requirements define the operational requirements that are requested by the company.
Operational Requirements
o The system can be viewed by Microsoft Internet Explorer.
o The system can be executed on Microsoft Visual Studios 2010 using ASP.net
o We can only use MySQL server as DBMS to develop the database.
Software and Hardware Requirements
In the following, we describe the software and hardware requirements for system developers and system users.
Software and Hardware Requirements for Developers
During our system development, we have to design a dynamic website interface, create website functions and a database system, so there is a set of software and hardware requirements that is mentioned below.
Software Requirements
Server Side:
- Microsoft Visual Studio 2010 (ASP.net)
- Internet Explorer
- MySql server
- Microsoft Windows 7 Home Premium
Client Side:
Any Web Browser on any Windows Operating System
Hardware:
-Name of CPU= Intel ® Pentium ®
-Amount of RAM= 4.00GHz
-Hard disk Space = 283 GB
User Interface Requirements
The user interface is the key to application usability. The application includes content presentation, application navigation, and user assistance. The goal of a user interface design is to make the user's interaction as simple and efficient as possible, in terms of accomplishing user goals.
UI is defined as the actions performed by humans using an interactive device, like a keyboard, mouse to provide information to or request processing from a computer. It also includes computer responses (including display panels) as a result of information/requests from the user.
Contents:-
Background- Desktop background
Scroll Bar
Form entry-
The following requirements shall be followed for the screens that use defined forms to help the user enter data for this system.
• The form shall open with the cursor.
•
Security Requirements (Still Drafting)
CHAPTER 5
Process Model
In this section, we briefly describe the two Data Flow Diagrams (DFD) in our system, and they are Data Flow Diagram (Context Level) and Data Flow Diagram (Level 1) as well as the Data Dictionary.
Data Flow Diagram (Context Level)
In the Data Flow Diagram (Context Level) shown in Fig. 2, it has one external user and one process. The one external user is Member and the process is the online system for Le Visage Day Spa. We combine some data flows together grouped by similar characteristic function in the context level.
Data Flow Diagram (Level 1)
In the Data Flow Diagram (Level 1) shown in Fig. 3, it shows our system has five major functions, four data storages and a number of data flows. It includes all the functions for Day Spa members and administrators. The five major functions are described briefly as follows:
Process 1: Customer Registers – New members will register to grant appropriate access to the system content.
Process 2: Login the System - Both members and administrators have to use their user IDs and
passwords to login the system. Once they enter their IDs and passwords, the system will verify the data by searching the relevant data source for comparison.
Process 3: Select Services – Member selects services that they desire for their appointment.
Process 4: Make Appointment - When a member makes their desired appointment on the
Le Visage Online Day Spa system, the system will provides their appointment information such as their type of treatment, the date as well as the customer details.
Process 5: Get Date – LVDS can view their appointment date.
Data Model (using Chen’s Notation)
There are five entities in our final Entity Relationship Diagram (ERD) as shown in Fig. 4. The brief descriptions of all the entities are shown as follows:
• Member – Member
• Services – list of services and prices
• Appointment – detailed information of the customer’s appointment information.
• Employee – list of employees
• Account – review customer’s information as well as their appointment dates
PROJECT BENEFITS
This project will benefit The Le Visage Day Spa in the following ways:
To demonstrate a fully functioning web application: This would mean that the web application displays all the company information.
Attract more customers:-
The Le Visage day Spa currently has 400 clients and could only accommodate several clients. This will help Le Visage Day Spa in reaching their target amount of clients.
Overall to increase marketing:-
This project would increase the company’s marketing by assistance to get the company in global perspective. Also help to build proper partnerships with other companies.
This project will benefit JXS Co. Ltd in the following:-
With Experience:
JXS Co. Ltd wants to gain the experience of developing this type of web application. In addition to display the quality level of work JXS Co. Ltd team can produce.
Chapter 6
SITEMAP (Still Drafting)
A sitemap provides an overview of website content in a manner similar to the contents page of a book.
It is a hierarchical diagram of the pages on a Web site, which starts with the home page at the top as shown in Fig.
SYSTEM IMPLMENTATON (Still Drafting)
In this section, we present our online day spa system in terms of the functions for members, the functions for administrators and the system printouts. Besides, user guides for members and administrators are also prepared for the company.
Functions for Members
Members use their member IDs and passwords to login our system. Once a member logs into the system, it identifies the type of the member.
After that, a main menu displays all the functions for members in our system as shown in Fig. 5.
This is where the image of the web application is shown, and explain each one…
CHAPTER 7
Project Schedule
We have designed the project in such a way that approval is shown; this project should be completed on or before the 24th July 2011. The Gantt chart as well as the table below illustrates the detailed timelines and tasks of all the project schedules.
ACTIVITY ID | ACTIVITY NAME | DURATION | START DATE | PROGRESS REPORT | END DATE |
001 | Project Proposal |
3 days | 9th May |
| 12th May |
002 | Request Letter | 1 day | 12th May |
| 13th May |
003 | Gantt Chart | 2 days | 13th May |
| 15th May |
004 | User Interface Requirements | 2 days | 15th May |
| 17th May |
005 | Create site map of web app. | 2 days | 17th May |
| 19th May |
006 | Create ERD + DFD + Use Case | 5 days | 19th May |
| 24th May |
007 | Security requirements | 3 days | 24th May |
| 27th May |
008 | Create Database | 20 days | 27th May |
| 15th June |
009 | Create User Interface | 7 days | 15th June |
| 22th June |
010 | Project Review/ Correction | 2 days | 22th June |
| 24th July |
CHAPTER 8
CONSTRAINTS
This chapter will highlight the constraints presented by the project team.
The project team has identified the following sources of project risk:
Not sufficient lab time was provided,
Illness of a team member,
The project team encountered technical difficulty in developing the database,
The project team encountered technical difficulty in developing the web page,
Critical tasks not being completed on target,
There was technical failure of development equipment.
The following constraints are expanded below:
Risk: Not enough lab time.
Project team is left without resources and delay in productivity. Precautions:- Sourcing of development equipment outside of the lab such as giving us the time to use the lab would help in limiting the consequences of this risk.
Risk: Critical tasks not being completed on target
The project is not being completed within the allotted time frame. Precautions:- Providing status reports will provide early detection. Resources such as a schedule can be reassigned to ensure that the project is put back on track.
Risks: Technical difficulty encountered in developing the database and web page.
There was a delayed completion of tasks. Precautions:- The project leader is must be notified so that additional expertise can be acquired. All team members must be ready to help solve a technical problem even if they are not assigned to that specific task.
Risk: Illness of a team member
Delayed completion of tasks Precautions:- Resources can be reassigned, or the task(s) can be split among more resources to ensure that the project is on track.
Risk: Technical failure of development equipment
Precautions: The project is archived after each task onto disks, sending through email. In the event of computer failure or difficulties, the computers in John D campus, UTT, the computer lab will be used for further development.
Team Member Responsibilities
| Name: Jeanne Carr Student ID:
Responsibilities: 1. create the diagrams such as the ERD, Use case, DFD’s 2. create the database for the web application |
Name: Xavier Daniel
Student ID:
Responsibilities: 1. Design the web applications as well as the walkthrough review form 2. Develop the mind map for the company 3. Develop site map |
|
|
Name: Shalome Perry (Project Leader)
Student ID:
Responsibilities: 1. Ensure the members responsibilities towards the project 2. Document executive summary
|
Problems Faced in our Team
At the initial stage of this project, some members were quite passive in team work, so the completions of tasks were delayed. We solved this problem by increasing the frequency of project meetings and redistributing the tasks and work load from time to time if necessary.
Another problem that existed was only one member in our team had experience in designing the web application.
Team Strengths
Throughout the discussions of project documentation, we gain more experience in communication skills in a team. We also learn how to endure other member’s weaknesses. Within the project, we learn how to distribute work among members through proper communication.
In this project, we practice our presentation (the web application) for several times, which enhances our presentation skills. It increases our courage during presentation and enhances our answering skills to the questions asked by the audience.
Conclusion
We have completed our project work based on using software engineering and system analysis and design approach. Work that we have done with preplanning scheduling related with time constrains and result oriented progress in project development.
This project is designed to meet the requirements of Online Day Spa Company. It has been developed in Microsoft Visual Studios, with the use of asp.net
For designing the system we have used simple data flow diagrams, entity relationship diagrams, use case.
Overall the project teaches us the skills like:
The use of system analysis and design techniques like data flow diagram in designing the system, as well as understanding the database handling and query processing as well as developing, designing and testing a web application.
Appendix
1. Request Letter (In Blog) Checked
2. Interview Questions (In Blog) Checked
PROJECT PROPOSAL
Title:
The spa that we chose for our final project was Le Visage Day Spa Co. Ltd, The Home of Jet Clear Facials. This day spa offers premium services to its customers.
The main purpose to this project is developing an online system with the use of Microsoft Visual Studios to support the day to day activities of Le Visage Day Spa Company. Within this project, we will accomplish web programming skills.
Project Objectives:
With this project we will accomplish the documentation by the following mentioned below:
To develop and design that best supports Le Visage Day Spa.
To carry out all the necessary research required to successfully complete the project.
To analyse the user requirements (functional and non-functional) as well as the user interface requirements needed to implement a functional database and dynamic web application.
To demonstrate our web programming skills
Creating and populating the database.
To connect the database to the dynamic web application.
3. Gantt Chart (Done By Jeanne)
4. Database Schema
A database schema is described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables. Schemas are generally stored in a data dictionary.
1NF
Appointment: - (member_id (fk), app_ID(pk), app_date, app_time)
Members: - (member_id(pk), member_name, member_address, member_contact, member_DOB)
Employees: - (emp_id(pk), emp_name, emp_address, emp_cell)
Services: - (ser_id(pk), service_name)
Account:- (acct_id, member_id(fk), app_date)
2NF
Appointment: - (member_id (fk), app_ID(pk), app_date, app_time)
Members: - (member_id(pk), member_name, member_address, member_cell, member_home, member_DOB)
Employees: - (emp_id(pk), emp_name, emp_address, emp_cell)
Services: - (ser_id(pk), service_name,duration)
Account: - (acct_id, member_id(fk), app_date)
3NF
Appointment: - (app_ID(pk), app_date_time, service_id(fk), member_id(fk))
Members: - (member_id(pk), firstName, lastName, member_address, gender, member_contact, member_DOB)
Employees: - (emp_id(pk), emp_name, emp_address, emp_cell)
Services: - (ser_id(pk), service_name, service_price, emp_ID(fk),duration)
Account: - (acct_id, member_id(fk), app_date, time, service_name)
Reference List
An Efficient Online Shopping System. [online] Available at:
http://www.ietymec.org/papers/N12.pdf [Accessed 5th May 2011].
Sitemap
Motive Glossary. [online] Available at:
http://www.motive.co.nz/glossary/sitemap.php [Accessed 24th May 2011]
The Free Online Dictionary, 2011. Sitemap. [online] Available at:
http://encyclopedia2.thefreedictionary.com [Accessed 24th May 2011]
Lecturer Notes
Wharwood, L. (2011) Business Programming, PROG211D ITCT 209D. [Lecture notes] Entity Relationship Diagram, Data Flow Diagram. John S. Donaldson Technical Institute (JSDTI), Classroom, Room 107
Interview (the group (JXS Co. Ltd) have conducted)
Phringee, R. (2011). Information about his company’s background. [Interview] Le Visage Day Spa, St Clair, Port of Spain with J Carr, 17th May, 2011
Mindmap
Wikipedia The Free Encyclopedia, 2011. Mind Map. [online] Available at:
http://en.wikipedia.org/wiki/Mind_map [Accessed 3rd June 2011]
