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
explain exhausitively the problems associated with er diagrams with ellustrations

1 - Serial RS232 comm port comunication 2 - NanoHTTPD serving a few processed pages 3 - System tray application to indicate status and access configuration forms 4 - SQLit

If the insertion violates one or more constraints, then two alternatives are available: Default option: - Insertion can be discarded and the reason of refusal can also be ex

Express types of information available in MySQL? Information as regards the result of queries:  This includes number of records affected by any SELECT or UPDATE or DELETE st

project on dbms

Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

Ask questiwhat is row indicator in database on #Minimum 100 words accepted#

Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie