Database

Database

Modeling Data in the Organization has 30 Questions

A binary relationship is which of the following?

A relationship between two attributes
A relationship between two entities
An attribute with two different relationships
An entity with two different relationships
An attribute is a person, place, object, event in a user environment.

True
False
If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

Derived attribute
Optional one cardinality
Multi-valued attribute
Weak entity
Output reports should be included as part of an ERD.

True
False
A relationship is which of the following?

A person, place, or thing
Property or characteristic of an entity
Link between entities
Weak entity
Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.

True
False
Which of the following conditions should exist if you want to convert a relationship to an associative entity?

Some of the relationships for the participating entities are "many".
The resulting associative entity has an independent meaning.
The resulting associative entity has no attributes.
All of the above
Relationships cannot have attributes.

True
False
A good identifier is which of the following?

One that can change over time
Can be null
One that is unique
Be intelligent
Business rules and policies are universal.

True
False
A rectangle represents which of the following in an ERD?

Attribute
Entity
Optional One
Relationship
A relationship is an association representing the interaction between attributes.

True
False
An entity name should be which of the following?

A singular noun
Specific to the organization
Concise
All of the above.
A binary relationship is a relationship between two or more entities.

True
False
An oval represents which of the following in an ERD?

Attribute
Entity
Optional One
Relationship
Some business rules cannot be represented in common data modeling notation.

True
False
When the minimum and maximum number of instances of an entity is one, you know which of the following?

Mandatory one
Optional one
Mandatory many
Cannot tell
A time stamp is a time value that is associated with a data value.

True
False
An attribute name should be which of the following?

Singular verb or verb phrase
Follow a standard format
Use a alias
All of the above.
A logical representation of the data for an organization or for a business area is known as an entity-relationship model.

True
False
A composite attribute is which of the following?

An attribute that can be broken into components
An attribute that cannot be broken into components
Multiple attributes
An identifier
A derived attribute is an attribute whose values can be calculated from a related relationship.

True
False
A binary relationship cannot be which of the following?

One-to-One
One-to-Many
Many-to-Many
Zero-to-Zero
A fact is a word or phrase that has a specific meaning for the business.

True
False
A ternary relationship involves how many entities?

3 or less
3
More than 3
3 or more
A strong entity is an entity whose existence depends on some other entity type.

True
False
When the minimum number of instances of an entity is one, you know which of the following?

Mandatory one
Optional one
Mandatory many
Cannot tell
Multiple and binary relationships are the same thing.

True
False
A good business rule is which of the following?

Declarative
Imprecise
Redundant
Compound
No two attributes of the same entity type should have the same name.

True
False