Database schemas and dependencies, Database Management System

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,)

Posted Date: 3/26/2013 1:35:17 AM | Location : United States







Related Discussions:- Database schemas and dependencies, Assignment Help, Ask Question on Database schemas and dependencies, Get Answer, Expert's Help, Database schemas and dependencies Discussions

Write discussion on Database schemas and dependencies
Your posts are moderated
Related Questions
State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

discuss the array implementation of a stack.

What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

Have database built but having problems with some questions that go with the database

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas


Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t