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
Explain algorithm of ER To Relational Mapping ? ER-to-Relational Mapping Algorithm: 1) Step 1: Mapping of regular entity types: For each strong entity type E, form a relatio

What are the Issues when Selecting a Database Issues when Selecting a Database Storage space requirement: A database requires about triple storage space of the actua

A set of possible data values is called? A set of possible data values is called as domain.

Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

PHYSICAL DBMS ARCHITECTURE  The physical architecture defines the software components used to process and enter data, and how these software components are related and interc

Authorisation Authorisation is the culmination of the administrative policies of the organisation.  As the name shows, authorisation is a set of rules that can be used to verif

Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

Explain the Project-Join normal form A relation R is in PJNF along with respect to a set of functional dependencies D if for all join dependencies of the outline *(R 1 , R 2 ,

What is Relational DBMS This is our subject of study. A DBMS is relational if the data is organized into relations, that is, tables. In RDBMS, all data are kept in the well-kno