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
Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log.            Ans:  The system log, which is generally writt

The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.

Explain data independence ? Data independence is the capacity to modify the schema at one stage of a database system without having to change the schema at the further level.

What Is Recovery?  During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state

Problem: ‘Users and Information system specialists need to spend inordinate amounts of time locating and gathering data' (Watson and Hal, 1998) Recent developments in the ar