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
Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

explain exhausitively the problems associated with er diagrams with ellustrations

Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which

how to prepare a data dictionary for online examination system for certified courses?

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

Logical Operators Rules of Precedence: Order evaluated Operator 1 All comparison operators 2

What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

A student entity type has the following attributes,name..

Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to

Need 2 projects completed in 3NF format.