Functional dependencies, Database Management System

1. Staff (staffID --> availabilityID)

2. Services (servicesID --> itemBasedID --> timedBasedID)

3. TimedBased (timedbasedID--> priceid)

4. Clients (clientId, serviceId--> bookingId)

The bookingID is fully functionally dependant on the clientId and serviced because the clientID says which client the booking is for and the serviceID is what service the client has booked that time.

5. Clients (rclient --> clients )

The clients are partially dependant on rclient as it needs some attributes to find the client (using a query) but not all the attributes.

6. Bookings (bookingID --> staffID --> clientID --> venueID --> serviceID --> paymentID);

7. Parlour (parlourID --> staffID);

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







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

Write discussion on Functional dependencies
Your posts are moderated
Related Questions

What are the function of DBA?

Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

Explain the Weak Entity Set An Entity set which does not have sufficient attribute to make a primay key is known as weak entity set. For instance, dependents of an employee in

What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer. There are th

What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

What are the DBMS languages? Explain.  Ans: a) Data Definition Languages (DDL): It is employed to specify database schema for example CREATE DROP statements etc.     b)  Dat

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

Define a property that is not a property of transactions? Ans: Concurrency is not a property of transactions

Explain what is DDL? DDL - Data Definition Language: statements used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALT