Database, Database Management System

A database has been designed for this beauty parlour in order for the staff to manage specific things such as bookings made by clients, payments, staff availability, level of experience, services provided, and the venues in which these services are provided.

All staff have their details included in the database including their first name, last name, phone, mobile, email, availability and experience. The ER diagram demonstrates a staff members availability by determining what days of the week they work. Also, the experience is determined by levels from 3 to 1 (3 the highest, 1 the lowest) and this is demonstrated in the ER diagram.

Regular clients have their details kept in the system which include their first name, last name, phone, mobile and email. This allows for easy bookings and payments as their details are already saved in the system. Non regular clients may also make a booking for a treatment depending on availability.

Services provided by the staff are divided into item based and time based beauty care/treatments. Time based treatments are charged per half hour or hour which is then multiplied by the staffs' level of expertise in the service. On the other hand, item based services are charged at a constant fixed price.

Bookings can be made at various beauty parlour venues in which the therapists work, this will make it efficient for the staff and clients as they can be serviced in areas which are suitable for them.

Payments can be processed by cash or credit/debit card only and this is depicted in the ER diagram.

The ER diagram also shows how the prices for all services are all in the database and can be matched to each booking/appointment. The ER diagram can also show all the available therapist's, and all appointments made on a day because all the relevant information needed is in the database.

All of the above information is demonstrated in the database, as well as the ER diagram in further detail and this makes it easy to demonstrate how the database is to be set out in order to support the management of the beauty parlour.

Posted Date: 3/26/2013 1:34:15 AM | Location : United States







Related Discussions:- Database, Assignment Help, Ask Question on Database, Get Answer, Expert's Help, Database Discussions

Write discussion on Database
Your posts are moderated
Related Questions
Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

#quesDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pi

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

What are three components of the schema architecture proposed by ANSI/SPARC? The three component schema architecture proposed by ANSI/SPARC is as given below: External sche

Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

Define Catalog and meta data ? A catalog is a compilation of records elaborating the contents of a particular collection or group of collections. Metadata (Meta data, or someti

What are the key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.