Replenish & Restore

Only available on StudyMode
  • Download(s) : 137
  • Published : April 18, 2013
Open Document
Text Preview
& UWS|
Replenish & Restore Database Design
|
COMP09049: Project|

Student: B00209572
12/12/2012
|

Contents
Introduction3
Replenish and Restore Research3
Requirement conclusions3
Conceptual Entity Diagram4
Database Systems Research6
Normalisation6
Logical Entity Diagram7
Database Relational Schema Description8
Table Descriptions10
Data Dictionary12
ASP.NET Data Entry Web Application19
Screenshots19
Home – Table List19
Appointment20
AppointmentPurchaseType21
Client22
Doctor23
Practitioner23
Product24
Treatment24
TreatmentAppointment26
TreatmentQuestion26
SQL Statements27
Test 1:27
Test 2:28
Test 3:28
Test 4:29
Test 5:29
Test 6:29
Test 7:30
Test 8:30
Test 9:30
Test 10:30
Test 11:31
Test 12:31
Test 13:31
References32

Introduction

This report specifies the database design and implementation required for Replenish and Restore.

Replenish and Restore is a company offering body and skin treatments, including skin peels, sport massages, Botox, derma filers and other remedial therapies.

A collection of paper based documents were provided as the source for creating a database. The documents consisted of questionnaire and consultation forms, treatment advice and treatment appointment records. The website at http://www.replenishandrestore.co.uk was also used to gather information relevant to designing a database.

The database supports a wide variety of data, primarily intended to be used in an appointment booking system. It holds client specific details, appointment details and product and treatment details. The limitation of the database system is that it does not fully support a payment system e.g. it does not hold client credit card details, but functionality can be added by linking into the existing appointment and product purchase tables.

The physical database was developed using a Microsoft SQL Server 2008 R2, running on Windows 7 64bit. The physical database files ReplenishRestore.mdf and ReplenishRestore_log.ldf have been made available along with this report. The database contains test data inserted into each table used to test functionality.

Replenish and Restore Research

Looking over the paper based documents for Replenish and Restore it was clear that a lot of different information was recorded in the business, group into specific categories.

There were different forms that related to different treatments: Botox, skin peels, microdermabrasion, dermal fillers, Swedish massages etc. The two main types of forms were: consultation forms and treatment appointment records. The consultation forms recorded client details along with a questionnaire specific to a treatment, and usually that a client had given consent to perform the treatment. Consultation forms could combine different treatments, for example, Botox and dermal filler treatments were included on the same form.

Treatment forms recorded details of specific treatments appointments for clients. The treatment appointment forms varied for different types of treatments but they all generally had areas to provide notes and results, along with type of product used. Some forms such as the microdermabrasion form also linked to a type equipment that was used i.e. a vacuum. The form also had an area to record products sold to the client.

The other forms that were available were ones to record prescription information for a treatment i.e. Botox, and to give general information about a treatment. As well as the prescription form giving details of the client it also had details of the doctor and practitioner to sign. The client information on most forms records name and contact details. Some forms asked for the client’s doctor and next of kin information, such as the massage consultation form.

Additional details were provided by Replenish and Restore’s website, mainly related to products and treatments that could be...
tracking img