DATABASE DESIGN ENGLISH SECTION 9

1. The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column Mark for Review
(1) Points


Entity integrity


Referential integrity


User-defined integrity


Column integrity (*)



Correct Correct


2. Column integrity refers to Mark for Review
(1) Points


Columns always having values


Columns always containing text data less than 255 characters


Columns always containing positive numbers


Columns always containing values consistent with the defined data format (*)



Correct Correct


3. The explanation below is an example of which constraint type?
The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table. Mark for Review
(1) Points


Column integrity


Referential integrity (*)


Entity integrity


User-defined integrity



Correct Correct


4. Foreign keys cannot be null when Mark for Review
(1) Points


It is part of a primary key (*)


It contains three or more columns


It refers to the same table


It refers to another table



Correct Correct


5. Why would this table name NOT work in an Oracle database? this_year_end+next_year Mark for Review
(1) Points


Table names must begin with an alphabetic character.


It is too long.


The Plus sign + is not allowed in object names. (*)


None of the above.



Correct Correct
6. In a physical data model, an entity becomes a _____________. Mark for Review
(1) Points


Table (*)


Attribute


Constraint


Column



Correct Correct


7. The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


8. In a physical data model, a relationship is represented as a: Mark for Review
(1) Points


Column


Unique Identifier


Primary Key


Foreign Key (*)



Correct Correct


9. Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on: Mark for Review
(1) Points


Both tables A and B get a new column and a Foreign Key.


The table B (*)


Nowhere, One-to-One relationships are not transformed.


The table A



Correct Correct


10. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct
11. The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


12. A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
(1) Points


The Column Name


The Check Constraint


The Primary Key (*)


The Table Name



Correct Correct


13. An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


14. Which of the following is a valid reason for considering a Subtype Implementation? Mark for Review
(1) Points


Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)


The resulting table will reside in a single database and be used by just ONE user.


The common access paths for the supertypes are different.


Most of the relationships are at the supertype level.



Correct Correct


15. When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


Make all relationships mandatory


Make all relationships optional (*)


Create an additional check constraint to verify that one foreign key is populated and the others are not (*)


All the above



Correct Correct
1.         When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)     Mark for Review
(1) Points
                                    (Choose all correct answers)
            Make all relationships mandatory
            Make all relationships optional (*)

            Create an additional check constraint to verify that one foreign key is populated and the others are not (*)

            All the above


2.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
(1) Points
            The common access paths for the supertypes are different.
            The resulting table will reside in a single database and be used by just ONE user.

            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)

            Most of the relationships are at the supertype level.

3.         When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?  Mark for Review
(1) Points
            True
            False (*)

4.         In an Oracle database, why would 1_TABLE not work as a table name?     Mark for Review
(1) Points
            The database does not understand all capital letters.
            TABLE is a reserved word.
            There is no problem here. You can create a table called 1_TABLE.
            Object names must not start with a number. They must begin with a letter. (*)

5.         In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?            Mark for Review
(1) Points
            The database does not understand all capital letters
            JOBS is a reserved word
            EMPLOYEE is a reserved word
            You cannot have spaces between words in a table name (*)

6.         Why would this table name NOT work in an Oracle database? this_year_end+next_year   Mark for Review
(1) Points
            Table names must begin with an alphabetic character.
            It is too long.
            The Plus sign + is not allowed in object names. (*)
            None of the above.

7.         In a physical data model, an attribute becomes a _____________.   Mark for Review
(1) Points
            Constraint
            Table
            Foreign Key
            Column (*)

8.         To resolve a many to many relationship in a physical model you create a(n) ___________________?            Mark for Review
(1) Points
            Unique key constraints
            Intersection entity
            Intersection table (*)
            Two tables with Foreign key constraints between them

9.         When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Key. True or False?    Mark for Review
(1) Points
            True
            False (*)

10.       The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False?           Mark for Review
(1) Points
            True
            False (*)

11.       A barrred Relationship will result in a Foreign Key column that also is part of:        Mark for Review
(1) Points
            The Primary Key (*)
            The Column Name
            The Check Constraint
            The Table Name

12.       Column integrity refers to       Mark for Review
(1) Points
            Columns always containing positive numbers
            Columns always containing values consistent with the defined data format (*)
            Columns always containing text data less than 255 characters
            Columns always having values

13. The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column            Mark for Review
(1) Points
            Column integrity (*)
            User-defined integrity
            Referential integrity
            Entity integrity

14.       Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
(1) Points
                                    (Choose all correct answers)
            Only one column that must be null. (*)
            A single column that uniquely identifies each column in a table. (*)
            One or more columns in a table that uniquely identifies each row in that table.
            A set of columns in one table that uniquely identifies each row in another table. (*)

15.       Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three)            Mark for Review
(1) Points
                                    (Choose all correct answers)
            Only one column that cannot be null

            A set of columns and keys in a single table that uniquely identifies each row in a single table (*)

            A single column that uniquely identifies each row in a table (*)
            A set of columns that uniquely identifies each row in a table (*)

1.         The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column            Mark for Review
(1) Points
            User-defined integrity
            Column integrity (*)
            Referential integrity
            Entity integrity

2.         Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three)            Mark for Review
(1) Points
                                    (Choose all correct answers)

            A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
            Only one column that cannot be null
            A single column that uniquely identifies each row in a table (*)
            A set of columns that uniquely identifies each row in a table (*)

3.         Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
(1) Points
                                    (Choose all correct answers)
            A single column that uniquely identifies each column in a table. (*)
            One or more columns in a table that uniquely identifies each row in that table.
            Only one column that must be null. (*)
            A set of columns in one table that uniquely identifies each row in another table. (*)

4. Foreign keys cannot be null when  Mark for Review
(1) Points
            It refers to another table
            It is part of a primary key (*)
            It contains three or more columns
            It refers to the same table

5.         When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?  Mark for Review
(1) Points
            True
            False (*)

6.         When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?            Mark for Review
(1) Points
            True (*)
            False

7.         The "Arc Implementation" is a synonym for what type of implementation? Mark for Review
(1) Points
            Supertype and Subtype Implementation (*)
            Cascade Implementation
            Supertype Implementation
            Subtype Implementation

8.         The Physical model is created by transforming which of the following models?      Mark for Review
(1) Points
            Constraint
            Table
            Physical
            Conceptual (*)

9.         Why would this table name NOT work in an Oracle database? this_year_end+next_year   Mark for Review
(1) Points
            Table names must begin with an alphabetic character.
            It is too long.
            The Plus sign + is not allowed in object names. (*)
            None of the above.

10.       In an Oracle database, why would 1_TABLE not work as a table name?     Mark for Review
(1) Points
            There is no problem here. You can create a table called 1_TABLE.
            The database does not understand all capital letters.
            TABLE is a reserved word.
            Object names must not start with a number. They must begin with a letter. (*)

11.       Attributes become columns in a database table. True or False?         Mark for Review
(1) Points
            True (*)
            False

12.       Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?            Mark for Review
(1) Points
            True
            False (*)

13.       An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False?  Mark for Review
(1) Points
            True (*)
            False

14.       One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?          Mark for Review
(1) Points
            True
            False (*)

15.       One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False?     Mark for Review
(1) Points
            True
            False (*)

1.         When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?  Mark for Review
(1) Points
            True
            False (*)

2.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
(1) Points
            The common access paths for the supertypes are different.

            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)

            Most of the relationships are at the supertype level.
            The resulting table will reside in a single database and be used by just ONE user.

3.         The "Arc Implementation" is a synonym for what type of implementation? Mark for Review
(1) Points
            Supertype and Subtype Implementation (*)
            Supertype Implementation
            Cascade Implementation
            Subtype Implementation

4.         In a physical data model, an attribute becomes a _____________.   Mark for Review
(1) Points
            Constraint
            Column (*)
            Table
            Foreign Key
                                                         
5.The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?          Mark for Review
(1) Points
            True (*)
            False

6.         In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?            Mark for Review
(1) Points
            The database does not understand all capital letters
            JOBS is a reserved word
            You cannot have spaces between words in a table name (*)
            EMPLOYEE is a reserved word

7. In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
(1) Points
            There is no problem here. You can create a table called 1_TABLE.
            Object names must not start with a number. They must begin with a letter. (*)
            The database does not understand all capital letters.
            TABLE is a reserved word.

8.         When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Key. True or False?    Mark for Review
(1) Points
            True
            False (*)

9.         One-to-Many Optional to Mandatory becomes a _______________ on the Master table.   Mark for Review
(1) Points
            Optional Foreign Key (*)
            Unique Key
            Primary Key
            Mandatory Foreign Key

10.       An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False?  Mark for Review
(1) Points
            True (*)
            False

11.       A barrred Relationship will result in a Foreign Key column that also is part of:        Mark for Review
(1) Points
            The Check Constraint
            The Column Name
            The Table Name
            The Primary Key (*)

12.       Foreign keys must be null. True or False?       Mark for Review
(1) Points
            True
            False (*)

13.       The explanation below is an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null.  Mark for Review
(1) Points
            Column integrity
            User-defined integrity
            Referential integrity
            Entity integrity (*)

14.       Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
(1) Points
                                    (Choose all correct answers)
            A set of columns in one table that uniquely identifies each row in another table. (*)
            One or more columns in a table that uniquely identifies each row in that table.
            Only one column that must be null. (*)
            A single column that uniquely identifies each column in a table. (*)

15.       A foreign key always refers to a primary key in the same table. True or False?         Mark for Review
(1) Points
            True
            False (*)

1.         The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?      Mark for Review
(1) Points
            True (*)
            False

2. In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?       Mark for Review
(1) Points
            You cannot have spaces between words in a table name (*)
            The database does not understand all capital letters
            EMPLOYEE is a reserved word
            JOBS is a reserved word

3.         Attributes become columns in a database table. True or False?         Mark for Review
(1) Points
            True (*)
            False

4. The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ :     Mark for Review
(1) Points
            Unique Keys
            Tables (*)
            Columns
            Foreign Keys

5.         Foreign keys must be null. True or False?       Mark for Review
(1) Points
            True
            False (*)

6.         A table does not have to have a primary key. True or False? Mark for Review
(1) Points
            True (*)
            False

7.         The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.     Mark for Review
(1) Points
            Column integrity
            Referential integrity
            Entity integrity
            User-defined integrity (*)

8.         Column integrity refers to       Mark for Review
(1) Points
            Columns always containing text data less than 255 characters
            Columns always containing positive numbers
            Columns always containing values consistent with the defined data format (*)
            Columns always having values

9.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
(1) Points
            The resulting table will reside in a single database and be used by just ONE user.
            The common access paths for the supertypes are different.
            Most of the relationships are at the supertype level.

            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)

10.       An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?  Mark for Review
(1) Points
            True
            False (*)

11.       When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?            Mark for Review
(1) Points
            True (*)
            False

12.       To resolve a many to many relationship in a physical model you create a(n) ___________________?            Mark for Review
(1) Points
            Two tables with Foreign key constraints between them
            Intersection table (*)
            Unique key constraints
            Intersection entity

13.       Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?            Mark for Review
(1) Points
            True
            False (*)

14.       The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False?           Mark for Review
(1) Points
            True
            False (*)

15.       One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?          Mark for Review
(1) Points
            True
            False (*)

1.         When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?            Mark for Review
(1) Points
            True (*)
            False

2.         When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?  Mark for Review
(1) Points
            True
            False (*)

3.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
(1) Points

            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)

            Most of the relationships are at the supertype level.
            The common access paths for the supertypes are different.
            The resulting table will reside in a single database and be used by just ONE user.

4.         The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column            Mark for Review
(1) Points
            Column integrity (*)
            User-defined integrity
            Entity integrity
            Referential integrity

5.         A table must have a primary key. True or False?        Mark for Review
(1) Points
            True
            False (*)

6.         Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
(1) Points
                                    (Choose all correct answers)
            A single column that uniquely identifies each column in a table. (*)
            A set of columns in one table that uniquely identifies each row in another table. (*)
            Only one column that must be null. (*)
            One or more columns in a table that uniquely identifies each row in that table.

7.         The explanation below is an example of which constraint type?
The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table.         Mark for Review
(1) Points
            Referential integrity (*)
            Column integrity
            User-defined integrity
            Entity integrity

8.         In a physical model, many to many relationships are resolved via a structure called a(n): ________________    Mark for Review
(1) Points
            Intersection Entity
            Intersection Table (*)
            Subtype
            Supertype

9.         To resolve a many to many relationship in a physical model you create a(n) ___________________?            Mark for Review
(1) Points
            Two tables with Foreign key constraints between them
            Intersection entity
            Intersection table (*)
            Unique key constraints

10.       A barrred Relationship will result in a Foreign Key column that also is part of:        Mark for Review
(1) Points
            The Check Constraint
            The Column Name
            The Primary Key (*)
            The Table Name

11.       Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?            Mark for Review
(1) Points
            True
            False (*)

12.       Attributes become columns in a database table. True or False?         Mark for Review
(1) Points
            True (*)
            False

13.       Why would this table name NOT work in an Oracle database? this_year_end+next_year   Mark for Review
(1) Points
            Table names must begin with an alphabetic character.
            It is too long.
            The Plus sign + is not allowed in object names. (*)
            None of the above.

14.       In an Oracle database, why would 1_TABLE not work as a table name?     Mark for Review
(1) Points
            TABLE is a reserved word.
            There is no problem here. You can create a table called 1_TABLE.
            The database does not understand all capital letters.
            Object names must not start with a number. They must begin with a letter. (*)

15.       In a physical data model, an attribute becomes a _____________.   Mark for Review
(1) Points
            Constraint
            Table
            Foreign Key

            Column (*)

1.  The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column  Mark for Review
(1) Points
   
 
 Entity integrity

 
 Column integrity (*)

 
 Referential integrity

 
 User-defined integrity

   
 
Correct  Correct

   
  2.  Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 One or more columns in a table that uniquely identifies each row in that table.

 
 Only one column that must be null. (*)

 
 A single column that uniquely identifies each column in a table. (*)

 
 A set of columns in one table that uniquely identifies each row in another table. (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 1.

   
  3.  A table does not have to have a primary key. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  4.  A foreign key always refers to a primary key in the same table. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  5.  When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 Make all relationships mandatory

 
 Make all relationships optional (*)

 
 Create an additional check constraint to verify that one foreign key is populated and the others are not (*)

 
 All the above

   
 
Correct  Correct

   
Page 1 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  6.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  7.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 4.

   
  8.  In a physical model, many to many relationships are resolved via a structure called a(n): ________________  Mark for Review
(1) Points
   
 
 Intersection Table

 
 Subtype

 
 Intersection Entity (*)

 
 Supertype

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 3.

   
  9.  One-to-Many Optional to Mandatory becomes a _______________ on the Master table.  Mark for Review
(1) Points
   
 
 Unique Key

 
 Optional Foreign Key (*)

 
 Mandatory Foreign Key

 
 Primary Key

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 3.

   
  10.  It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 3.

   
Previous Page 2 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  11.  An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  12.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  13.  The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ :  Mark for Review
(1) Points
   
 
 Columns

 
 Tables (*)

 
 Unique Keys

 
 Foreign Keys

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
  14.  In a physical data model, an attribute becomes a _____________.  Mark for Review
(1) Points
   
 
 Foreign Key

 
 Constraint

 
 Column (*)

 
 Table

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
  15.  In a physical data model, a relationship is represented as a:  Mark for Review
(1) Points
   
 
 Column

 
 Foreign Key (*)

 
 Unique Identifier

 
 Primary Key

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
Previous Page 3 of 3 Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  1.  A table does not have to have a primary key. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  2.  Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 A set of columns that uniquely identifies each row in a table (*)

 
 A single column that uniquely identifies each row in a table (*)

 
 A set of columns and keys in a single table that uniquely identifies each row in a single table (*)

 
 Only one column that cannot be null

   
 
Correct  Correct

   
  3.  The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.  Mark for Review
(1) Points
   
 
 User-defined integrity (*)

 
 Entity integrity

 
 Referential integrity

 
 Column integrity

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 1.

   
  4.  The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column  Mark for Review
(1) Points
   
 
 Entity integrity

 
 Column integrity (*)

 
 Referential integrity

 
 User-defined integrity

   
 
Correct  Correct

   
  5.  One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
Page 1 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  6.  To resolve a many to many relationship in a physical model you create a(n) ___________________?  Mark for Review
(1) Points
   
 
 Two tables with Foreign key constraints between them

 
 Unique key constraints

 
 Intersection entity

 
 Intersection table (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 3.

   
  7.  It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  8.  The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 3.

   
  9.  Why would this table name NOT work in an Oracle database? this_year_end+next_year  Mark for Review
(1) Points
   
 
 Table names must begin with an alphabetic character.

 
 It is too long.

 
 The Plus sign + is not allowed in object names. (*)

 
 None of the above.

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
  10.  In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 Column

 
 Check Constraint or Unique Key

 
 Primary Key or Unique Key (*)

 
 Foreign Key (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
Previous Page 2 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  11.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  12.  In a physical data model, an attribute becomes a _____________.  Mark for Review
(1) Points
   
 
 Constraint

 
 Table

 
 Column (*)

 
 Foreign Key

   
 
Correct  Correct

   
  13.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 4.

   
  14.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  15.  Which of the following is a valid reason for considering a Subtype Implementation?  Mark for Review
(1) Points
   
 
 Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)

 
 The resulting table will reside in a single database and be used by just ONE user.

 
 The common access paths for the supertypes are different.

 
 Most of the relationships are at the supertype level.

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 4.

   
Previous Page 3 of 3 Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  1.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  2.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  3.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  4.  An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  5.  Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 3.

   
Page 1 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  6.  One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  7.  A barrred Relationship will result in a Foreign Key column that also is part of:  Mark for Review
(1) Points
   
 
 The Primary Key (*)

 
 The Check Constraint

 
 The Column Name

 
 The Table Name

   
 
Correct  Correct

   
  8.  The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.  Mark for Review
(1) Points
   
 
 Referential integrity

 
 User-defined integrity (*)

 
 Entity integrity

 
 Column integrity

   
 
Correct  Correct

   
  9.  The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column  Mark for Review
(1) Points
   
 
 Entity integrity

 
 Referential integrity

 
 User-defined integrity

 
 Column integrity (*)

   
 
Correct  Correct

   
  10.  The explanation below is an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null.  Mark for Review
(1) Points
   
 
 Entity integrity (*)

 
 Column integrity

 
 User-defined integrity

 
 Referential integrity

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 1.

   
Previous Page 2 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  11.  A foreign key always refers to a primary key in the same table. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  12.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  13.  In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 Check Constraint or Unique Key

 
 Foreign Key (*)

 
 Column

 
 Primary Key or Unique Key (*)

   
 
Correct  Correct

   
  14.  In a physical data model, an attribute becomes a _____________.  Mark for Review
(1) Points
   
 
 Foreign Key

 
 Constraint

 
 Table

 
 Column (*)

   
 
Correct  Correct

   
  15.  In an Oracle database, why would 1_TABLE not work as a table name?  Mark for Review
(1) Points
   
 
 There is no problem here. You can create a table called 1_TABLE.

 
 TABLE is a reserved word.

 
 The database does not understand all capital letters.

 
 Object names must not start with a number. They must begin with a letter. (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
Previous Page 3 of 3 Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  1.  The explanation below is an example of which constraint type?
The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table.  Mark for Review
(1) Points
   
 
 Column integrity

 
 User-defined integrity

 
 Referential integrity (*)

 
 Entity integrity

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 1.

   
  2.  The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.  Mark for Review
(1) Points
   
 
 User-defined integrity (*)

 
 Referential integrity

 
 Column integrity

 
 Entity integrity

   
 
Correct  Correct

   
  3.  Foreign keys must be null. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 1.

   
  4.  Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 A set of columns and keys in a single table that uniquely identifies each row in a single table (*)

 
 Only one column that cannot be null

 
 A single column that uniquely identifies each row in a table (*)

 
 A set of columns that uniquely identifies each row in a table (*)

   
 
Correct  Correct

   
  5.  One-to-Many Optional to Mandatory becomes a _______________ on the Master table.  Mark for Review
(1) Points
   
 
 Primary Key

 
 Optional Foreign Key (*)

 
 Mandatory Foreign Key

 
 Unique Key

   
 
Correct  Correct

   
Page 1 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  6.  A barrred Relationship will result in a Foreign Key column that also is part of:  Mark for Review
(1) Points
   
 
 The Column Name

 
 The Table Name

 
 The Primary Key (*)

 
 The Check Constraint

   
 
Correct  Correct

   
  7.  Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on:  Mark for Review
(1) Points
   
 
 The table B (*)

 
 Both tables A and B get a new column and a Foreign Key.

 
 Nowhere, One-to-One relationships are not transformed.

 
 The table A

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 3.

   
  8.  To resolve a many to many relationship in a physical model you create a(n) ___________________?  Mark for Review
(1) Points
   
 
 Intersection table (*)

 
 Unique key constraints

 
 Two tables with Foreign key constraints between them

 
 Intersection entity

   
 
Correct  Correct

   
  9.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  10.  The "Arc Implementation" is a synonym for what type of implementation?  Mark for Review
(1) Points
   
 
 Subtype Implementation

 
 Supertype and Subtype Implementation (*)

 
 Supertype Implementation

 
 Cascade Implementation

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 4.

   
Previous Page 2 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  11.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  12.  In an Oracle database, why would 1_TABLE not work as a table name?  Mark for Review
(1) Points
   
 
 TABLE is a reserved word.

 
 There is no problem here. You can create a table called 1_TABLE.

 
 Object names must not start with a number. They must begin with a letter. (*)

 
 The database does not understand all capital letters.

   
 
Correct  Correct

   
  13.  In a physical data model, a relationship is represented as a:  Mark for Review
(1) Points
   
 
 Foreign Key (*)

 
 Unique Identifier

 
 Primary Key

 
 Column

   
 
Correct  Correct

   
  14.  In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?  Mark for Review
(1) Points
   
 
 EMPLOYEE is a reserved word

 
 The database does not understand all capital letters

 
 JOBS is a reserved word

 
 You cannot have spaces between words in a table name (*)

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
  15.  The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ :  Mark for Review
(1) Points
   
 
 Foreign Keys

 
 Tables (*)

 
 Columns

 
 Unique Keys

   
 
Correct  Correct

   
Previous Page 3 of 3 Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  1.  In an Oracle database, why would 1_TABLE not work as a table name?  Mark for Review
(1) Points
   
 
 TABLE is a reserved word.

 
 Object names must not start with a number. They must begin with a letter. (*)

 
 There is no problem here. You can create a table called 1_TABLE.

 
 The database does not understand all capital letters.

   
 
Correct  Correct

   
  2.  In a physical data model, an entity becomes a _____________.  Mark for Review
(1) Points
   
 
 Attribute

 
 Table (*)

 
 Column

 
 Constraint

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 2.

   
  3.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  4.  In a physical data model, an attribute becomes a _____________.  Mark for Review
(1) Points
   
 
 Constraint

 
 Table

 
 Column (*)

 
 Foreign Key

   
 
Correct  Correct

   
  5.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
Page 1 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  6.  When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 Make all relationships mandatory

 
 Make all relationships optional (*)

 
 Create an additional check constraint to verify that one foreign key is populated and the others are not (*)

 
 All the above

   
 
Correct  Correct

   
  7.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  8.  A barrred Relationship will result in a Foreign Key column that also is part of:  Mark for Review
(1) Points
   
 
 The Primary Key (*)

 
 The Check Constraint

 
 The Table Name

 
 The Column Name

   
 
Correct  Correct

   
  9.  The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  10.  One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
Previous Page 2 of 3 Next Summary


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

 Section 9 Quiz
 (Answer all questions in this section)
   
  11.  Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on:  Mark for Review
(1) Points
   
 
 Nowhere, One-to-One relationships are not transformed.

 
 The table B (*)

 
 Both tables A and B get a new column and a Foreign Key.

 
 The table A

   
 
Correct  Correct

   
  12.  Foreign keys cannot be null when  Mark for Review
(1) Points
   
 
 It refers to the same table

 
 It contains three or more columns

 
 It is part of a primary key (*)

 
 It refers to another table

   
 
Correct  Correct

   
  13.  The explanation below is an example of which constraint type?
A column must contain only values consistent with the defined data format of the column  Mark for Review
(1) Points
   
 
 Column integrity (*)

 
 Referential integrity

 
 Entity integrity

 
 User-defined integrity

   
 
Correct  Correct

   
  14.  The explanation below is an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null.  Mark for Review
(1) Points
   
 
 User-defined integrity

 
 Column integrity

 
 Entity integrity (*)

 
 Referential integrity

   
 
Incorrect  Incorrect. Refer to Section 9 Lesson 1.

   
  15.  Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 Only one column that must be null. (*)

 
 A set of columns in one table that uniquely identifies each row in another table. (*)

 
 One or more columns in a table that uniquely identifies each row in that table.

 
 A single column that uniquely identifies each column in a table. (*)

   
 
Correct  Correct

   
Previous Page 3 of 3 Summary

Read More

DATABASE DESIGN ENGLISH SECTION 8

Section 8 Quiz
                (Answer all questions in this section)

1.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                BABY and AGE
                CUSTOMER and ORDERS (*)
                TEACHER and AGE
                CUSTOMER and PAYMENTS (*)

2.            When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?         Mark for Review
(1) Points
                True
                False (*)

3.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                LIBRARY and BOOK (*)
                STUDENT and GRADE (*)
                STUDENT and AGE
                LIBRARY and NUMBER OF BOOKS

4.            Which of the following statements are true for ERD's to enhance their readability. (Choose Two)              Mark for Review
(1) Points
                                                (Choose all correct answers)    

                You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.

                The crows feet (many ends) can point whichever way is the easiest to draw.

                Avoid crossing one relationship line with another. (*)

                It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)

5.            No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

6.            You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?             Mark for Review
(1) Points
                True
                False (*)

7. Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?        Mark for Review
(1) Points
                True
                False (*)

8.            All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
(1) Points
                True
                False (*)

9.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points
                End Date must be before the Start Date.
                EMPLOYEE periods can overlap causing the database to crash.
                Dates must be stored with Time.

                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)

10.          What is the function of logging or journaling in conceptual data models?               Mark for Review
(1) Points
                Represents entities as time in the data model.
                Creates a fixed time for all events in a data model.
                Gives a timestamp to all entities.
                Allows you to track the history of attribute values, relationships, and/or entire entities (*)

11.          How do you know when to use the different types of time in your design?          Mark for Review
(1) Points
                It depends on the functional needs of the system . (*)
                Always model time; you can take it out later if it is not needed.
                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
                The rules are fixed and should be followed.

12.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
(1) Points
                If you are doing a system for France or Germany, you would need security clearance.
                Daily traffic patterns must be monitored to determine which countries are overcrowded.
                Countries may change their names and/or borders over a period of time. (*)
                People have births and deaths in their countries that must be tracked by the system.

13.          In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?             Mark for Review
(1) Points
                True (*)
                False

14.          Modeling historical data is optional. True or False?           Mark for Review
(1) Points
                True (*)
                False

15.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Transferable Relationship
                Non-transferable Relationship.
                Conditional Non-transferable Relationship. (*)
                Arc.

1.            You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?             Mark for Review
(1) Points
                True
                False (*)

2.            Which of the following statements are true for ERD's to enhance their readability. (Choose Two)              Mark for Review
(1) Points
                                                (Choose all correct answers)    
                You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.

                It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)

                The crows feet (many ends) can point whichever way is the easiest to draw.

                Avoid crossing one relationship line with another. (*)

3.            In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?       Mark for Review
(1) Points
                True (*)
                False

4.            There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False?      Mark for Review
(1) Points
                True
                False (*)

5.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                CUSTOMER and ORDERS (*)
                CUSTOMER and PAYMENTS (*)
                TEACHER and AGE
                BABY and AGE

6.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                LIBRARY and NUMBER OF BOOKS
                STUDENT and GRADE (*)
                LIBRARY and BOOK (*)
                STUDENT and AGE

7.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
(1) Points
                True (*)
                False

8.            In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?             Mark for Review
(1) Points
                True (*)
                False

9.            Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
(1) Points
                If you are doing a system for any French City, you would need security clearance.
                People are born in the city and people die in the city.

                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

                Cites may change their names and/or country association if the borders of a country change. (*)

10.          When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
(1) Points
                True (*)
                False

11.          If you have an entity with a DATE attribute, in addition to other attributes that track date characteristics, you should create a DAY entity. True or False?            Mark for Review
(1) Points
                True (*)
                False

12.          There are no circumstances where you would create a DAY entity. True or False?             Mark for Review
(1) Points
                True
                False (*)

13.          You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?           Mark for Review
(1) Points

                Email current prices to all employees whenever a price changes.

                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.

                Allow them to enter whatever delivery charge they want.

                Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)

14.          Why would you want to model a time component when designing a system that lets people buy bars of gold?     Mark for Review
(1) Points
                The Government of your country might want to be notified of this transaction.
                You would not want to model this; it is not important.

                The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)

                Sales people must determine where the gold is coming from.

15.          All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
(1) Points
                True
                False (*)

1.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                LIBRARY and BOOK (*)
                STUDENT and AGE
                LIBRARY and NUMBER OF BOOKS
                STUDENT and GRADE (*)

2.            When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?         Mark for Review
(1) Points
                True
                False (*)

3.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                CUSTOMER and PAYMENTS (*)
                CUSTOMER and ORDERS (*)
                BABY and AGE
                TEACHER and AGE

4.            When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Transferable Relationship
                Non-transferable Relationship.
                Conditional Non-transferable Relationship. (*)
                Arc.

5.            All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False?        Mark for Review
(1) Points
                True
                False (*)

6.            In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?             Mark for Review
(1) Points
                True (*)
                False

7.            When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
(1) Points
                True (*)
                False

8.            If you have an entity that a DATE attribute, and other attributes that track characteristics of the date, you should create a DAY entity. True or False?            Mark for Review
(1) Points
                True (*)
                False

9.            In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?       Mark for Review
(1) Points
                True (*)
                False

10.          There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False?      Mark for Review
(1) Points
                True
                False (*)

11.          No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

12.          In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
(1) Points
                True
                False (*)

13.          You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?           Mark for Review
(1) Points
                Email current prices to all employees whenever a price changes.

                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.

                Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)

                Allow them to enter whatever delivery charge they want.

14.          Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points
                EMPLOYEE periods can overlap causing the database to crash.
                Dates must be stored with Time.
                End Date must be before the Start Date.

                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)

15.          Why would you want to model a time component when designing a system that lets people buy bars of gold?     Mark for Review
(1) Points
                You would not want to model this; it is not important.
                The Government of your country might want to be notified of this transaction.

                The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)

                Sales people must determine where the gold is coming from.

1.            You are doing a data model for a computer sales company where the price fluctuates on a regular basis. If you want to allow the company to modify the price and keep track of the changes, what is the best way to model this?      Mark for Review
(1) Points

                A. Create a product entity and a related price entity with start and end dates, and then let the users enter the new price whenever required.
                B. Create a new item and a new price every day.
                C. Use a price entity with a start and end date
                D. Allow them to delete the item and enter a new one.
                E. Both A and C (*)

