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

References: 1. Dave, P. (2009) SQL Server Journey with SQL Authority. [Online]. Available at:
2. Didiano, D. (2012) Microsoft SQL vs MySQL: How to Choose Between Them. [Online]. Available at:
3. Emasri, R. and Navathe, S.B. (2011) Fundamentals of Database Systems (6th ed). Addison-Wesley: Boston
4. Ketabchi, M.A., Mathur, S., Risch, T. and Chen, J. (1990) Comparitive Analysis of RDBMS and OODBMS: A Case Study. [Online] Available at:
5. Kolahi, S. and Libkin, L. (2006) On Redundancy vs Dependency Preservation in Normalization: An Information-Theoretic Study of 3NF. [Online]. Available at:
6. Lin, C. (2003) Object-Oriented Database Systems: A Survey. [Online] Available at:
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Restore Essay
  • Back and Restore Using Sql Server Essay
  • Active Directory – Backup, Restore, and Monitor Essay
  • Should We Replenish Our Organs? Essay
  • Did Augustus Restore the Republic? Essay
  • Did Augustus Restore the Roman Republic Essay
  • Can Information Systems Restore Profitability to Restoration Hardware? Essay
  • Cause-Related Marketing Pioneers: American Express Restore the Statue of Liberty Essay

Become a StudyMode Member

Sign Up - It's Free