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

Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if

There are many simple and complex approaches to implement. These reports are based on some views or certain query. The following number of reports can be built. 1. The averag

Q.   Explain  data aggregatio n and discuss different design constraints. Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships amon

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

What are the disadvantages of relational data ? Disadvantages • Performance - If the number of tables among that relationships to be established are large and the tables t

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

Your OS has a set of queues, each of which is protected by a lock. To enqueue or dequeue an item, a thread must hold the lock associated to the queue. You need to implement an a

Describe the benefits of OOD techniques OOD techniques are very useful for development of large and complex systems. It has been noted that large projects that are developed u