Question: If processing speed was an important requirement for a company when building out a database, what changes can a designer revise in the next database
If processing speed was an important requirement for a company when building out a database, what changes can a designer revise in the next database iteration if the current design has more than 95% of tables with a 1:1 relationship?
| a. | Create more M:N relationship. | |
| b. | Create more 1:M relationships. | |
| c. | Leave the database design as is. | |
| d. | Combine some tables together. |
In an ERD that says DOCTOR writes PRESCRIPTION, a PATIENT receives a PRESCRIPTION, and a DRUG appears in a PRESCRIPTION, it is mostly portraying what type of relationship degree?
| a. | binary | |
| b. | unary | |
| c. | recursive | |
| d. | ternary |
In the relationship where "PROFESSOR teaches CLASS," and a class can have only one professor teaching, how is the PROFESSOR cardinality notated if PROFESSOR is mandatory?
| a. | (0,N) | |
| b. | (1,N) | |
| c. | (1,1) | |
| d. | (0,1) |
When a composite entity, ENROLL, is between two parent entities CLASS and STUDENT, what would its cardinality be to ensure an enrollment has at least one student, and an enrollment is associated with at least one class?
| a. | (N:1) | |
| b. | (1:M) | |
| c. | (M:1) | |
| d. | (M:N) |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
