Database schemas and dependencies, Database Management System

Assignment Help:

1. Staff(staffID, firstName, lastName, availabilityID, experience, phone, mobile, email);

2. Availability(availabilityID, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Sick Leave);

3. Services (serviceID, itemBaseID, timeBasedID, priceID)

4. ItemBased (itemBasedID,itemName,priceID);

5. TimeBased (timebasedID,timename, priceid,hourlyrate);

6. Clients(clientID, firstName, lastName, phone, mobile, email, bookingID, paymentID);

7. Registered Clients (rClientId, rClientName, rClientAge, rClientAddress, rClientGender, rClientCreditCardNum, rclientCash)

8. Non Registered (nClientId, nClientName, nClientAge, nClientGender, nClientCreditCard, nClientcash)

9. 7.Beauty Salon (salonID,venueID , staffID, bookingID);

10. Parlour (parlourID, parlourName, parlourAddress,);

11. Treatment Venue (venueID, staffID, shopID,parlourID)

12. Bookings (bookingID, serviceName, staffID, clientID, venueID, Time);

13. Payment(paymentType, paymentID,)

Related Discussions:- Database schemas and dependencies

Explain the paths in the association network, Explain the paths in the asso...

Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

Define two-phase locking protocol, Define two-phase locking protocol. A...

Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Participation constraints, The participation Constraints shows whether the ...

The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

OLD HOME POLICIES, Write an sql statement to find what is the percentage of...

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

Describe the responsibilities of the dba and the database, Describe the res...

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

Transaction, .#question. Discuss the problem which may arise during concurr...

.#question. Discuss the problem which may arise during concurrency control and recovery in distributed database which are not encountered in controlized database environment.

What is natural language interfaces, What is Natural Language Interfaces? ...

What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t

Explain the strategy of database planning, Explain the Strategy of Databas...

Explain the Strategy of Database Planning ?

Define the term- actors and data stores, Define the term- Actors and Data...

Define the term- Actors and Data Stores Actors: An actor is the active object which drives data flow graph by producing or consuming values. Actors are attached to inputs a

Primary interface between a visual basic application, Question (a) Visu...

Question (a) Visual Basic is governed by an event processor. Explain the meaning of this phrase. (b) Differentiate between an general procedure and event procedure. (c)

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages