Which of the following conditions should exist if an associative entity is to be created?
answer
All of the above:
All the relationships for the participating entities are many-to-many
The new associative entity has independent meaning
The new associative entity participates in independent relationships
question
An entity type whose existence depends on another entity type is called a _____ entity.
answer
weak
question
A property or characteristic of an entity type that is of interest to the organization is called a(n):
answer
attribute
question
An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):
answer
composite identifier
question
In the following diagram, which of the below answers is true?
answer
Both A and C:
Each patient has one or more patient histories.
Each patient history belongs to one and only one patient.
question
An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):
answer
associative entity
question
The common types of entities are:
answer
All of the above:
strong entities
weak entities
associative entities
question
The logical representation of an organization's data is called a(n):
answer
entity-relationship model
question
Which of the following should be considered when selecting an identifier?
answer
All of the above:
choose an identifier that will not be null
choose an identifier that doesn't have large composite attributes
choose an identifier that is stable
question
For the relationship represented in the figure below, which of the following is true?
answer
A department can have more than one employee.
question
An attribute that can be calculated from related attribute values is called a(n) _____ attribute.
answer
derived
question
In an E-R diagram, there are _____ business rule(s) for every relationship.
answer
two
question
A person's name, birthday, and social security number are all examples of:
answer
attributes
question
A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of student to professors is a _____ relationship.
answer
many-to-many
question
In the figure below, which of the following is true?
answer
A person can marry at most one person.
question
The number of entity types that participate in a relationship is called the:
answer
degree
question
In the figure below, which attribute is multivalued?
answer
Skill
question
Which of the following is NOT a good characteristic of a data name?
answer
Relates to a technical characteristic of the system
question
An attribute that must have a value for every entity (or relationship) instance is a(n):
answer
required attribute
question
In the following diagram, which answer is true?
answer
Each employee can supervise one to many employees.
question
A good data definition will describe all of the characteristics of a data object EXCEPT:
answer
who can delete the data
question
An entity name should be all of the following EXCEPT:
answer
as short as possible
question
Customers, cars, and parts are examples of:
answer
entities
question
The total quiz points for a student for an entire semester is a(n) _____ attribute.
answer
derived
question
Which of the following criteria should be considered when selecting an identifier?
answer
All of the above:
choose an identifier that will not be null
choose an identifier that doesn't have large composite attributes
choose an identifier that is stable
question
In the following diagram, which is true?
answer
All of the above:
it depicts a unary relationship
it depicts a many-to-many relationship
there is an associative entity
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
