Discussion
Home ‣ Database ‣ Modeling Data in the Organization Comments
- Question
Which of the following conditions should exist if you want to convert a relationship to an associative entity?
Options- A. Some of the relationships for the participating entities are "many".
- B. The resulting associative entity has an independent meaning.
- C. The resulting associative entity has no attributes.
- D. All of the above
- Correct Answer
- The resulting associative entity has an independent meaning.
- 1. A rectangle represents which of the following in an ERD?
Options- A. Attribute
- B. Entity
- C. Optional One
- D. Relationship Discuss
- 2. A binary relationship is which of the following?
Options- A. A relationship between two attributes
- B. A relationship between two entities
- C. An attribute with two different relationships
- D. An entity with two different relationships Discuss
- 3. 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?
Options- A. Derived attribute
- B. Optional one cardinality
- C. Multi-valued attribute
- D. Weak entity Discuss
- 4. When the minimum number of instances of an entity is one, you know which of the following?
Options- A. Mandatory one
- B. Optional one
- C. Mandatory many
- D. Cannot tell Discuss
- 5. An attribute name should be which of the following?
Options- A. Singular verb or verb phrase
- B. Follow a standard format
- C. Use a alias
- D. All of the above. Discuss
- 6. A relationship is which of the following?
Options- A. A person, place, or thing
- B. Property or characteristic of an entity
- C. Link between entities
- D. Weak entity Discuss
- 7. If no multivalued attributes exist in a relation, then the relation is in what normal form?
Options- A. First normal form
- B. Second normal form
- C. Third normal form
- D. Fourth normal form Discuss
- 8. When mapping a many-to-many unary relationship into a relation which of the following is true?
Options- A. One relation is created.
- B. Two relations are created.
- C. Three relations are created.
- D. Four relations are created. Discuss
- 9. A foreign key is which of the following?
Options- A. Any attribute
- B. The same thing as a primary key
- C. An attribute that serves as the primary key of another relation
- D. An attribute that serves no purpose Discuss
- 10. A primary key is which of the following?
Options- A. Any attribute
- B. An attribute that uniquely identifies each row
- C. An attribute that uniquely identifies each column
- D. A derived attribute Discuss
Modeling Data in the Organization problems
Search Results
Correct Answer: Entity
Correct Answer: A relationship between two entities
Correct Answer: Weak entity
Correct Answer: Cannot tell
Correct Answer: Follow a standard format
Correct Answer: Link between entities
Correct Answer: First normal form
Correct Answer: Two relations are created.
Correct Answer: An attribute that serves as the primary key of another relation
Correct Answer: An attribute that uniquely identifies each row
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.