Database, Database Management System

Assignment Help:

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.


Related Discussions:- Database

What are the several forms of identity, What are the several forms of ident...

What are the several forms of identity? a) Value b) Name c) Built-in

Mr.dattu, Define a job scheduling strategy that will meet business requirem...

Define 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 pictori

Types of indexes, Types Of Indexes One of the words used during the fil...

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

Create a entity-relationship diagrams, This project requires you to create ...

This project requires you to create a database design.  Your design will be documented in a set of Entity-Relationship diagrams.  Draw a set of Entity-Relationship diagrams to mode

01a_ImportCasting.xlsx, 01a_Broadway_LastFirst_yyyy-mm-dd Capstone Exercise...

01a_Broadway_LastFirst_yyyy-mm-dd Capstone Exercises You work as a production assistant in the office of the Green Man Theatre. One of your duties is to maintain the company datab

A Biological Database on Viruses, How to create a biological database based...

How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,

Distributed control and data sharing , Distributed Control and Data sharing...

Distributed Control and Data sharing: The geographical distribution of an organization can be showed in the distribution of the data; if a number of different sites are linked to e

Benefits and drawbacks of heap files, Benefits of heap files 1.   This i...

Benefits of heap files 1.   This is a easy file Organisation method. 2.   Insertion is somehow capable. 3.   Good for bulk-loading data into a table. 4.   Best if file

What functions does a data dictionary perform, What functions does a data d...

What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd