Replenish & Restore Database Design
Replenish and Restore Research
Conceptual Entity Diagram
Database Systems Research
Logical Entity Diagram
Database Relational Schema Description
ASP.NET Data Entry Web Application
Home – Table List
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...
References: 1. Dave, P. (2009) SQL Server Journey with SQL Authority. blog.sqlauthority.com [Online]. Available at: http://blog.sqlauthority.com/2009/09/09/sql-server-difference-between-sql-server-express-and-mysql/
2. Didiano, D. (2012) Microsoft SQL vs MySQL: How to Choose Between Them. ultraunboxing.com [Online]. Available at: http://ultraunboxing.com/microsoft-sql-vs-mysql-how-to-choose-between-them/
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. user.it.uu.se [Online] Available at: http://user.it.uu.se/~torer/publ/COMPCON1990.pdf
5. Kolahi, S. and Libkin, L. (2006) On Redundancy vs Dependency Preservation in Normalization: An Information-Theoretic Study of 3NF. www.cs.toronto.edu [Online]. Available at: http://www.cs.toronto.edu/~solmaz/docs/pods176-kolahi.pdf
6. Lin, C. (2003) Object-Oriented Database Systems: A Survey. users.soe.ucsc.edu [Online] Available at: http://users.soe.ucsc.edu/~lcx/courses/cmps277/cmps277-project.pdf
Please join StudyMode to read the full document