SOLOSOLOKU: Design Section 4 Quiz

Database Design - Student - English

Test: Section 4 Quiz

Review your answers, feedback, and question scores below.
An asterisk (*) indicates a correct answer.

Section 4 Quiz

(Answer all questions in this section)

1. A business rule such as "All accounts must be paid in full within 10 days 
of billing" is best enforced by:

Making the relationship between CUSTOMER and PAYMENT fully 

mandatory and 1:1 on both sides.

Creating a message to be printed on every bill that reminds the 
customer to pay within ten days.

Making the payment attribute mandatory.

Creating additional programming code to identify and report accounts past due. (*)

2. A business rule such as "We only ship goods after customers have completely 
paid any outstanding balances on their account" is best enforced by:

Making the payment attribute optional.

Creating additional programming code to verify no goods are 
shipped until the account has been settled in full. (*)

Making the payment attribute null.

We need to trust our customers, and we know they will pay some day.

3. Why is it important to identify and document business rules?

It allows you to create a complete data model and then check it for accuracy. (*)

It allows you to improve the client's business.

It ensures that the data model will automate all manual processes.

None of the above

4. How would you model a business rule that states that on a student's birthday, 
he does not have to attend his classes?

Use a subtype

Make the attribute Birthdate mandatory

Use a supertype

You cannot model this. You need to document it (*)

5. Business rules are important to data modelers because:

A. They capture all of the needs, processes, and required functionality of the business. (*)

B. All Business rules are easily implemented in the ERD diagram.

C. The data modeler must focus on structural rules, because they are easily represented diagrammatically and eliminate other rules that involve extra procedures or programming.

D. Both A and C are true.

Test: Section 4 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 4 Quiz
(Answer all questions in this section)

6. Can all constraints be modeled on an ER diagram?

No, but you just explain them to the users so they can enforce them
No, in which case you should let the database administrator handle them
No, and those that cannot be modeled should be listed on a separate document
to be handled programmatically (*)
Yes, all constraints must be modeled and shown on the ER diagram

7. Why is it important to identify and document structural rules?

Ensures we know what data to store and how that data works together. (*)
Ensures nothing. There are no benefits to be gained from 
documenting your Structural Business Rules. We need to concentrate on the Procedural Business Rules only.
Ensures we know what processes are in place and how to program them.
All of the Above.

8. A supertype can only have two subtypes and no more. True or False?

True
False (*)

Incorrect Incorrect. Refer to Section 4 Lesson 1.


9. All ER diagrams must have one of each of the following: (Choose two)
(Choose all correct answers)
One or more Entities (*)
At least one supertype and subtype
Relationships between entities (*)
Arcs

10. A subtype is drawn on an ERD as an entity inside the "softbox" of the supertype. True or False?
True (*)
False

Test: Section 4 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 4 Quiz
(Answer all questions in this section)

11. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False?
True
False (*)

Incorrect Incorrect. Refer to Section 4 Lesson 1.


12. Which of the following is true about subtypes?  
Subtypes must be mutually exclusive. (*)
Subtypes must not be mutually exclusive.
Subtypes should not be exhaustive.
One instance of a supertype may belong to two subtypes.

Incorrect Incorrect. Refer to Section 4 Lesson 1.

13. A Supertype can have only one subtype. True or False?  
True
False (*)

Incorrect Incorrect. Refer to Section 4 Lesson 1.

14. A subtype can have a relationship not shared by the supertype. True or False?
True (*)
False

15. All instances of a subtype may be an instance of the supertype but does not have to. True or False?

True
False (*)