Consider The Following Relational Schemes For A Library #843
Consider the following relational schemes for a library database:</p> <pre><code class="language-sql">Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) With the following functional dependencies: I. Title Author -> Catalog_no II. Catalog_no -> Title Author Publisher Year III. Publisher Title Year -> Price </code></pre> <p>Assume {Author, Title} is the key for both schemes. Which of the following statements is true?
This multiple choice question (MCQ) is related to the book/course
gs gs117 Database Management System.
It can also be found in
gs gs117 Query Processing Techniques - Transformation of Relational Expressions - Quiz No.1.
Consider the following relational schemes for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) With the following functional dependencies: I. Title Author -> Catalog_no II. Catalog_no -> Title Author Publisher Year III. Publisher Title Year -> Price Assume {Author, Title} is the key for both schemes. Which of the following statements is true?
Both Book and Collection are in BCNF
Both Book and Collection are in 3NF only
Book is in 2NF and Collection is in 3NF
Both Book and Collection are in 2NF only
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
