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

Database MCQ - Normalization for Relational Databases

6 Consider the following set of functional dependencies on the schema (A, B, C)
A --> BC,
B —> C,
A —> B,
AB —> C
The canonical cover for this set is

Sets of functional dependencies may have redundant dependencies that can be inferred from the other functional dependencies.
A canonical cover of F is a “minimal” set of functional dependencies equivalent to F, having no redundant dependencies or redundant parts of dependencies.
As we can infer all FD's from option A, so A is the right answer.

7 Which normal form is considered adequate for relational database design?

8 A functional dependency of the form x —> y is trivial if

9 If every non-key attribute is a functionally dependent primary key, then the relation will be in

10 If a relation is in BCNF, then it is also in

Your Progress

0%

Start Practising!

You've answered 0 of 23 questions in this topic.

Practice Spotlight

Build momentum in Normalization for Relational Databases

Start with a short question set, review every explanation, and revisit difficult questions before moving ahead.

Day 4 / 10

Global Spotlight

Build Your First Streak

Complete one short Normalization for Relational Databases session today, then return tomorrow. Consistency matters more than a long first session.

Day 7 / 10

Question Spotlight

Question:

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,…

A. In BCNF
B. in 3NF, but not in BCNF
C. In 2NF, but not in 3NF
D. Not in 2NF

Correct answer: D

Click to view the complete question details

Day 4 / 10 Open this question

Community Insight

Based on 17 saved attempts

Most Attempted TopicData Modeling
Most Challenging TopicSQL
Average Accuracy88%

Featured Question

(Based on recent community answers)

Q. #147830% Incorrect

A relation empdt1 is defined with attributes empdt1(empcode, name, street, city, state,Pincode). For any Pincode,…

Try This Question →

This Week's Challenge

Complete 20 questions. Community average: 3.0 this week.

0 / 20 Start Challenge →

Why Practice with Avatto?

High Quality MCQsExam-focused questions with accurate answers

Detailed ExplanationsStep-by-step explanations to enhance learning

Latest Exam PatternBased on updated syllabus and pattern

Performance AnalyticsTrack performance and improve weak areas

100% Free PracticePractice unlimited questions for free

Forgot your password?

I agree with the Terms.