Question
I have five E-R model questions: Question 24 1. When converting an E-R model to a relational model, the table for a binary relationship can
I have five E-R model questions:
Question 24
1. When converting an E-R model to a relational model, the table for a binary relationship can be replaced by a foreign key provided the relationship is not
| A. | many-to-many |
| B. | many-to-one |
| C. | one-to-many |
| D. | one-to-one |
0.5 points
Question 31
1. In the E-R model, an attribute that can be broken down into smaller attributes is called
| A. | composite |
| B. | null |
| C. | a superattribute |
| D. | derived |
0.5 points
Question 34
1. In the EE-R model, completeness constraints tell us whether a specialization is
| A. | total or partial |
| B. | union or category |
| C. | disjoint or overlapping |
| D. | predicate-defined or user-defined |
0.5 points
Question 38
1. When an entity set is related to itself, we have a _______ relationship.
| A. | extended |
| B. | optional |
| C. | mandatory |
| D. | recursive |
0.5 points
Question 39
1. In the relational model, the table in which a foreign key appears as the primary key is called its
| A. | root relation |
| B. | home relation |
| C. | child relation |
| D. | foreign relation |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started