The relation scheme student performance (name, courseNo, rollNo, grade) has the following functional dependencies: name, curseNo --> grade RolINo, courseNo —> grade name —> rollNo rollNo —> name The highest normal form ofthis relation scheme is:

www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
Engineering
Computer Science
Computer Science Set-1
Databases
16

Databases MCQ with Answers

16) The relation scheme student performance (name, courseNo, rollNo, grade) has the following functional dependencies:
name, curseNo --> grade
RolINo, courseNo —> grade
name —> rollNo
rollNo —> name
The highest normal form ofthis relation scheme is:

2 NF

3 NF

BCNF

4 NF

Answer is:

3 NF

Databases MCQ with Answers

For more MCQ's Click Here

18) Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold: {A —> B, BC ---> D, E, —> C, D —> Al . What are the candidate keys of R?

AE, BE

AE, BE, DE

AEH, BEH, BCH

AEH, BEH, DEH

Answer is:

AEH, BEH, DEH

19) The following functional dependencies are given:
AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A
Which one of the following options is false?

{CF}+ = {ACDEFG}

{BG}± = {ABCDG}

{AE }+ = {ACDEFG}

{AC = {ACDFG}

Answer is:

{AE }+ = {ACDEFG}

20) Which one of the following statements is FALSE

Any relation with two attributes is in BCNF

A relation in which every key has only one attributes is in 2NF

A prime attribute can be transitively dependent on a key in 3 NF relation

A prime attribute can be transitively dependent on a key in a BCNF relation

Answer is:

A prime attribute can be transitively dependent on a key in a BCNF relation

21) Consider the following relational schemes for a library for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
Which ofthe 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

Answer is:

Book is in 2NF and Collection is in 3NF

Databases MCQ with Answers

For more MCQ's Click Here

16) The relation scheme student performance (name, courseNo, rollNo, grade) has the following functional dependencies: name, curseNo --> grade RolINo, courseNo —> grade name —> rollNo rollNo —> name The highest normal form ofthis relation scheme is:

3 NF

Databases MCQ with Answers

Related Databases MCQ with Answers

18) Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold: {A —> B, BC ---> D, E, —> C, D —> Al . What are the candidate keys of R?

AEH, BEH, DEH

19) The following functional dependencies are given: AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A Which one of the following options is false?

{AE }+ = {ACDEFG}

20) Which one of the following statements is FALSE

A prime attribute can be transitively dependent on a key in a BCNF relation

Book is in 2NF and Collection is in 3NF

Databases MCQ with Answers

16) The relation scheme student performance (name, courseNo, rollNo, grade) has the following functional dependencies:
name, curseNo --> grade
RolINo, courseNo —> grade
name —> rollNo
rollNo —> name
The highest normal form ofthis relation scheme is:

19) The following functional dependencies are given:
AB -> CD, AF —> D, DE --> F, C —> G, F —› E, G --> A
Which one of the following options is false?