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
Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.

Server Control It is usual to control access to the data via the front end application, for example by displaying data as ‘read only'. This part of the assignment illustrates ho

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •

What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace

What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical

#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords

Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program