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: Mark for Review
(1) Points
Creating a message to be printed on every bill that reminds the customer to pay within ten days.
Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
Creating additional programming code to identify and report accounts past due. (*)
Making the payment attribute mandatory.
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: Mark for Review
(1) Points
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.
Making the payment attribute optional.
3. How should you handle constraints that cannot be modeled on an ER diagram? Mark for Review
(1) Points
Always let the network architect handle them
Explain them to the users so they can enforce them
All constraints must be modeled and shown on the ER diagram
List them on a separate document to be handled programmatically (*)
4. Which of the following is an example of a structural business rule? Mark for Review
(1) Points
All employees must belong to at least one department. (*)
All products will have a selling price no less than 30 % greater than wholesale.
All overdue payments will have an added 10 % late fee.
Buildings to be purchased by the business must be current with earthquake building code.
5. Can all constraints be modeled on an ER diagram? Mark for Review
(1) Points
No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)
No, in which case you should let the database administrator handle them
Yes, all constraints must be modeled and shown on the ER diagram
No, but you just explain them to the users so they can enforce them
6. Why is it important to identify and document business rules? Mark for Review
(1) Points
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
7. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points
Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
Use a supertype
Make the attribute Gender optional
Make the attribute Gender mandatory
8. A subtype can have a relationship not shared by the supertype. True or False? Mark for Review
(1) Points
True (*)
False
9. A subtype is drawn on an ERD as an entity inside the "softbox" of the supertype. True or False? Mark for Review
(1) Points
True (*)
False
10. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False? Mark for Review
(1) Points
True
False (*)
11. Which of the following is true about subtypes? Mark for Review
(1) Points
One instance of a supertype may belong to two subtypes.
Subtypes should not be exhaustive.
Subtypes must be mutually exclusive. (*)
Subtypes must not be mutually exclusive.
12. All instances of a subtype must be an instance of the supertype. True or False? Mark for Review
(1) Points
True (*)
False
13. A supertype can only have two subtypes and no more. True or False? Mark for Review
(1) Points
True
False (*)
14. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points
True
False (*)
15. A Supertype can have only one subtype. True or False? Mark for Review
(1) Points
True
False (*)
1. How would you model a business rule that states that on a student's birthday, he does not have to attend his classes? Mark for Review
(1) Points
Use a supertype
Make the attribute Birthdate mandatory
You cannot model this. You need to document it (*)
Use a subtype
2. Why is it important to identify and document business rules? Mark for Review
(1) Points
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
3.A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False? Mark for Review
(1) Points
True (*)
False
4. A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by: Mark for Review
(1) Points
Creating additional programming code to identify and report accounts past due. (*)
Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
Making the payment attribute mandatory.
Creating a message to be printed on every bill that reminds the customer to pay within ten days.
5. How should you handle constraints that cannot be modeled on an ER diagram? Mark for Review
(1) Points
Always let the network architect handle them
List them on a separate document to be handled programmatically (*)
All constraints must be modeled and shown on the ER diagram
Explain them to the users so they can enforce them
6. Why is it important to identify and document structural rules? Mark for Review
(1) Points
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.
7. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points
Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
Make the attribute Gender mandatory
Make the attribute Gender optional
Use a supertype
8. A supertype can only have two subtypes and no more. True or False? Mark for Review
(1) Points
True
False (*)
9. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review
(1) Points
True (*)
False
10. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False? Mark for Review
(1) Points
True
False (*)
11. Which of the following is true about subtypes? Mark for Review
(1) Points
Subtypes should not be exhaustive.
Subtypes must not be mutually exclusive.
Subtypes must be mutually exclusive. (*)
One instance of a supertype may belong to two subtypes.
12. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points
True
False (*)
13. A subtype can have a relationship not shared by the supertype. True or False? Mark for Review
(1) Points
True (*)
False
14. A Supertype can have only one subtype. True or False? Mark for Review
(1) Points
True
False (*)
15. All instances of a subtype must be an instance of the supertype. True or False? Mark for Review
(1) Points
True (*)
False
1. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points
Use a supertype
Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
Make the attribute Gender optional
Make the attribute Gender mandatory
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: Mark for Review
(1) Points
Making the payment attribute null.
Creating additional programming code to verify no goods are shipped until the account has been settled in full. (*)
We need to trust our customers, and we know they will pay some day.
Making the payment attribute optional.
3. A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by: Mark for Review
(1) Points
Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
Making the payment attribute mandatory.
Creating a message to be printed on every bill that reminds the customer to pay within ten days.
Creating additional programming code to identify and report accounts past due. (*)
4. Can all constraints be modeled on an ER diagram? Mark for Review
(1) Points
No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)
No, in which case you should let the database administrator handle them
Yes, all constraints must be modeled and shown on the ER diagram
No, but you just explain them to the users so they can enforce them
5. How would you model a business rule that states that on a student's birthday, he does not have to attend his classes? Mark for Review
(1) Points
Use a supertype
You cannot model this. You need to document it (*)
Make the attribute Birthdate mandatory
Use a subtype
6. A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False? Mark for Review
(1) Points
True (*)
False
7. Why is it important to identify and document business rules? Mark for Review
(1) Points
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
8. All instances of a subtype may be an instance of the supertype but does not have to. True or False? Mark for Review
(1) Points
True
False (*)
9. A subtype can have a relationship not shared by the supertype. True or False? Mark for Review
(1) Points
True (*)
False
10. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False? Mark for Review
(1) Points
True
False (*)
11. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points
True
False (*)
12. All ER diagrams must have one of each of the following: (Choose two) Mark for Review
(1) Points
(Choose all correct answers)
At least one supertype and subtype
One or more Entities (*)
Relationships between entities (*)
Arcs
13. Which of the following is true about subtypes? Mark for Review
(1) Points
Subtypes should not be exhaustive.
Subtypes must be mutually exclusive. (*)
Subtypes must not be mutually exclusive.
One instance of a supertype may belong to two subtypes.
14. A Supertype can have only one subtype. True or False? Mark for Review
(1) Points
True
False (*)
15. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review
(1) Points
True (*)
False
(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: Mark for Review
(1) Points
Creating a message to be printed on every bill that reminds the customer to pay within ten days.
Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
Creating additional programming code to identify and report accounts past due. (*)
Making the payment attribute mandatory.
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: Mark for Review
(1) Points
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.
Making the payment attribute optional.
3. How should you handle constraints that cannot be modeled on an ER diagram? Mark for Review
(1) Points
Always let the network architect handle them
Explain them to the users so they can enforce them
All constraints must be modeled and shown on the ER diagram
List them on a separate document to be handled programmatically (*)
4. Which of the following is an example of a structural business rule? Mark for Review
(1) Points
All employees must belong to at least one department. (*)
All products will have a selling price no less than 30 % greater than wholesale.
All overdue payments will have an added 10 % late fee.
Buildings to be purchased by the business must be current with earthquake building code.
5. Can all constraints be modeled on an ER diagram? Mark for Review
(1) Points
No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)
No, in which case you should let the database administrator handle them
Yes, all constraints must be modeled and shown on the ER diagram
No, but you just explain them to the users so they can enforce them
6. Why is it important to identify and document business rules? Mark for Review
(1) Points
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
7. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points
Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
Use a supertype
Make the attribute Gender optional
Make the attribute Gender mandatory
8. A subtype can have a relationship not shared by the supertype. True or False? Mark for Review
(1) Points
True (*)
False
9. A subtype is drawn on an ERD as an entity inside the "softbox" of the supertype. True or False? Mark for Review
(1) Points
True (*)
False
10. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False? Mark for Review
(1) Points
True
False (*)
11. Which of the following is true about subtypes? Mark for Review
(1) Points
One instance of a supertype may belong to two subtypes.
Subtypes should not be exhaustive.
Subtypes must be mutually exclusive. (*)
Subtypes must not be mutually exclusive.
12. All instances of a subtype must be an instance of the supertype. True or False? Mark for Review
(1) Points
True (*)
False
13. A supertype can only have two subtypes and no more. True or False? Mark for Review
(1) Points
True
False (*)
14. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points
True
False (*)
15. A Supertype can have only one subtype. True or False? Mark for Review
(1) Points
True
False (*)
1. How would you model a business rule that states that on a student's birthday, he does not have to attend his classes? Mark for Review
(1) Points
Use a supertype
Make the attribute Birthdate mandatory
You cannot model this. You need to document it (*)
Use a subtype
2. Why is it important to identify and document business rules? Mark for Review
(1) Points
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
3.A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False? Mark for Review
(1) Points
True (*)
False
4. A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by: Mark for Review
(1) Points
Creating additional programming code to identify and report accounts past due. (*)
Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
Making the payment attribute mandatory.
Creating a message to be printed on every bill that reminds the customer to pay within ten days.
5. How should you handle constraints that cannot be modeled on an ER diagram? Mark for Review
(1) Points
Always let the network architect handle them
List them on a separate document to be handled programmatically (*)
All constraints must be modeled and shown on the ER diagram
Explain them to the users so they can enforce them
6. Why is it important to identify and document structural rules? Mark for Review
(1) Points
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.
7. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points
Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
Make the attribute Gender mandatory
Make the attribute Gender optional
Use a supertype
8. A supertype can only have two subtypes and no more. True or False? Mark for Review
(1) Points
True
False (*)
9. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review
(1) Points
True (*)
False
10. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False? Mark for Review
(1) Points
True
False (*)
11. Which of the following is true about subtypes? Mark for Review
(1) Points
Subtypes should not be exhaustive.
Subtypes must not be mutually exclusive.
Subtypes must be mutually exclusive. (*)
One instance of a supertype may belong to two subtypes.
12. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points
True
False (*)
13. A subtype can have a relationship not shared by the supertype. True or False? Mark for Review
(1) Points
True (*)
False
14. A Supertype can have only one subtype. True or False? Mark for Review
(1) Points
True
False (*)
15. All instances of a subtype must be an instance of the supertype. True or False? Mark for Review
(1) Points
True (*)
False
1. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points
Use a supertype
Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
Make the attribute Gender optional
Make the attribute Gender mandatory
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: Mark for Review
(1) Points
Making the payment attribute null.
Creating additional programming code to verify no goods are shipped until the account has been settled in full. (*)
We need to trust our customers, and we know they will pay some day.
Making the payment attribute optional.
3. A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by: Mark for Review
(1) Points
Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
Making the payment attribute mandatory.
Creating a message to be printed on every bill that reminds the customer to pay within ten days.
Creating additional programming code to identify and report accounts past due. (*)
4. Can all constraints be modeled on an ER diagram? Mark for Review
(1) Points
No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)
No, in which case you should let the database administrator handle them
Yes, all constraints must be modeled and shown on the ER diagram
No, but you just explain them to the users so they can enforce them
5. How would you model a business rule that states that on a student's birthday, he does not have to attend his classes? Mark for Review
(1) Points
Use a supertype
You cannot model this. You need to document it (*)
Make the attribute Birthdate mandatory
Use a subtype
6. A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False? Mark for Review
(1) Points
True (*)
False
7. Why is it important to identify and document business rules? Mark for Review
(1) Points
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
8. All instances of a subtype may be an instance of the supertype but does not have to. True or False? Mark for Review
(1) Points
True
False (*)
9. A subtype can have a relationship not shared by the supertype. True or False? Mark for Review
(1) Points
True (*)
False
10. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False? Mark for Review
(1) Points
True
False (*)
11. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points
True
False (*)
12. All ER diagrams must have one of each of the following: (Choose two) Mark for Review
(1) Points
(Choose all correct answers)
At least one supertype and subtype
One or more Entities (*)
Relationships between entities (*)
Arcs
13. Which of the following is true about subtypes? Mark for Review
(1) Points
Subtypes should not be exhaustive.
Subtypes must be mutually exclusive. (*)
Subtypes must not be mutually exclusive.
One instance of a supertype may belong to two subtypes.
14. A Supertype can have only one subtype. True or False? Mark for Review
(1) Points
True
False (*)
15. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review
(1) Points
True (*)
False
1. A supertype
should have at least two subtypes. True or False?
True
False
False
2.
Which of the following is a TRUE statement about the diagram below?
Every
Z is either an A or a B
Every B is a Z
Every A is a Z
Every A is a B
Every B is a Z
Every A is a Z
Every A is a B
3.
All instances of the subtypes must be an instance of the supertype. True or
False?
True
False
False
4.
A subtype can have a relationship not shared by the supertype. True or False?
True
False
False
5.
Which of the following are valid formats for an attribute?
Character string
Decimal
Number
HEX
Decimal
Number
HEX
6.
All instances of the supertype are also instances of one of the subtypes. True
or False?
True
False
False
7.
The “Other” subtype is best used:
For
instances that belong to the supertype and at least one other subtype.
For a subtype that does not have any of the same attributes as the supertype to which it belongs.
As an extra subtype to ensure that all instances of subtypes are mutually exclusive and complete. By having an “Other” subtype, all instances of the Supertype will be of one subtype type.
You should never have a subtype called Other.
For a subtype that does not have any of the same attributes as the supertype to which it belongs.
As an extra subtype to ensure that all instances of subtypes are mutually exclusive and complete. By having an “Other” subtype, all instances of the Supertype will be of one subtype type.
You should never have a subtype called Other.
8.
Which of the following is the best scenario for using supertype/subtype
entities:
A
pet store that sells small animals, because they each need different size cages
and food.
An ice cream store that sells ice cream in sugar cones and regular cones.
A grocery store that gives customers a choice of plastic or paper bags.
A vehicle dealership that sells cars, trucks and boats on trailers.
An ice cream store that sells ice cream in sugar cones and regular cones.
A grocery store that gives customers a choice of plastic or paper bags.
A vehicle dealership that sells cars, trucks and boats on trailers.
9.
When creating entities it is important to remember all of the following:
Create a formal description.
Include attributes.
Do not use synonyms.
Do use reserved words.
Include attributes.
Do not use synonyms.
Do use reserved words.
10.
Which of the following is true about supertypes and subtypes?
Instances
that belong to two subtypes of the same supertype may be modeled as a
one-to-one relationship between the two subtypes
Subtypes inherit the relationships and attributes of the supertype
Subtypes may have no more than 2 levels of nesting
Supertype and subtype entities must be mutually exclusive
Subtypes inherit the relationships and attributes of the supertype
Subtypes may have no more than 2 levels of nesting
Supertype and subtype entities must be mutually exclusive
Test: Quiz: Documenting Business Rules
1.
How would you model a business rule that states that on a studentﾒs birthday, they do not have to attend their classes?
Use
a supertype
Use a subtype
Make the attribute Birthdate mandatory
You cannot model this. You need to document it
Use a subtype
Make the attribute Birthdate mandatory
You cannot model this. You need to document it
2.
Why is it important to identify and document business rules?
It allows you to create your data model, then check 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
It allows you to improve the client’s business.
It ensures that the data model will automate all manual processes.
None of the above
3.
How should you handle constraints that cannot be modeled on an ER diagram?
Always
let the network architect handle them
List them on a separate document to be handled programmatically
Explain them to the users so they can enforce them
All constraints must be modeled and shown on the ER diagram
List them on a separate document to be handled programmatically
Explain them to the users so they can enforce them
All constraints must be modeled and shown on the ER diagram
4.
Which of the following is an example of a structural business rule?
All employees must belong to at least one department.
Buildings to be purchased by the business must be current with earthquake building code.
All overdue payments will have an added 10 % late fee.
All products will have a selling price no less than 30 % greater than wholesale.
Buildings to be purchased by the business must be current with earthquake building code.
All overdue payments will have an added 10 % late fee.
All products will have a selling price no less than 30 % greater than wholesale.
5.
A business rule such as “All accounts must be paid in full within 10 days of
billing” is best enforced by:
Making
the payment attribute mandatory.
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.
Hiring a programmer to create additional programming code to identify and report accounts past due.
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.
Hiring a programmer to create additional programming code to identify and report accounts past due.
6.
Business rules are important to data modelers because:
A. They capture all of the needs, processes and required
functionality of the business.
B. They 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.
B. They 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.
7.
Only managers can approve travel requests is an example of which of the
following?
A
structural business rule.
A mandatory business rule.
A procedural business rule.
An optional business rule.
A mandatory business rule.
A procedural business rule.
An optional business rule.
Comments
Post a Comment