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
Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

Discuss along with examples about several types of attributes present in the ER model? Types of Attributes are: • SIMPLE attributes are attributes which are drawn from the ato

DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor


Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200

Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

Company Database: a-)Here is the ER Model b-)Here is the Relational Model:     IMPORTANT NOTICE FOR SOLUTION TYPE: ***THIS ASSIGNMENT WILL BE SOLVED BY THE

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

what are the states of transaction?