Top MCQ quiz questions on Relational database design

Top MCQ quiz questions on Relational database design, Online quiz on relational database design, Try online quiz on DBMS

Multiple Choice Questions on Relational Database Design

• Questions and Answers - Functional Dependency

• Quiz 1
• Quiz 2 
• Quiz 3
• Quiz 4 
• Quiz 5
• Quiz 6

• Find all the correct functional dependencies

• Eliminate all redundant functional dependencies

• Identify the correct FDs

• Find the FDs that satisfy for a relation to be in BCNF

•  

• Questions and Answers - Normal Forms and Normalization

• Quiz 1
• Quiz 2 
• Quiz 3 
• Quiz 4
• Quiz 5  

• Quiz 6 - BCNF and 2NF Decomposition

• Quiz 7 - Normalization and Functional Dependencies  

• Find the inference rule of the given FD

• Find the minimal keys for the given relation

• Find the current normal form 

• Which normal form does the relation satisfy

• Find the candidate keys of a relation

• Find the correct normal form of the sample table given

• Is the BCNF decomposition a dependency preserving?

• Is the decomposition is lossless or not?

• Decompose the given relation into BCNF relations

• Lossless join, dependency preserving, BCNF decomposition

• 
  

********

Go to RDBMS Quizzes Home page

top interview questions on normalization in dbms

top MCQ interview questions on normalization and database design in rdbms

multiple choice questions for university exams in rdbms and functional dependency

gate questions on normal forms

mcq with answers in topics of database management systems