Entity-relationship diagram, Database Management System

1. Item based services will be charged fixed prices, and time-based will be charged variably depending on time. Such as per hour.
Item-based: Fixed, pedicure, waxing, threading, facials.

Time-based: Massages.

2. A non-regular client who enters the parlour is assigned a random number known as clientID so a booking can be made as well as determining payment, customers per day etc.

3. When a booking is made, appropriate venue is selected depending on the client location. For example a staff member will redirect a client to the closest available venue.

4. Experience is divided into 3 levels. The highest is level 3 and lowest is 1. To determine the price for time based items, we calculate using the equation hourly rate x price x experience. Where experience level 1 equals 1.0, level 2 equals 1.2 and level 3 equals 1.5.

5. A client can have more than one booking and staff can only be assigned one booking at a specific time.

6. Regular customers, once they have created their own profile in the client table, they will be given their own unique number using the clientID. Once a client provides their clientID, their profile would be accessible using a query which provides all the information and all previous transactions and also it will provide efficiency in making future bookings or payments.

7. Payments can only be made using cash or credit card. Payment must be made once services is finished if need be payment can be made beforehand.

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







Related Discussions:- Entity-relationship diagram, Assignment Help, Ask Question on Entity-relationship diagram, Get Answer, Expert's Help, Entity-relationship diagram Discussions

Write discussion on Entity-relationship diagram
Your posts are moderated
Related Questions
Need a sample of a clinic database relationships

There are a number of possible solutions to the open ended brief. One of the simple ones is shown here without the PKs and FKs. It is important to think of how a number of tasks

Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

Client Server Databases- The concept behind the Client/Server systems is simultaneous, cooperative processing. It is an approach that presents a one systems view from a user's vie

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

Explain the Aggregation implies concurrency Concurrency actually is: This in objects can be identified by the way they change state. Present objects can change state independen

Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them.         Ans: Entity:   An entity is a "thing" or "object" in th