Consider The Relation Given Below And Ind The Maximum Normal #524
Consider the relation given below and ind the maximum normal form applicable to them</p> <pre><code class="language-sql">i. R(A, B) with productions { A --> B } ii. R(A, B) with productions { B --> A } iii. R(A, B) with productions {A —> B, B --> A } iv. R(A, B, C) with productions {A -->B, B --> A, AB --> C }</code></pre>
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Database Systems Design and Implementation - Atomic Domains - Quiz No.1.
Consider the relation given below and ind the maximum normal form applicable to them
i. R(A, B) with productions { A --> B } ii. R(A, B) with productions { B --> A } iii. R(A, B) with productions {A —> B, B --> A } iv. R(A, B, C) with productions {A -->B, B --> A, AB --> C }
i, ii and iii are in 3NF and iv is in BCNF
i and ii are in BCNF and iii and iv are in 3NF
All are in 3NF
All are in BCNF
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes