Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 47 views

    Section 4

    Uploaded by

    Ancuta Daniela
    1. Constraints that cannot be modeled on an ER diagram should be listed on a separate document to be handled programmatically. 2. It is important to identify and document business rules to create an accurate data model and check it. 3. A business rule enforcing that goods are not shipped until payment is received in full is best enforced through additional programming code.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Section 4

    Uploaded by

    Ancuta Daniela
    47 views6 pages
    1. Constraints that cannot be modeled on an ER diagram should be listed on a separate document to be handled programmatically. 2. It is important to identify and document business rules to create an accurate data model and check it. 3. A business rule enforcing that goods are not shipped until payment is received in full is best enforced through additional programming code.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. Constraints that cannot be modeled on an ER diagram should be listed on a separate document to be handled programmatically. 2. It is important to identify and document business rules to create an accurate data model and check it. 3. A business rule enforcing that goods are not shipped until payment is received in full is best enforced through additional programming code.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    47 views6 pages

    Section 4

    Uploaded by

    Ancuta Daniela
    1. Constraints that cannot be modeled on an ER diagram should be listed on a separate document to be handled programmatically. 2. It is important to identify and document business rules to create an accurate data model and check it. 3. A business rule enforcing that goods are not shipped until payment is received in full is best enforced through additional programming code.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 6

    Section 4

    (Answer all questions in this section)

    1.How should you handle constraints that cannot be modeled on an ER


    Mark for Review 
    diagram?
    (1) Points

    Always let the network architect handle them

    All constraints must be modeled and shown on the ER diagram

    Explain them to the users so they can enforce them

    List them on a separate document to be handled programmatically (*)

    Correct

    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

    Correct

    3.A business rule such as "We only ship goods after customers have
    Mark for Review 
    completely paid any outstanding balances on their account" is best
    (1) Points
    enforced by:

    Making the payment attribute optional.

    We need to trust our customers, and we know they will pay some
    day.
    Creating additional programming code to verify no goods are shipped
    until the account has been settled in full. (*)
    Making the payment attribute null.

    Correct

    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, but you just explain them to the users so they can enforce them

    Yes, all constraints must be modeled and shown on the ER diagram

    No, in which case you should let the database administrator handle
    them

    Correct

    5.How would you model a business rule that states that on a student's
    Mark for Review 
    birthday, he does not have to attend his classes?
    (1) Points

    Use a supertype

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

    Use a subtype

    Make the attribute Birthdate mandatory

    Correct
    Section 4
    (Answer all questions in this section)

    6. Which of the following


    Mark for Review 
    is an example of a
    (1) Points
    structural business
    rule?
    Buildings to be
    purchased by the
    business must be
    current with
    earthquake
    building code.
    All employees
    must belong to at
    least one
    department. (*)
    All overdue
    payments will
    have an added 10
    % late fee.
    All products will
    have a selling
    price no less than
    30 % greater than
    wholesale.

    Correct

    7. How would you model


    Mark for Review 
    a business rule that
    (1) Points
    states that girls and
    boys may not attend
    classes together?

    Use a supertype

    Make the attribute


    Gender optional
    Make the attribute
    Gender
    mandatory
    Supertype
    STUDENT has two
    subtypes BOY and
    GIRL which are
    related to
    GENDER, which is
    related to CLASS
    (*)

    Correct

    8. Which of the following


    Mark for Review 
    is true about subtypes?
    (1) Points

    One instance of a
    supertype may
    belong to two
    subtypes.
    Subtypes must be
    mutually
    exclusive. (*)
    Subtypes should
    not be exhaustive.
    Subtypes must not
    be mutually
    exclusive.

    Correct

    9. A supertype can only


    Mark for Review 
    have two subtypes and
    (1) Points
    no more. True or
    False?

    True

    False (*)

    Correct

    10.A Supertype can have


    Mark for Review 
    only one subtype. True
    (1) Points
    or False?
    True

    False (*)

    Correct
    Section 4
    (Answer all questions in this section)

    11.All ER diagrams must have one of each of


    Mark for Review 
    the following: (Choose two)
    (1) Points

    (Choose all correct answers)

    At least one supertype and subtype

    Arcs

    Relationships between entities (*)

    One or more Entities (*)

    Correct

    12.You can only create relationships to a


    Mark for Review 
    Supertype, not to a Subtype. True or False?
    (1) Points

    True

    False (*)

    Correct

    13.A subtype can have a relationship not shared


    Mark for Review 
    by the supertype. True or False?
    (1) Points
    True (*)

    False

    Correct

    14.A subtype is shown on an ERD as an entity


    Mark for Review 
    with a one to many relationship to the
    (1) Points
    supertype. True or False?

    True

    False (*)

    Correct

    15.All instances of a subtype must be an


    Mark for Review 
    instance of the supertype. True or False?
    (1) Points

    True (*)

    False

    Correct

    You might also like