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 is OLTP (Online Transaction Processing)? In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follo

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

One-way Associations If an association is only traversed in single direction, then it is known as one-way association. It is implemented as a pointer or an attribute which con

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Support by Adding Indexes Multiple indexes can be used to access a data file by multiple access paths. In such a scheme only single copy of the data is consider, only the numbe

What is conceptual model ? A conceptual model is a independent of both hardware and software.

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e

What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each fore