Follow Us :

Database - Normalization for Relational Databases

Avatto > > UGC NET COMPUTER SCIENCE > > PRACTICE QUESTIONS > > Database > > Normalization for Relational Databases

1. A relation empdt1 is defined with attributes
empdt1(empcode, name, street, city, state,Pincode).
For any Pincode, there is only one city and state.
Also, forgiven street, city, and state, there is just one Pincode.
In normalization terms, empdt1 is a relation in

  • Option : B
  • Explanation : empdt1 {empcode, name, street, city, state, pincode)
    Given functional dependency
    pincode -> (city) (state)
    (street) (city) (state) -->pincode
    This is in I NF and 2NF but not in 3NF because it contains transitive dependency.
    Hence the correct answer is (b).
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


2. A table has fields F1, F2, F3, F4, F5 with the following functional dependencies
Fi —> F3,
F2 —> F4
(FI, F2) —> F5
In terms of normalization, this table is in

  • Option : A
  • Explanation : Primary key (candidates key) for this relation is [F1] [F2] because [F1, F2] column contains [F1, F2, F3, F4, F5]
    So, there is, functional dependency F1 -> F3, F2
    It also has partial dependency so it is not in 2nd, 3rd NF.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


3. Amongst the ACID properties of a transaction, the 'Durability' property requires. that the changes made to the database by a successful transaction persist

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


4. In a schema with attributes A, B, C, D, and E following set of functional dependencies are given
A --> B
A -->C
CD —>E
B --> D
E —> A
Which of the following functional dependencies is implied by the above set.

  • Option : B
  • Explanation : CD—>A {CD —>E;E —> A; E —>C}
    CD —> C
    BC —> CD
    B—>D;
    CD—>E;
    E—>A;
    A—>C
    AC—>BC:
    A—>B:
    A—>C
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


5. Let R(A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold:
AB —> CD,
DE —> P,
C --> E,
P --> C and B —> G.
The relational schema R is

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


  • Normalisation in DBMS Questions can be used by any candidate who is preparing for UGC NET Computer Science
  • This Normalisation  MCQ section will help you test your analytical skills in a tricky method, thereby giving you an edge over other students
  • Any student who wants to prepare for DOEACC A Level, DOEACC B Level, and DOEACC C level can also use these Objective Type Questions Answer.
  • All candidates who have to appear for the Kendriya Vidyalaya Entrance exam can also refer to this Normalisation quiz questions with answers
  • You can also get access to the Normalisation in DBMS MCQ ebook.
  • Normalisation  Questions can be used in the preparation of JRF, CSIR, and various other exams.
  • You can also download pdf for this Normalisation  multiple-choice questions Answers.
  • This Normalisation in ai Multiple Choice Questions Answers section can also be used for the preparation of various competitive exams like UGC NET, GATE, PSU, IES, and many more.
  • Normalisation Objective Type Questions Answer can be used to gain a credit score in various undergraduate and postgraduate courses like BSc, MSc and MCA

Normalisation Questions

Normalisation in DBMS  Multiple choice questions

Normalisation quiz questions with answers

Normalisation exam questions answers

Normalisation MCQ questions Answers

Normalisation in DBMS MCQ

Normalisation MCQ Pdf

Normalisation MCQ for UGC NET CS

Normalisation Multiple Choice Questions For Competitive Exams

Related Quiz.
Normalization for Relational Databases