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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!