unit 5 pt1

What is the primary purpose of Entity-Relationship (ER) modeling?

• To manage network security

• To design database structures

• To develop software applications

• To create user interfaces

Which of the following is NOT a basic concept of the ER model?

• Relationships

• Functions

• Entities

• Attributes

What does a binary relationship involve?

• One entity type

• Two entity types

• Three entity types

• Four entity types

What is a weak entity type?

• An entity with no attributes

• An entity with a strong primary key

• An entity that is existence-dependent

• An entity that can exist independently

Which of the following describes a composite attribute?

• An attribute derived from another attribute

• An attribute with multiple components

• An attribute that cannot exist independently

• An attribute with a single value

What is a candidate key?

• A key that is not unique

• A key that is derived from another key

• A key that is used for foreign key relationships

• A minimal set of attributes that uniquely identifies an entity

Which relationship type is characterized by the same entity type participating more than once?

• Quaternary relationship

• Recursive relationship

• Ternary relationship

• Binary relationship

What does the term 'attribute domain' refer to?

• The diagrammatic representation of attributes

• The relationship between two entities

• The set of allowable values for an attribute

• The set of all possible entities

In an ER diagram, what does a one-to-many (1:*) relationship indicate?

• Many entities can relate to one entity

• One entity can relate to many entities

• One entity relates to one entity

• Many entities relate to many entities

What is the purpose of role names in recursive relationships?

• To define the primary key

• To indicate the purpose of each entity in the relationship

• To represent attributes

• To show the multiplicity of relationships