RDBMS_3

Which of the following is NOT a component of an ER diagram?

• Entity

• Attribute

• Relationship

• Method

In an ER diagram, an attribute is represented by:

• rectangle

• ellipse

• diamond

• line

Which of the following represents a weak entity in an ER diagram?

• underlined attribute

• dashed rectangle

• solid rectangle

• double line rectangle

Which of the following cardinalities represents a many-to-many relationship?

• 1:1

• 1:N

• N:1

• N:M

What is the purpose of a composite attribute in an ER diagram?

• To represent a multivalued attribute

• To represent a derived attribute

• To represent a complex attribute composed of multiple sub-attributes

• To represent a weak entity

In an ER diagram, an attribute represents:

• A relationship between entities

• A property or characteristic of an entity

• A foreign key in a table

• A primary key in a table

Which of the following is NOT a type of attribute in a database?

• Composite attribute

• Derived attribute

• Primary attribute

• Multivalued attribute

Which of the following is an example of a multivalued attribute?

• Age

• Name

• Address

• Phone number

A derived attribute is:

• An attribute that is derived from other attributes

• An attribute with multiple values

• An attribute composed of sub-attributes

• An attribute that uniquely identifies an entity

Which of the following is a valid data type for an attribute?

• Integer

• Relationship

• Entity

• Foreign key