DBMS - AIML B

What is the purpose of normalization in database design?

• To ensure that the database can handle large volumes of data

• To eliminate redundant data and ensure data consistency

• To speed up data retrieval operations in the database

• To provide a clear visual representation of the database schema

In the ER Model, an attribute is represented by a:

• Circle

• Rectangle

• square

• Diamond

Which of the following is not a component of the ER Model?

• Entity

• Attribute

• Constraints

• Relationship

In the ER Model, a relationship is represented by a:

• Diamond

• circle

• square

• Oval

Draw the ER diagram symbol for representing entity

Draw the ER diagram symbol for representing weak entity relationship

Draw the ER diagram symbol for representing primary key attribute.

Drop ____ tablename;

Primary key takes NULL value.

• True

• False

Unique key will not take duplicate values.

• True

• False