ER Model

Which of the following is incorrect about an ER Model. 

• An attribute of an Entity can have more than one value.
• An attribute of an entity can be composite.
• In a row of a relational table an attribute can have more than one value.
• In a row of a relational table an attribute can have exactly one value or NULL.

Double diamond symbol is used for?

• Entity relationship type
• Attribute
• Weak entity relationship type
• Tuple

Which model describes the structure of a database with the help of a diagram?

• Network Model
• Entity-relationship Model
• Relational Model
• Hierarchical Model

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

• Simple attribute
• Composite attribute
• Multivalued attribute
• Derived attribute

What does following symbol depict?

• Cardinality limits

• Total Generalization

• Total participation of entity set in a relationship

• Strong Participation

Address is which kind of the attribute ?

• Composite
• Single
• Simple
• Derived

Degree of a relationship is defined as:

• Number of entities of one entity set related with number of entities in another entity set
• Number of entities that participate in relationship
• Number of records in relationship set
• Number of attributes in entity set

If Every entity in entity set E participates at least once in relationship set R, then participation of entity set E in relationship set R is?

• Null
• Partial
• One to many
• Total

Phone_No is Which type of Attribute?

• Composite
• Descriptive
• Derived
• Multivalued

The descriptive property possessed by each entity set is called as?

• Generalization
• Relationship
• Attribute
• Association