Menu

Question Discussion & Solution

MCQ

Q.

If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

A

DKNF

B

BCNF

C

Fourth

D

Third

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

A

A

B

A

C

AB

D

A

Discussion

MCQ

2.

Which of the following is not a key?

A

A

B

E

C

B, C

D

D

Discussion

MCQ

3.

This comes under

A

Lossy

B

Lossy decomposition

C

Lossless

D

Both Lossy and Lossy

Discussion

MCQ

4.

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

A

2NF

B

5NF

C

4NF

D

3NF

Discussion

MCQ

5.

in terms of normalization, this table is in

A

1NF

B

2NF

C

3NF

D

None of the mentioned

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs