Langsung ke konten utama

Section 4 Quiz Database Design Oracle

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

Komentar

  1. makasihkak deni sangat membantu semoga rejekinya semakin lancar

    BalasHapus
  2. Thank's bg deni.. God bless you whereever you are.

    BalasHapus
  3. Thank's bg deni.. God bless you whereever you are.

    BalasHapus
  4. Cool! Thank you very much, nice work!

    BalasHapus
  5. 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.

    BalasHapus
  6. Many customers think they are well worth the money, especially when it comes to the results on their hair. You not only receive the stress-free experience of passing innovative hair follicle drug tests, but you also gain shinier, healthier hair as a result. Hair that has undergone a detox treatment has the dullness removed, so you're in for a treat. Make sure you properly investigate any shampoo you're contemplating to verify that it adequately removes drug residues from your hair. Online user reviews and product descriptions can be extremely useful sources of information. However, if you don’t have enough time, here is what you can do to cleanse your hair of those toxins

    BalasHapus
  7. In addition to the above, other features should be considered when choosing Cake Boxes Wholesale.
    Custom Soap Boxes
    Custom Printed Soap Boxes
    Custom Cake Boxes

    BalasHapus
  8. wow great job with the answers

    BalasHapus

Posting Komentar

Postingan populer dari blog ini

Section 6 Quiz Oracle Database Programming with SQL

Section 6 Quiz             (Answer all questions in this section)                                                             1.         Given the following descriptions of the employees and jobs tables, which of the following scripts will display each employee ï¾’ s possible minimum and maximum salaries based on their job title? EMPLOYEES Table: Name   Null?    Type EMPLOYEE_ID          NOT NULL     NUMBER (6) FIRST_NAME             VARCHAR2 (20) LAST_NAME  NOT NULL     VARCHAR2 (25) EMAIL NOT NULL     VARCHAR2 (25) PHONE_NUMBER                  VARCHAR2 (20) HIRE_DATE   NOT NULL     DATE JOB_ID           NOT NULL     VARCHAR2 (10) SALARY                     NUMBER (8,2) COMMISSION_PCT                NUMBER (2,2) MANAGER_ID                       NUMBER (6) DEPARTMENT_ID                 NUMBER (4) JOBS Table: Name   Null?    Type JOB_ID           NOT NULL     VARCHAR2 (10) JOB_TITLE     NOT NULL     VARCHAR2 (35) MIN_SALARY                      

Section 10 Quiz Database Programming With SQL

Section 10 Quiz             (Answer all questions in this section) 1.         A multiple-row operator expects how many values?   Mark for Review (1) Points             One or more (*)             Only one             Two or more             None 2.         The salary column of the f_staffs table contains the following values: 4000 5050 6000 11000 23000 Which of the following statements will return the last_name and first_name of those employees who earn more than 5000?  Mark for Review (1) Points             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT last_name, first_name FROM f_staffs WHERE salary <5000 o:p="">             SELECT last_name, first_name FROM f_staffs WHERE salary = (SELECT salary FROM f_staffs WHERE salary < 5000);             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT salary FROM f_staffs WHERE salary > 5000); (*)             SELEC

Section 6 Quiz Database Design Oracle

Section 6 Quiz             (Answer all questions in this section) 1.         Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES:     # CLIENT ID     FIRST NAME     LAST NAME     STREET     CITY     ZIP CODE  Mark for Review (1) Points             1st Normal Form.             2nd Normal Form.             3rd Normal Form.             None of the above, the entity is fully normalised. (*) 2.         A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review (1) Points             True (*)             False 3.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review (1) Points             Functional dependency             Dependency             Transitive dependency (*)             Non-dependency