Database Design(Normal Forms)

Last Updated :
Discuss
Comments

Question 1

Which of the following is TRUE?
  • Every relation in 3NF is also in BCNF
  • A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R
  • Every relation in BCNF is also in 3NF
  • No relation can be in both BCNF and 3NF
Discuss it

Question 2

For the relation R(ABCDEFGH) with FD's= {CH->G, A->BC, B->CHF, E->A, F->EG such that F+ is exactly the set of FDs that hold for R.} Consider the FDs given in above question. The relation R is

  • in 1NF, but not in 2NF.

  • in 2NF, but not in 3NF.

  • in 3NF, but not in BCNF.

  • in BCNF

Discuss it

Question 3

Consider a relational table with a single record for each registered student with the following attributes. 

1. Registration_Num: Unique registration number
   of each registered student
2. UID: Unique identity number, unique at the 
   national level for each citizen
3. BankAccount_Num: Unique account number at
   the bank. A student can have multiple accounts
   or join accounts. This attribute stores the 
   primary account number.
4. Name: Name of the student
5. Hostel_Room: Room number of the hostel

Which one of the following option is INCORRECT?

  • BankAccount_Num is candidate key

  • Registration_Num can be a primary key

  • UID is candidate key if all students are from the same country

  • If S is a superkey such that S∩UID is NULL then S∪UID is also a superkey

Discuss it

Question 4

Consider the following relational schema: 

Suppliers(sid:integer, sname:string, city:string, street:string)
Parts(pid:integer, pname:string, color:string)
Catalog(sid:integer, pid:integer, cost:real)

Assume that, in the suppliers relation above, each supplier and each street within a city has a unique name, and (sname, city) forms a candidate key. No other functional dependencies are implied other than those implied by primary and candidate keys. Which one of the following is TRUE about the above schema?

  • The schema is in BCNF

  • The schema is in 3NF but not in BCNF

  • The schema is in 2NF but not in 3NF

  • The schema is not in 2NF

Discuss it

Question 5

In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.
  • Functional Dependencies
  • Data integrity
  • Referential integrity
  • Normal Forms
Discuss it

Question 6

Data which improves the performance and accessibility of the database are called:
  • Indexes
  • User Data
  • Application Metadata
  • Data Dictionary
Discuss it

Question 7

Consider the following table : Faculty (facName, dept, office, rank, dateHired)

facNamedeptofficerankdateHired
RaviArtA101Professor1975
MuraliMathM201Assistant2000
NarayananArtA101Associate1992
LakshmiMathM201Professor1982
MohanCSCC101Professor1980
LakshmiMathM201Professor1982
SreeniMathM203Associate1990
TanujaCSCC101Instructor2001
GaneshCSCC105Associate1995

(Assume that no faculty member within a single department has same name. Each faculty member has only one office identified in

office

). 3NF refers to third normal form and BCNF refers to Boyee-Codd Normal Form Then Faculty is

  • Not in 3NF, in BCNF

  • In 3NF, not in BCNF

  • In 3NF, in BCNF

  • Not in 3NF, not in BCNF

Discuss it

Question 8

match the following datbase terms to their function:

 14

  • (1)

  • (2)

  • (3)

  • (4)

Discuss it

Question 9

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is:
  • Select * from customers where city = ‘%GAR%’;
  • Select * from customers where city = ‘$GAR$’;
  • Select * from customers where city like ‘%GAR%’;
  • Select * from customers where city as ‘%GAR’;
Discuss it

Question 10

Consider the following dependencies and the BOOK table in a relational database design. Determine the normal form of the given relation. 

ISBN → Title
 ISBN → Publisher
 Publisher → Address

  • First Normal Form

  • Second Normal Form

  • Third Normal Form

  • BCNF

Discuss it

There are 89 questions to complete.

Take a part in the ongoing discussion