Explain the need for the bcnf normal form, Database Management System

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on a number of patients each day, but an operating theatre can be used only once on any given date. The type of the operation (OPTYPE) performed by a surgeon on a patient and its outcome (OPRESULT) and the date of the operation (OPDATE) is recorded. Each operation is performed by a single surgeon on a single patient.

Given the relation:

OPERATIONS(DOCID, PATID, ROOMNO, OPDATE, OPTYPE, OPRESULT)

i) identify the functional dependencies for the relation OPERATIONS

ii) give relation key(s)

iii) give the highest normal form of relation OPERATIONS

Briefly explain the need for the BCNF Normal form and give an example of a relation that is in 3NF, but not in BCNF. Avoid using the example(s) given in lectures.

For relation R(Q, R, S, T); and functional dependencies F = {Q -> S, S -> Q, R -> T}, find the relation key(s) and give the highest normal form for R.

Posted Date: 2/22/2013 1:02:40 AM | Location : United States







Related Discussions:- Explain the need for the bcnf normal form, Assignment Help, Ask Question on Explain the need for the bcnf normal form, Get Answer, Expert's Help, Explain the need for the bcnf normal form Discussions

Write discussion on Explain the need for the bcnf normal form
Your posts are moderated
Related Questions
Create 1 experiment to demonstrate an aspect of query optimisation by using access-path structures (indexes), decomposition, or denormalisation. Once satisfied with your experiment

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

The users who use easy-to-use menu are called ? The users who use easy to use menu are called as Naïve users.

Information about films holds information about movies, stars and studios. Movies have a title, year of production, length and the film type. Stars have a name and address. Studi

I need a professional to prepare a database to collect and store basic information. The information can be basic info such as contact details etc. One requirement i have is f

Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s

QUESTION (a) Give two advantages of using Linked List as compared to arrays. (b) (i) You are working as programmer at the Orange Mauritius branch. You have been asked to cre

Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap