Replenish & Restore

Topics: SQL, Relational model, Database Pages: 24 (5013 words) Published: April 18, 2013
& UWS|
Replenish & Restore Database Design
COMP09049: Project|

Student: B00209572

Replenish and Restore Research3
Requirement conclusions3
Conceptual Entity Diagram4
Database Systems Research6
Logical Entity Diagram7
Database Relational Schema Description8
Table Descriptions10
Data Dictionary12
ASP.NET Data Entry Web Application19
Home – Table List19
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


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 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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Restore Essay
  • Essay about Sybase ASE restore
  • Back and Restore Using Sql Server Essay
  • Did Augustus Restore the Roman Republic Essay
  • Did Augustus Restore the Republic? Essay
  • Backup and Restore Control Panel Essay
  • Confucian Philosophy to Restore Iconic American Beliefs Essay
  • Active Directory – Backup, Restore, and Monitor Essay

Become a StudyMode Member

Sign Up - It's Free