Database - Modeling Data in the Organization
Database - Modeling Data in the Organization
1. 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
2. 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
3. A relationship is which of the following?
- A person, place, or thing
- Property or characteristic of an entity
- Link between entities
- Weak entity
4. 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
5. A good identifier is which of the following?
- One that can change over time
- Can be null
- One that is unique
- Be intelligent
6. A rectangle represents which of the following in an ERD?
- Attribute
- Entity
- Optional One
- Relationship
7. An entity name should be which of the following?
- A singular noun
- Specific to the organization
- Concise
- All of the above.
8. An oval represents which of the following in an ERD?
- Attribute
- Entity
- Optional One
- Relationship
9. 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
10. 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.