In a many-to-one relationship between entities E1 and E2, one entity instance of E1 may be in relationship with none, one or many entity instances of E2.

False: In a many-to-one relationship between entities E1 and E2, one entity instance of E1 may be in relationship with none, one or many entity instances of E2.

In a many-to-one relationship between entities E1 and E2, one entity instance of E1 may be in relationship with none, one or many entity instances of E2. T or F?

False: In a many-to-one relationship between entities E1 and E2, one entity instance of E1 may be in relationship with at most one entity instances of E2.

Given a multi-value attribute, with a variable number of values, for which we need to process independently the values, it is not recommended to consider a new dependent entity to represent the values.

False: Given a multi-value attribute, with a variable number of values, for which we need to process independently the values, it is recommended to consider a new dependent entity to represent the values. This will allow easy access and management of each value.

Given a multi-value attribute, with two values, for which we need to process independently the values, but without performing global processing on all the values, it is recommended to consider a new dependent entity to represent the values.

False

The _______ (set of values) of an attribute may represent an entity itself (e.g. an address of a person, a city in which a person is living, the phone number of a person).

domain

Given an entity that has only candidate keys with 4 or more attributes, it is usually recommended to create a surrogate key for the entity.

True

A(n) ___ in ER model represents an association among entities..

relationship

A(n) ________ is a characteristic or a quality of an entity.

attribute

A single-value attribute has at most a value for any given entity instance.

true

The acronym for database is DBA.

False: DB

Given a bridge with a candidate key with two attributes, it is usually recommended to create a surrogate key for the bridge.

False

For the entity PERSON the attribute fullname is not an example of a unique values attribute.

true

Given an entity with a set of related attributes describing one of its characteristic, having a lot of duplicated tuples. For instance, for cars at a dealer it is stored the interior and exterior color.

In this situation it is not recommended to consider a new entity describing these attributes.

True

In a one-to-many relationship between entities E1 and E2, one entity instance of E1 may be in relationship with none, one or many entity instances of E2.  

True

Information consists of raw facts, qualitative or quantitative characteristics of an entity.

false: data

Given an entity with a set of related attributes describing one of its characteristic, having a lot of duplicated tuples that must be modified together, risking data anomalies. For instance, for games in a soccer tournament it is stored the address of the field where the game will take place.

In this situation it is recommended to consider a new entity describing these attributes.

True

The phone numbers of a person is an example of a multi-value attribute.

True

In a weak relationship, the PK of the related(child) entity contains a PK component of the parent entity.

False: a strong one

Relationships in ER model are written in __ cases.

lower

Given a multi-value attribute, with a variable number of values, for which we need to process independently the values, it is recommended to consider a new dependent entity to represent the values.

True

Given a bridge with a candidate key with two attributes, it is usually not recommended to create a surrogate key for the bridge.

True