Question
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 -> Pricea.
Both Book and Collection are in BCNF
b.
Both Book and Collection are in 3NF only
c.
Book is in 2NF and Collection is in 3NF
d.
Both Book and Collection are in 2NF only
Posted under Data Storage and Querying DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Consider the following relational schemes for a library database:Assume {Author, Title} is the key for both schemes. Which of the following statements is true?
Similar Questions
Discover Related MCQs
Q. Let R(A,B,C,D,E,P,G) be a relational schema in which the following FDs are known to hold:
AB->CD
DE->P
C->E
P->C
B->G
The relation schema R is
View solution
Q. Which of the following is/are false for RAW mode of FOR XML?
View solution
Q. ___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
View solution
Q. Which utilities can we used to export data from sql server to a text file?
View solution
Q. You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?
View solution
Q. Problems occurs if we don’t implement proper locking strategy
View solution
Q. Which of the following fixed database roles can add or remove user IDs?
View solution
Q. By default sql server has ___________ isolation level
View solution
Q. Which feature converts row data to column for better analytical view?
View solution
Q. Which of the following statements is/are not true for SQL profiler?
View solution
Q. Which global variables can be used to determine if a transaction is still open?
View solution
Q. Which statement is used to define a cursor?
View solution
Q. What is the default “SORT” order for a SQL?
View solution
Q. Capabilities of RAISERROR
View solution
Q. How inserting data through stored procedure do reduces network traffic and increase database performance?
View solution
Q. Stored procedures are safe from SQL injection attacks
View solution
Q. Which of the following connection type supports application role permissions and password encryption?
View solution
Q. Cursor that reflects the changes made to the database table even after the result set is returned
View solution
Q. _______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.
View solution
Q. ___________ combines the data manipulating power of SQL with the data processing power of Procedural languages.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
