IT214
Right
Given a bridge with a candidate key with two attributes, it is usually not recommended to create a surrogate key for the bridge
Wrong
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 department entity to represent the values.
Right
Given a multi-value attribute, with two values, for which we need to process independently the values, but without preforming global processing on all the values, it is not recommended to consider a new department entity to represent the values.
Right
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.
MANY to ONE
A student has one advisor but an advisor advises many students.
simple
A ______ primary key is composed of a single attributes
Right
A database organized in terms of the relational model is a relational database
entity
A(n) ___________ has a distinct existence as an individual unit
attribute
A(n) _____________ is a characteristic or quality of an entity
instance
An entity ____________ is described by the values of its attributes
Right
An entity is a thing that exists either physically or logically
Right
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 is is stored the addresses of the field where the game will take place. In this situation it is recommended to consider a new entity describing theses attributes.
Right
Relationship names are verbs, linking two or more nouns
Wrong
Relationships names are adjectives in relation with a noun
attribute
The domain of an _______________ may represent an entity itself (e.g. an address of a person, city in which a person is living, the phone number of a person).
is a database organized based on the relational model
What is a relational database?