Appendix C: Databases – Flashcards
22 test answers
Unlock all answers in this set
Unlock answers 22question
What has only a single value of each attribute of an entity?
answer
Single-valued attribute
Unlock the answer
question
What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?
answer
Null-valued attribute
Unlock the answer
question
What kind of attribute would be age?
answer
Derived attribute
Unlock the answer
question
What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?
answer
One-to-one relationship
Unlock the answer
question
What is a statement that defines an aspect of a business?
answer
Business rule
Unlock the answer
question
What is a technique for documenting the entities and relationships in a database environment?
answer
Entity-relationship diagram
Unlock the answer
question
What is a collection of related data elements?
answer
Record
Unlock the answer
question
Which of the following statements is accurate?
answer
Each business rule will have entities and sometimes even attributes. A typical business may have hundreds of business rules. *All of these. A correct business rule for one organization may not be correct for another organization.
Unlock the answer
question
What kind of attribute would be date of birth?
answer
Stored attribute
Unlock the answer
question
What exists to represent the relationship between two other entities?
answer
Composite entity
Unlock the answer
question
What is composed of rows and columns that represent an entity?
answer
Table
Unlock the answer
question
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
answer
One-to-many relationship
Unlock the answer
question
What is a foreign key?
answer
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
Unlock the answer
question
What occurs when two entities can be related to each other in many instances?
answer
Many-to-many relationship
Unlock the answer
question
What kind of attribute can be calculated using the value of another attribute?
answer
Derived attribute
Unlock the answer
question
What is a primary key?
answer
A field that uniquely identifies a given record in a table
Unlock the answer
question
What expresses the specific number of instances in an entity?
answer
Cardinality
Unlock the answer
question
What has the potential to contain more than one value for an attribute?
answer
Multi-valued attribute
Unlock the answer