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
Define the Canonical cover Ans: A canonical cover F c for F is a set of dependencies like F logically implies all dependencies in F c , and F c logically entails all dependen

What are the two types of serializability? The two types of serializability is a)      Conflict serializability b)      View serializability

What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

Views in relational algebra:   1. Basic expression contains either  a) A relation in the database. b) A constant relation. 2.  General expressions are madde out of sma

Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

Consider the relations described below: PHYSICIAN (regno, name, telno, city) PATIENT (pname, street, city) VISIT (pname, regno, date_of_visit, fee) Where the regno and pname ide

Explain the difference between using functions along with and without grouping attributes in relational algebra. Give examples. Ans: Group functions are used to group data of

The State of Newyork certifies firefighters throughout state keep track all of them, as well as the state’s of fire departments. Each fire department has unique department number

1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches