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 Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

What are the advantages of creating a table from existing table?

What is a hashing function?  What are the properties of a good hashing function?  Describe the folding technique for hashing functions.      Ans:  Hashing function is a method

Data Warehousing & Mining 1. What is the concept of knowledge discovery in database? 2. Describe the following types of Multidimensional Data Models. • Stars, Snowflakes and

Explain Record Based Logical Models? Record-Based logical Models: Also define data at the conceptual and view levels. Unlike object-oriented models, are used to state overall

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

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

Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among

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

need to get answer for questions 3&4 on this page in part 1