2.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points

                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)

                Dates must be stored with Time.
                End Date must be before the Start Date.
                EMPLOYEE periods can overlap causing the database to crash.

3.            You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?           Mark for Review
(1) Points

                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.

                Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)

                Email current prices to all employees whenever a price changes.
                Allow them to enter whatever delivery charge they want.

4. Historical data must never be kept. True or False?       Mark for Review
(1) Points
                True
                False (*)

5.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
(1) Points
                True (*)
                False

6.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                BABY and AGE
                TEACHER and AGE
                CUSTOMER and ORDERS (*)
                CUSTOMER and PAYMENTS (*)

7.            In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
(1) Points
                True
                False (*)

8.            No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

9.            Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?   Mark for Review
(1) Points
                True
                False (*)

10.          Which of the following statements are true to enhance the readability of ERDs? (Choose Two)  Mark for Review
(1) Points
                                                (Choose all correct answers)    
                Crossing relationship lines help the readability of the diagram.

                Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)

                Relationship lines should not cross. (*)

                It does not matter which way the crows feet (many ends of a relationship) point.

11.          Modeling historical data is optional. True or False?           Mark for Review
(1) Points
                True (*)
                False

12.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Conditional Non-transferable Relationship. (*)
                Arc.
                Transferable Relationship
                Non-transferable Relationship.

13.          When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
(1) Points
                True (*)
                False

14.          All systems must have an entity called WEEK with a holiday attribute so that you know when to give employees a holiday. True or False?        Mark for Review
(1) Points
                True
                False (*)

15.          How do you know when to use the different types of time in your design?          Mark for Review
(1) Points

                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.

                The rules are fixed and should be followed.
                Always model time; you can take it out later if it is not needed.
                It depends on the functional needs of the system . (*)

1.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                STUDENT and GRADE (*)
                STUDENT and AGE
                LIBRARY and BOOK (*)
                LIBRARY and NUMBER OF BOOKS

2.            When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?         Mark for Review
(1) Points
                True
                False (*)

3.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
(1) Points
                True (*)
                False

4.            All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
(1) Points
                True
                False (*)

5.            You are doing a data model for a computer sales company where the price fluctuates on a regular basis. If you want to allow the company to modify the price and keep track of the changes, what is the best way to model this?      Mark for Review
(1) Points

                A. Create a product entity and a related price entity with start and end dates, and then let the users enter the new price whenever required.
                B. Create a new item and a new price every day.
                C. Use a price entity with a start and end date
                D. Allow them to delete the item and enter a new one.
                E. Both A and C (*)

6.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
(1) Points
                End Date must be before the Start Date.
                EMPLOYEE periods can overlap causing the database to crash.
                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
                Dates must be stored with Time.

7.            Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?   Mark for Review
(1) Points
                True
                False (*)

8.            In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
(1) Points
                True
                False (*)

9.            In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?       Mark for Review
(1) Points
                True (*)
                False

10.          No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?              Mark for Review
(1) Points
                True (*)
                False

11.          How do you know when to use the different types of time in your design?          Mark for Review
(1) Points

                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
                Always model time; you can take it out later if it is not needed.
                The rules are fixed and should be followed.
                It depends on the functional needs of the system . (*)

12.          All systems must have an entity called WEEK with a holiday attribute so that you know when to give employees a holiday. True or False?        Mark for Review
(1) Points
                True
                False (*)

13.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
(1) Points
                Conditional Non-transferable Relationship. (*)
                Transferable Relationship
                Non-transferable Relationship.
                Arc.

14.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
(1) Points
                Daily traffic patterns must be monitored to determine which countries are overcrowded.
                Countries may change their names and/or borders over a period of time. (*)
                People have births and deaths in their countries that must be tracked by the system.
                If you are doing a system for France or Germany, you would need security clearance.

15.          Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
(1) Points

                Cites may change their names and/or country association if the borders of a country change. (*)

                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

                People are born in the city and people die in the city.


                If you are doing a system for any French City, you would need security clearance.
1.  In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  2.  If you have an entity that a DATE attribute, and other attributes that track characteristics of the date, you should create a DAY entity. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  3.  Modeling historical data is optional. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 2.

   
  4.  All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 2.

   
  5.  How do you know when to use the different types of time in your design?  Mark for Review
(1) Points
   
 
 It depends on the functional needs of the system . (*)

 
 Always model time; you can take it out later if it is not needed.

 
 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.

 
 The rules are fixed and should be followed.

   
 
Correct  Correct

   
Page 1 of 3 Next Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  6.  Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 4.

   
  7.  In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  8.  In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 4.

   
  9.  You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 4.

   
  10.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 TEACHER and AGE

 
 CUSTOMER and ORDERS (*)

 
 CUSTOMER and PAYMENTS (*)

 
 BABY and AGE

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 1.

   
Previous Page 2 of 3 Next Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  11.  When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 1.

   
  12.  Historical data must never be kept. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 1.

   
  13.  You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this? Mark for Review
(1) Points
   
 
 Email current prices to all employees whenever a price changes.

 
 Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)

 
 Allow them to enter whatever delivery charge they want.

 
 Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 3.

   
  14.  What is the function of logging or journaling in conceptual data models?  Mark for Review
(1) Points
   
 
 Creates a fixed time for all events in a data model.

 
 Gives a timestamp to all entities.

 
 Allows you to track the history of attribute values, relationships, and/or entire entities (*)

 
 Represents entities as time in the data model.

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 3.

   
  15.  When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
