Functional dependencies, Database Management System

Assignment Help:

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


Related Discussions:- Functional dependencies

What are object interaction diagrams, What are object interaction diagrams?...

What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

Data base design, how to design a bakery business in data base

how to design a bakery business in data base

Entity integrity, Before defines the second type of integrity constraint, v...

Before defines the second type of integrity constraint, viz., Entity Integrity, we should be well-known with the concept of NULL. Mostly, NULL is intended as a basis for dealing

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

What is predictive modelling, Question : (a) Data mining is one of the...

Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte

Benefits of views-data control, Benefits: It limits data access. ...

Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.

Relationship sets, A relationship set is a set of relationships of the simi...

A relationship set is a set of relationships of the similar type. For example, let consider the relationship among two entities sets course and student. Collection of all the in

What is an operand, What is an Operand? The data on which the operation...

What is an Operand? The data on which the operation is to be performed is known as an Operand

Draw an e_r model in oracle, Draw an E_R Model for the following: An or...

Draw an E_R Model for the following: An organization uses number of items of a equipment to generates goods. Each item is at one LOCATION, of one TYPE and has a DETAILED_DISCRI

Define upgrade and downgrade, Define upgrade and downgrade? It gives a ...

Define upgrade and downgrade? It gives a mechanism for conversion from shared lock to exclusive lock is called as upgrade. It gives a mechanism for conversion from exclusive

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd