DBMS Chapter 4 Review

25 July 2022
4.7 (114 reviews)
95 test answers
question
An ERM is dependent on the database type.
answer
False
question
The word "entity" in the ER model corresponds to a table.
answer
True
question
The Crow's Foot model is less implementation-oriented than the Chen model.
answer
False
question
The ER diagram represents the conceptual database as viewed by the end user.
answer
True
question
The ER model refers to a specific table row as an entity instance.
answer
True
question
In both the Chen and Crow's Foot models, an entity is represented with a rectangle containing the entity's name.
answer
True
question
The ER model refers to a specific table row as an entity occurrence.
answer
True
question
Attributes are types of entities.
answer
False
question
In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.
answer
True
question
The Chen model is especially useful to illustrate some of the conceptual elements of database design.
answer
True
question
Attributes do not have a domain.
answer
False
question
Attributes cannot share a domain.
answer
False
question
In an ER diagram, primary keys are usually bolded.
answer
False
question
Ideally, a primary key is composed of several attributes.
answer
False
question
A composite key is a primary key composed of more than one attribute.
answer
True
question
All attributes are either simple or composite.
answer
True
question
All simple attributes are also single-valued.
answer
False
question
In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
answer
True
question
The DBMS can easily handle multivalued attributes.
answer
False
question
Derived attributes are stored in a special database table.
answer
False
question
Cardinality expresses the specific number of entity occurrences associated with every occurrence of a related entity.
answer
False
question
Cardinality expresses the specific number of entity occurrences associated with one occurrence of the related entity.
answer
True
question
In Chen notation, there is no way to represent cardinality.
answer
False
question
Connectivities and cardinalities are established by business rules.
answer
True
question
All entity relationships can be characterized as weak or strong.
answer
True
question
You should always load data from the 1 side of a 1:M relationship.
answer
True
question
A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.
answer
True
question
The existence of a mandatory relationship indicates that the minimum cardinality is 1 for the mandatory entity.
answer
True
question
Relationship participation is not very important when designing a database.
answer
False
question
Database designers must obtain a precise description of the nature of the data and the many uses of such data within an organization.
answer
True
question
The ERD is used to graphically represent the ____ database model. a. condensed c. logical b. physical d. conceptual
answer
d. conceptual
question
The Chen model is especially useful to illustrate the database from a(n) ____ perspective. a. developmental c. actual b. conceptual d. specific
answer
b. conceptual
question
Attributes may share a ____. a. name c. location b. domain d. table
answer
b. domain
question
The set of possible values for an attribute is a ____. a. domain c. set b. range d. key
answer
a. domain
question
In an ER diagram, primary keys are indicated by ____. a. bolding c. underlining b. italics d. a special font
answer
c. underlining
question
The ideal number of attributes used to make up a primary key is ____. a. zero c. two b. one d. six
answer
b. one
question
The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM) a. CRS_CODE b. CLASS_SECTION c. CRS_CODE and CLASS_SECTION d. There is no primary key
answer
c. CRS_CODE and CLASS_SECTION
question
A ____ key is a key that consists of more than one attribute. a. primary c. composite b. foreign d. domain
answer
c. composite
question
A ____ attribute can be further subdivided to yield additional attributes. a. Composite c. Single-valued b. Simple d. Multivalued
answer
a. Composite
question
A ____ attribute is one that cannot be subdivided. a. Composite c. Single-valued b. Simple d. Multivalued
answer
b. Simple
question
A ____ attribute can have only one value. a. Composite c. Single-valued b. Simple d. Multivalued
answer
c. Single-valued
question
____ attributes can have several values. a. Composite c. Single-valued b. Simple d. Multivalued
answer
d. Multivalued
question
Some attributes are classified as ____. a. simple c. defined b. complex d. grouped
answer
a. simple
question
A ____ might be represented with a multivalued attribute. a. Person's name b. Household phone numbers c. Bank account balance d. Book title
answer
b. Household phone numbers
question
The following,____, might be represented with a single-valued attribute. a. Person's phone number(s) b. Car's color c. Employee's educational background d. Person's social security number
answer
d. Person's social security number
question
The ____ type of attribute cannot be created in a DBMS. a. derived c. simple b. multivalued d. composite
answer
b. multivalued
question
A ____ should be a derived attribute. a. Person's name b. Person's age c. Person's social security number d. Person's phone number
answer
b. Person's age
question
A derived attribute ____. a. must be stored physically within the database b. need not be physically stored within the database c. has many values d. must be based on the value of three or more attributes
answer
b. need not to be physically stored within the databse
question
A derived attribute is indicated in the Chen model by a ____. a. Single line c. Circle b. Dashed line d. Double line
answer
b. Dashed line
question
A relationship is an association between ____. a. objects c. databases b. entities d. fields
answer
b. entities
question
Knowing the ____ number of entity occurrences is very helpful at the application software level. a. maximum c. exact b. minimum d. max and min
answer
d. max and min
question
In the ERD, cardinality is indicated using the ____ notation. a. (max, min) c. [min ... max] b. (min, max) d. {min|max}
answer
b. (min, max)
question
Making sure all ____ are identified is a very important part of a database designer's job. a. business rules b. cardinalities c. derived attributes d. relationships
answer
a. business rules
question
Another word for existence-independent is ____. a. weak c. unary b. alone d. strong
answer
d. strong
question
When the PK of one entity does not contain the PK of a related entity, the relationship is ____. a. missing c. strong b. weak d. neutral
answer
b. weak
question
If an entity's existence depends on the existence of one or more other entities, it is said to be ____-dependent. a. existence c. business b. relationship d. weak
answer
a. existence
question
If an entity can exist apart from one or more related entities, it is said to be ____-independent. a. existence c. business b. relationship d. weak
answer
a. existence
question
A ____ entity has a primary key that is partially derived from the parent entity in the relationship. a. strong c. business b. weak d. relationship
answer
b. weak
question
The term "____" is used to label any condition in which one or more optional relationships exist. a. participation b. optionality c. cardinality d. connectivity
answer
b. optionality
question
The existence of a(n) ____ relationship indicates that the minimum cardinality is 1 for the mandatory entity. a. mandatory b. optional c. multivalued d. single-valued
answer
a. mandatory
question
The Crow's foot symbol with two parallel lines indicates ____ cardinality. a. (0,N) c. (1,1) b. (1,N) d. (0,1)
answer
c. (1,1)
question
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship. a. self c. looping b. self-referring d. recursive
answer
d. recursive
question
A ____ relationship exists when an association is maintained within a single entity. a. unary c. binary b. ternary d. weak
answer
a. unary
question
A ____ relationship exists when two entities are associated. a. unary c. ternary b. binary d. weak
answer
b. binary
question
A ____ relationship exists when three entities are associated. a. unary c. ternary b. binary d. weak
answer
c. ternary
question
____ relationships are most common. a. Unary c. Ternary b. Binary d. Higher-degree
answer
b. Binary
question
A ____ entity is composed of the primary keys of each of the entities to be connected. a. bridge c. unary b. composite d. binary
answer
a. bridge
question
The bridge entity is known as a ____ entity. a. unary c. strong b. weak d. composite
answer
d. composite
question
The step,____, occurs first in the process of building an ERD. a. Develop the initial ERD. b. Create a detailed narrative of the organization's description of operations. c. Identify the attributes and primary keys that adequately describe the entities. d. Identify the business rules based on the description of operations.
answer
b. Create a detailed narrative of the organization's description of operations.
question
Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. a. information c. design b. entity d. processing
answer
a. information
question
The Chen model is specially useful to illustrate some of the ____________________ elements of database design.
answer
conceptual
question
The Crow's Foot model is more ____________________-oriented than the Chen model.
answer
implementation
question
The ERM forms the basis of a(n) ____________________.
answer
ERD (entity relationship diagram)
question
The ____________________ refers to a specific table row as an entity instance.
answer
ER model (ERM)
question
____________________ are characteristics of entities.
answer
Attributes
question
A(n) ____________________ is the attribute's set of possible values.
answer
domain
question
____________________ are underlined in an ER diagram.
answer
Primary keys
question
A person's social security number would be an example of a(n) ____________________ attribute.
answer
single-valued simple
question
____________________ attributes can be subdivided.
answer
Composite
question
A(n) ____________________ attribute cannot be subdivided.
answer
simple
question
An attribute representing one or more college degrees belonging to a person would be a(n) ____________________ attribute.
answer
multivalued
question
Instead of storing a person's age, it is better to store the date of birth and use the difference between that value and the system date as a(n) ____________________ attribute.
answer
derived
question
A(n) ____________________ attribute need not be physically stored within the database.
answer
derived
question
Connectivities and cardinalities are usually based on ____________________ rules.
answer
business
question
In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.
answer
existence-dependent
question
A(n) ____________________ relationship is also known as an identifying relationship.
answer
strong
question
The Crow's Foot notation depicts the strong relationship with a(n) ____________________ line between the entities.
answer
solid
question
A weak entity must be ____________________-dependent.
answer
existence
question
Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
answer
optional
question
Relationship strength depends on how the primary key of the related entity is formulated, while the relationship ____________________ depends on how the business rule is written.
answer
participation
question
In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) ____________________ on the side of the optional entity.
answer
small circle O
question
Failure to understand the distinction between mandatory and optional ____________________ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.
answer
participation
question
A(n) ____________________ relationship exists when two entities are associated.
answer
binary
question
In the original ERM described by Chen, relationships do not contain ____________________.
answer
attributes
question
Identifying the attributes of the entities helps you better understand the ____________________ among entities.
answer
relationships
1 of 95

Unlock all answers in this set

Unlock answers (91)
question
An ERM is dependent on the database type.
answer
False
question
The word "entity" in the ER model corresponds to a table.
answer
True
question
The Crow's Foot model is less implementation-oriented than the Chen model.
answer
False
question
The ER diagram represents the conceptual database as viewed by the end user.
answer
True
question
The ER model refers to a specific table row as an entity instance.
answer
True
question
In both the Chen and Crow's Foot models, an entity is represented with a rectangle containing the entity's name.
answer
True
question
The ER model refers to a specific table row as an entity occurrence.
answer
True
question
Attributes are types of entities.
answer
False
question
In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.
answer
True
question
The Chen model is especially useful to illustrate some of the conceptual elements of database design.
answer
True
question
Attributes do not have a domain.
answer
False
question
Attributes cannot share a domain.
answer
False
question
In an ER diagram, primary keys are usually bolded.
answer
False
question
Ideally, a primary key is composed of several attributes.
answer
False
question
A composite key is a primary key composed of more than one attribute.
answer
True
question
All attributes are either simple or composite.
answer
True
question
All simple attributes are also single-valued.
answer
False
question
In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
answer
True
question
The DBMS can easily handle multivalued attributes.
answer
False
question
Derived attributes are stored in a special database table.
answer
False
question
Cardinality expresses the specific number of entity occurrences associated with every occurrence of a related entity.
answer
False
question
Cardinality expresses the specific number of entity occurrences associated with one occurrence of the related entity.
answer
True
question
In Chen notation, there is no way to represent cardinality.
answer
False
question
Connectivities and cardinalities are established by business rules.
answer
True
question
All entity relationships can be characterized as weak or strong.
answer
True
question
You should always load data from the 1 side of a 1:M relationship.
answer
True
question
A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.
answer
True
question
The existence of a mandatory relationship indicates that the minimum cardinality is 1 for the mandatory entity.
answer
True
question
Relationship participation is not very important when designing a database.
answer
False
question
Database designers must obtain a precise description of the nature of the data and the many uses of such data within an organization.
answer
True
question
The ERD is used to graphically represent the ____ database model. a. condensed c. logical b. physical d. conceptual
answer
d. conceptual
question
The Chen model is especially useful to illustrate the database from a(n) ____ perspective. a. developmental c. actual b. conceptual d. specific
answer
b. conceptual
question
Attributes may share a ____. a. name c. location b. domain d. table
answer
b. domain
question
The set of possible values for an attribute is a ____. a. domain c. set b. range d. key
answer
a. domain
question
In an ER diagram, primary keys are indicated by ____. a. bolding c. underlining b. italics d. a special font
answer
c. underlining
question
The ideal number of attributes used to make up a primary key is ____. a. zero c. two b. one d. six
answer
b. one
question
The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM) a. CRS_CODE b. CLASS_SECTION c. CRS_CODE and CLASS_SECTION d. There is no primary key
answer
c. CRS_CODE and CLASS_SECTION
question
A ____ key is a key that consists of more than one attribute. a. primary c. composite b. foreign d. domain
answer
c. composite
question
A ____ attribute can be further subdivided to yield additional attributes. a. Composite c. Single-valued b. Simple d. Multivalued
answer
a. Composite
question
A ____ attribute is one that cannot be subdivided. a. Composite c. Single-valued b. Simple d. Multivalued
answer
b. Simple
question
A ____ attribute can have only one value. a. Composite c. Single-valued b. Simple d. Multivalued
answer
c. Single-valued
question
____ attributes can have several values. a. Composite c. Single-valued b. Simple d. Multivalued
answer
d. Multivalued
question
Some attributes are classified as ____. a. simple c. defined b. complex d. grouped
answer
a. simple
question
A ____ might be represented with a multivalued attribute. a. Person's name b. Household phone numbers c. Bank account balance d. Book title
answer
b. Household phone numbers
question
The following,____, might be represented with a single-valued attribute. a. Person's phone number(s) b. Car's color c. Employee's educational background d. Person's social security number
answer
d. Person's social security number
question
The ____ type of attribute cannot be created in a DBMS. a. derived c. simple b. multivalued d. composite
answer
b. multivalued
question
A ____ should be a derived attribute. a. Person's name b. Person's age c. Person's social security number d. Person's phone number
answer
b. Person's age
question
A derived attribute ____. a. must be stored physically within the database b. need not be physically stored within the database c. has many values d. must be based on the value of three or more attributes
answer
b. need not to be physically stored within the databse
question
A derived attribute is indicated in the Chen model by a ____. a. Single line c. Circle b. Dashed line d. Double line
answer
b. Dashed line
question
A relationship is an association between ____. a. objects c. databases b. entities d. fields
answer
b. entities
question
Knowing the ____ number of entity occurrences is very helpful at the application software level. a. maximum c. exact b. minimum d. max and min
answer
d. max and min
question
In the ERD, cardinality is indicated using the ____ notation. a. (max, min) c. [min ... max] b. (min, max) d. {min|max}
answer
b. (min, max)
question
Making sure all ____ are identified is a very important part of a database designer's job. a. business rules b. cardinalities c. derived attributes d. relationships
answer
a. business rules
question
Another word for existence-independent is ____. a. weak c. unary b. alone d. strong
answer
d. strong
question
When the PK of one entity does not contain the PK of a related entity, the relationship is ____. a. missing c. strong b. weak d. neutral
answer
b. weak
question
If an entity's existence depends on the existence of one or more other entities, it is said to be ____-dependent. a. existence c. business b. relationship d. weak
answer
a. existence
question
If an entity can exist apart from one or more related entities, it is said to be ____-independent. a. existence c. business b. relationship d. weak
answer
a. existence
question
A ____ entity has a primary key that is partially derived from the parent entity in the relationship. a. strong c. business b. weak d. relationship
answer
b. weak
question
The term "____" is used to label any condition in which one or more optional relationships exist. a. participation b. optionality c. cardinality d. connectivity
answer
b. optionality
question
The existence of a(n) ____ relationship indicates that the minimum cardinality is 1 for the mandatory entity. a. mandatory b. optional c. multivalued d. single-valued
answer
a. mandatory
question
The Crow's foot symbol with two parallel lines indicates ____ cardinality. a. (0,N) c. (1,1) b. (1,N) d. (0,1)
answer
c. (1,1)
question
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship. a. self c. looping b. self-referring d. recursive
answer
d. recursive
question
A ____ relationship exists when an association is maintained within a single entity. a. unary c. binary b. ternary d. weak
answer
a. unary
question
A ____ relationship exists when two entities are associated. a. unary c. ternary b. binary d. weak
answer
b. binary
question
A ____ relationship exists when three entities are associated. a. unary c. ternary b. binary d. weak
answer
c. ternary
question
____ relationships are most common. a. Unary c. Ternary b. Binary d. Higher-degree
answer
b. Binary
question
A ____ entity is composed of the primary keys of each of the entities to be connected. a. bridge c. unary b. composite d. binary
answer
a. bridge
question
The bridge entity is known as a ____ entity. a. unary c. strong b. weak d. composite
answer
d. composite
question
The step,____, occurs first in the process of building an ERD. a. Develop the initial ERD. b. Create a detailed narrative of the organization's description of operations. c. Identify the attributes and primary keys that adequately describe the entities. d. Identify the business rules based on the description of operations.
answer
b. Create a detailed narrative of the organization's description of operations.
question
Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. a. information c. design b. entity d. processing
answer
a. information
question
The Chen model is specially useful to illustrate some of the ____________________ elements of database design.
answer
conceptual
question
The Crow's Foot model is more ____________________-oriented than the Chen model.
answer
implementation
question
The ERM forms the basis of a(n) ____________________.
answer
ERD (entity relationship diagram)
question
The ____________________ refers to a specific table row as an entity instance.
answer
ER model (ERM)
question
____________________ are characteristics of entities.
answer
Attributes
question
A(n) ____________________ is the attribute's set of possible values.
answer
domain
question
____________________ are underlined in an ER diagram.
answer
Primary keys
question
A person's social security number would be an example of a(n) ____________________ attribute.
answer
single-valued simple
question
____________________ attributes can be subdivided.
answer
Composite
question
A(n) ____________________ attribute cannot be subdivided.
answer
simple
question
An attribute representing one or more college degrees belonging to a person would be a(n) ____________________ attribute.
answer
multivalued
question
Instead of storing a person's age, it is better to store the date of birth and use the difference between that value and the system date as a(n) ____________________ attribute.
answer
derived
question
A(n) ____________________ attribute need not be physically stored within the database.
answer
derived
question
Connectivities and cardinalities are usually based on ____________________ rules.
answer
business
question
In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.
answer
existence-dependent
question
A(n) ____________________ relationship is also known as an identifying relationship.
answer
strong
question
The Crow's Foot notation depicts the strong relationship with a(n) ____________________ line between the entities.
answer
solid
question
A weak entity must be ____________________-dependent.
answer
existence
question
Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
answer
optional
question
Relationship strength depends on how the primary key of the related entity is formulated, while the relationship ____________________ depends on how the business rule is written.
answer
participation
question
In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) ____________________ on the side of the optional entity.
answer
small circle O
question
Failure to understand the distinction between mandatory and optional ____________________ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.
answer
participation
question
A(n) ____________________ relationship exists when two entities are associated.
answer
binary
question
In the original ERM described by Chen, relationships do not contain ____________________.
answer
attributes
question
Identifying the attributes of the entities helps you better understand the ____________________ among entities.
answer
relationships