MDBMS Unit2

In E-R Diagram, attribute is represented by ________

• rectangle
• diamond
• square
• ellipse

What is the main goal of normalization in DBMS?

• To increase redundancy
• To decrease performance
• To remove redundancy and anomalies
• To create larger tables

In E-R Diagram, entity is represented by ________

• rectangle
• diamond
• square
• ellipse

In an E-R diagram a relationship is represented by________?

• rectangle
• diamond
• square
• ellipse

Entity is a _________

• Object of relation
• Present working model
• Thing in real world
• Model of relation

Which normal form removes multivalued attributes?

• 2NF
• 3NF
• 1NF
• BCNF

Partial dependency is removed in which normal form?

• 1NF
• 2NF
• 3NF
• BCNF

A table is in 2NF if it is in 1NF and ________.

• Has no transitive dependency
• Has no partial dependency
• Is in BCNF
• Has only candidate keys

Transitive dependency is removed in which normal form?

• 1NF
• 2NF
• 3NF
• BCNF

The descriptive property possessed by each entity set is _________

• Entity
• Attribute
• Relation
• Model