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
When It is better to use files than a DBMS? It is better to use files than a DBMS when Multiple users wish to access the data.

List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS Data Independence - Data independence is the capacity t

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

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

Define Specialisation and generalization in brief? Specialisation / generalization: Generalization or Specialization represents the is a relationship set, an necessary element

Benefits of Hashed file Organisation 1.      Insertion or search on hash-key is quick. 2.      Best if equality search is required on hash-key. Drawbacks of Hashed file

What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have

Consider the following relational database: STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course#, sem

i need to submit in this topic.