Previous Page 3 of 3 Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  1.  What is the function of logging or journaling in conceptual data models?  Mark for Review
(1) Points
   
 
 Gives a timestamp to all entities.

 
 Creates a fixed time for all events in a data model.

 
 Represents entities as time in the data model.

 
 Allows you to track the history of attribute values, relationships, and/or entire entities (*)

   
 
Correct  Correct

   
  2.  Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?  Mark for Review
(1) Points
   
 
 An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)

 
 EMPLOYEE periods can overlap causing the database to crash.

 
 End Date must be before the Start Date.

 
 Dates must be stored with Time.

   
 
Correct  Correct

   
  3.  When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  4.  When a relationship may or may not be transferable, depending on time, this is know as a/an: Mark for Review
(1) Points
   
 
 Arc.

 
 Transferable Relationship

 
 Conditional Non-transferable Relationship. (*)

 
 Non-transferable Relationship.

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 2.

   
  5.  How do you know when to use the different types of time in your design?  Mark for Review
(1) Points
   
 
 Always model time; you can take it out later if it is not needed.

 
 It depends on the functional needs of the system . (*)

 
 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.

 
 The rules are fixed and should be followed.

   
 
Correct  Correct

   
Page 1 of 3 Next Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  6.  Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  7.  In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  8.  Which of the following would be a logical constraint when modeling time for a City entity?  Mark for Review
(1) Points
   
 
 Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

 
 If you are doing a system for any French City, you would need security clearance.

 
 Cites may change their names and/or country association if the borders of a country change. (*)

 
 People are born in the city and people die in the city.

   
 
Correct  Correct

   
  9.  You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  10.  There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 4.

   
Previous Page 2 of 3 Next Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  11.  In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  12.  Which of the following statements are true to enhance the readability of ERDs? (Choose Two) Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 Relationship lines should not cross. (*)

 
 Crossing relationship lines help the readability of the diagram.

 
 It does not matter which way the crows feet (many ends of a relationship) point.

 
 Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 4.

   
  13.  Historical data must never be kept. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  14.  When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  15.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 TEACHER and AGE

 
 BABY and AGE

 
 CUSTOMER and PAYMENTS (*)

 
 CUSTOMER and ORDERS (*)

   
 
Correct  Correct

   
Previous Page 3 of 3 Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  1.  Modeling historical data can produce a unique identifier that includes a date. True or False? Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  2.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two)  Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 LIBRARY and BOOK (*)

 
 LIBRARY and NUMBER OF BOOKS

 
 STUDENT and AGE

 
 STUDENT and GRADE (*)

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 1.

   
  3.  Historical data must never be kept. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  4.  Which of the following statements are true to enhance the readability of ERDs? (Choose Two) Mark for Review
(1) Points
   
   (Choose all correct answers)
   
 
 Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)

 
 Crossing relationship lines help the readability of the diagram.

 
 It does not matter which way the crows feet (many ends of a relationship) point.

 
 Relationship lines should not cross. (*)

   
 
Correct  Correct

   
  5.  In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
Page 1 of 3 Next Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  6.  In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  7.  No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  8.  When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  9.  Why would you want to model a time component when designing a system that lets people buy bars of gold?  Mark for Review
(1) Points
   
 
 Sales people must determine where the gold is coming from.

 
 You would not want to model this; it is not important.

 
 The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)

 
 The Government of your country might want to be notified of this transaction.

   
 
Incorrect  Incorrect. Refer to Section 8 Lesson 3.

   
  10.  What is the function of logging or journaling in conceptual data models?  Mark for Review
(1) Points
   
 
 Creates a fixed time for all events in a data model.

 
 Allows you to track the history of attribute values, relationships, and/or entire entities (*)

 
 Gives a timestamp to all entities.

 
 Represents entities as time in the data model.

   
 
Correct  Correct

   
Previous Page 2 of 3 Next Summary


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

 Section 8 Quiz
 (Answer all questions in this section)
   
  11.  All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False?  Mark for Review
(1) Points
   
 
 True

 
 False (*)

   
 
Correct  Correct

   
  12.  When you add the concept of time to your data model, your model becomes more complex. True or False?  Mark for Review
(1) Points
   
 
 True (*)

 
 False

   
 
Correct  Correct

   
  13.  How do you know when to use the different types of time in your design?  Mark for Review
(1) Points
   
 
 The rules are fixed and should be followed.

 
 It depends on the functional needs of the system . (*)

 
 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.

 
 Always model time; you can take it out later if it is not needed.

   
 
Correct  Correct

   
  14.  Which of the following would be a logical constraint when modeling time for a country entity? Mark for Review
(1) Points
   
 
 People have births and deaths in their countries that must be tracked by the system.

 
 Daily traffic patterns must be monitored to determine which countries are overcrowded.

 
 If you are doing a system for France or Germany, you would need security clearance.

 
 Countries may change their names and/or borders over a period of time. (*)

   
 
Correct  Correct

   
  15.  When a relationship may or may not be transferable, depending on time, this is know as a/an: Mark for Review
(1) Points
   
 
 Conditional Non-transferable Relationship. (*)

 
 Arc.

 
 Transferable Relationship

 
 Non-transferable Relationship.

   
 
Correct  Correct

   
Previous Page 3 of 3 Summary

Read More