Entity-relationship diagram, Database Management System

Assignment Help:

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.


Related Discussions:- Entity-relationship diagram

Explain the exec statement in sql, Explain the EXEC statement in SQL  A...

Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

Transactions and concurrency management, Transactions And Concurrency Manag...

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Illustrate the diagram - association as a cache, Association as a cache ...

Association as a cache This association must be updated when any new element is added to it, but testing for overlap using association is more efficient.    Figure:

Define thomas write rule, Define Thomas write rule Thomas' write rule: ...

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue

When is a transaction rolled back, When is a transaction rolled back? A...

When is a transaction rolled back? Any changes that the aborted transaction made to the database must be uncompleted. While the changes caused by an aborted transaction have be

Atomicity-transaction , Atomicity: It describes a transaction to be a one ...

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Using sql create a view rs for the relations r and s, Using SQL create a vi...

Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

Describe the functions and features of foreign key, Describe the functions ...

Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships

Write the motivations led to development of oo-dbms, Write the motivations ...

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Dataware house(job scheduling strategy), Define a job scheduling strategy t...

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

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