INTRODUCTION
After viewing and being told about the Le Visage website we decided on creating and improving it. We plan on doing this by generating a functional database and enhance the web application. This web application would be designed to be used by both technical and non-technical people. It is essential in helping of the web site itself and catching the viewer’s eyes with interest.
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 reschedule 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.
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 staffs which strive 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.
The present web site is quite confusing. The background is just too much and very over powering. When viewing, people get side tracked and even lose interest. So we plan on improving and preventing these things from happening.
GENERAL REQUIREMENTS
Simple and easy to use user interface
No development cost
Utilise existing information
* Document the company background through the interview that we had with the owner.
* Layout of website with the use of Microsoft Visual Studios.
SYSTEM SPECIFICATION
After discussion with the group members the following specifications were drawn up:
* System will consist of database of recordings.
* System will store the following about each person:
First name, Last name, Gender, Date of birth, Date joined, Address, Home number, Cell Number
* Administration interface to add/remove/modify records.
* When wanted the administrator can view all appointments on any day he/she wants to view.
* Intelligent system to prevent the same person or record from being entered repeatedly
* A section for requesting of records
Types of Users in the system:
Administrator (Le Visage staff who administer the system)
Admin access (login) & Administer user accounts
Customers (Le Visage customers, and new customers)
Browse record database, contact any administrator, make an appointment, navigate through website.
PROGRESS
RESEARCH
Research was conducted of existing system
From the system specification several areas required research:
* Database systems
* Web application languages
* About the business background
* Description of what each section contains.
* Full results of these can be found in the final report
Problems Encountered
The problems that encountered in this project report were not much feedback within the group as well not much output within the project report., At the initial stage of this project, some members were quite passive in team work, so the completions of tasks were delayed as well as lack of communications within the group.
Another problem that existed was only one member in our team had experience in designing the web application, which again caused a delay in developing the web application, as well as the programming language.
Activities Schedules
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.
CONTENTS
Topics Page #
Chapter 1
1.1 Introduction
1.2 Purpose of Project
1.3 Project Description
1.4 Objectives
Chapter 2
2.1 Company background
2.2 Existing background
2.3 Scope of Project
2.4 Mind Map
Chapter 3
3.1 Users of the System
Chapter 4
4.1 System Analysis
4.1.1 Requirement Specification
4.2 Software & Hardware Requirements
4.3 User Interface Requirements
4.4 Security Requirements
Chapter 5
5.1 Process Model
5.1.1 Data Flow Model (Context Level)
5.1.2 Data Flow Model (Level 1)
5.2 Data Model
5.3 Activity Diagram
Chapter 6
6.1 Project Benefits
6.2 Constraints
Chapter 7
7.1 Testing Plan
Conclusion
Appendix
Request Letter
Interview Questions & Answers
Gantt Chart
Database Schema
Sitemap
Web application Screenshots
List of Figures and Tables
Figure 1 Mindmap for Le Visage Company
Figure 2 Diagram illustrates Use Case
Figure 3 Illustration of Data Flow Diagram (Context Level)
Figure 4 Illustration of Data Flow Diagram (Level 1)
Figure 5 Entity Relationship Diagram
Figure 6 Activity diagram for Appointment
Figure 7 Sitemap for company’s website
Figure 8 Illustration of Gantt chart
Figure 9
Table 1 Project Schedule
Table 2 Chart shows team member responsibilities’
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 reschedule 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.
