Deck 6: Database Implementation and Use

Question 1

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces a DELETE SET-TO-DEFAULT option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after a User tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?

A)CLIENT will have 7 records
AGENT will have 4 records
B)CLIENT will have 6 records
AGENT will have 3 records
C)CLIENT will have 7 records
AGENT will have 3 records
D)CLIENT will have 6 records
AGENT will have 4 records

Answer 1

CLIENT will have 7 records
AGENT will have 3 records

Question 2

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.
CURRENTLY ENROLLED STUDENTS (YEAR 2013)

If the office worker inserts the record below into the table CURRENTLY ENROLLED STUDENTS,which problem will occur? (Assume that all the dates in the record below are correct. )

A)Accuracy
B)Completeness
C)Conformity
D)No data quality problem with this record

Answer 2

B

Question 3

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?

A)CLIENT will have 7 records
AGENT will have 4 records
B)CLIENT will have 6 records
AGENT will have 3 records
C)CLIENT will have 7 records
AGENT will have 3 records
D)CLIENT will have 6 records
AGENT will have 4 records

Answer 3

CLIENT will have 7 records
AGENT will have 4 records

Question 4

Which of the following describes the timeliness data quality characteristic?

A)The degree to which all the required data is present in the data collection
B)The characteristic that requires each real-world instance to be represented only once in the data collection
C)The extent to which data correctly reflects the real world instances it is supposed to depict
D)The degree to which the data is aligned with the proper time window in its representation of the real world

Question 5

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces an UPDATE RESTRICT option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after a User tries to change the AgentID value in the last record to A5?

A)Value A4 appears once in column AgentID in AGENT,and value A4 appears once in column ClientAgent in table CLIENT
B)Value A5 appears once in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT
C)Value A5 appears once in column AgentID in AGENT,and value A5 does not appear in column ClientAgent in table CLIENT
D)Value A5 does not appear in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT

Question 6

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.

CURRENTLY ENROLLED STUDENTS (YEAR 2013)


This scenario will be used for the following questions citing table CURRENTLY ENROLLED STUDENTS.

-If the office worker inserts the record below into the table CURRENTLY ENROLLED STUDENTS,which problem will occur? (Assume that all the dates in the record below are correct. )
$\begin{array}{|l|l|c|c|l|l|c|c|ll| }\hline200603& \text {Little } & \text { Mark}& \text {hittlem@arcedu}&04.05 .1994 &1.1.2011.&1.1.2015.& \text { Detroit}& \text {US} \\\hline\end{array}$

A)Accuracy
B)Uniqueness
C)Conformity
D)No data quality problem with this record

Question 7

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces a DELETE SET-TO-NULL option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?

A)CLIENT will have 7 records
AGENT will have 4 records
B)CLIENT will have 6 records
AGENT will have 3 records
C)CLIENT will have 7 records
AGENT will have 3 records
D)CLIENT will have 6 records
AGENT will have 4 records

Question 8

Which of the following describes the consistency data quality characteristic?

A)The degree to which all the required data is present in the data collection
B)The extent to which the data properly conforms to and matches up with the other data
C)The extent to which data correctly reflects the real world instances it is supposed to depict
D)The extent to which the data conforms to its specified format

Question 9

Which of the following describes the completeness data quality characteristic?

A)The degree to which all the required data is present in the data collection
B)The characteristic that requires each real-world instance to be represented only once in the data collection
C)The extent to which the data properly conforms to and matches up with the other data
D)The degree to which the data is aligned with the proper time window in its representation of the real world

Question 10

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces an UPDATE CASCADE option on the referential integrity constraint between
CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after a
User tries to change the AgentID value in the last record to A5?

A)Value A4 appears once in column AgentID in AGENT,and value A4 appears once in column ClientAgent in table CLIENT
B)Value A5 appears once in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT
C)Value A5 appears once in column AgentID in AGENT,and value A5 does not appear in column ClientAgent in table CLIENT
D)Value A5 does not appear in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT

Question 11

Which of the following describes the uniqueness data quality characteristic?

A)The degree to which all the required data is present in the data collection
B)The characteristic that requires each real-world instance to be represented only once in the data collection
C)The extent to which data correctly reflects the real world instances it is supposed to depict
D)The extent to which the data properly conforms to and matches up with the other data

Question 12

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces an UPDATE SET-TO-NULL option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after a User tries to change the AgentID value in the last record to A5?

A)Value A4 appears once in column AgentID in AGENT,and value A4 appears once in column ClientAgent in table CLIENT
B)Value A5 appears once in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT
C)Value A5 appears once in column AgentID in AGENT,and value A5 does not appear in column ClientAgent in table CLIENT
D)Value A5 does not appear in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT

Question 13

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.

CURRENTLY ENROLLED STUDENTS (YEAR 2013)


This scenario will be used for the following questions citing table CURRENTLY ENROLLED STUDENTS.

-If the office worker inserts the record below into the table CURRENTLY ENROLLED STUDENTS,which problem will occur? (Assume that all the dates in the record below are correct. )
$\begin{array}{|l|l|c|c|l|l|c|c|ll| }\hline200705& \text {MeCormick } & \text { Chris}& \text {Chcoormickc@arcedu}&11.10 .1992 &1.1.2010.&1.1.2014.& \text {Chicago}& \text {USA} \\\hline\end{array}$

A)Accuracy
B)Uniqueness
C)Conformity
D)No data quality problem with this record

Question 14

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.
CURRENTLY ENROLLED STUDENTS (YEAR 2013)

If the office worker inserts the record below into the table CURRENTLY ENROLLED STUDENTS,which problem will occur? (Assume that all the dates in the record below are correct. )

A)Accuracy
B)Completeness
C)Conformity
D)No data quality problem with this record

Question 15

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.
CURRENTLY ENROLLED STUDENTS (YEAR 2013)

Observe the three records below that are NOT YET entered in the table CURRENTLY ENROLLED STUDENTS.(Assume all the shown values in all three records are correct. )



Which of these three records that are not yet entered should be entered into the table CURRENTLY ENROLLED STUDENTS in order to avoid the timeliness problem?

A)The record with Student ID value 201001 (for student Susan Smith)
B)The record with Student ID value 201002 (for student Meg Still)
C)The record with Student ID value 201003 (for student Alex Soto)
D)All three records

Question 16

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (C777,Christina,A4,Mike)from CLIENT?

A)CLIENT will have 7 records
AGENT will have 4 records
B)CLIENT will have 6 records
AGENT will have 3 records
C)CLIENT will have 7 records
AGENT will have 3 records
D)CLIENT will have 6 records
AGENT will have 4 records

Question 17

Which of the following describes the conformity data quality characteristic?

A)The degree to which all the required data is present in the data collection
B)The extent to which the data properly conforms to and matches up with the other data
C)The extent to which data correctly reflects the real world instances it is supposed to depict
D)The extent to which the data conforms to its specified format

Question 18

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.
CURRENTLY ENROLLED STUDENTS (YEAR 2013)

If the office worker inserts the record below into the table CURRENTLY ENROLLED STUDENTS,which problem will occur? (Assume that all the dates in the record below are correct. )

A)Accuracy
B)Completeness
C)Conformity
D)No data quality problem with this record

Question 19

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Matt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint betweenCLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (A4,James,3,90,2010,A3)from AGENT?

A)CLIENT will have 7 records
AGENT will have 4 records
B)CLIENT will have 6 records
AGENT will have 3 records
C)CLIENT will have 7 records
AGENT will have 3 records
D)CLIENT will have 6 records
AGENT will have 4 records

Question 20

Which of the following describes the accuracy data quality characteristic?

A)The degree to which all the required data is present in the data collection
B)The extent to which the data conforms to its specified format
C)The extent to which data correctly reflects the real world instances it is supposed to depict
D)The extent to which the data properly conforms to and matches up with the other data

Question 21

Describe the update set-to-null option (for implementing a referential integrity constraint).

Question 22

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT

$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Madt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces in the HAPPY INSURANCE database an UPDATE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and an UPDATE CASCADE between AGENT and CLIENT,value A1 in the first record in the table AGENT can be changed to A5.

Question 23

Using an input mask such as DD/MM/YYYY for entry of a date value is an example of a corrective data quality action.

Question 24

Most RDBMS packages implement assertions using the CREATE ASSERTION statement.

Question 25

What is the purpose of an index?

Question 26

Describe the delete set-to-default option (for implementing a referential integrity constraint).

Question 27

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT

$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Madt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and a DELETE CASCADE between AGENT and CLIENT,the second record in the table AGENT can be deleted.

Question 28

A web site can be an interface into a database.

Question 29

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT

$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Madt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AREA and AGENT,and a DELETE CASCADE between AGENT and CLIENT,the first record in the table AGENT can be deleted.

Question 30

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT

$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Madt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AREA and AGENT,and a DELETE CASCADE between AGENT and CLIENT,the first record in the table AREA can be deleted.

Question 31

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT

$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Madt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces in the HAPPY INSURANCE database an UPDATE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and an UPDATE CASCADE between AGENT and CLIENT,value A1 in the second record in the table AGENT can be changed to A5.

Question 32

Mandating instantaneous entry of all new data is an example of a preventive data quality action.

Question 33

Describe the delete restrict option (for implementing a referential integrity constraint).

Question 34

Describe the update restrict option (for implementing a referential integrity constraint).

Question 35

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT

$$\begin{array} { l l c l } \text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \\\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\\text { C222 } & \text { Kain } & A 1 & \text { Bill } \\\text { C333 } & \text { Cole } & A 2 & \text { Amy } \\\text { C444 } & \text { Dorothy } & A 2 & \\\text { C555 } & \text { Anay } & A 3 & \text { Amy } \\\text { C666 } & \text { Tina } & A 3 & \text { Madt } \\\text { C777 } & \text { Christina } & A 4 & \text { Mike }\end{array}$$ AGENT
$$\begin{array} { l l l l l c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \\\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \\\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \\\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \\\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }\end{array}$$ AREA
$$\begin{array} { l l l } \text { ArealD } & \text { AreaName } & \text { AreaHQ } \\1 & \text { East } & \text { Boston } \\2 & \text { West } & \text { San Francisco } \\3 & \text { Central } & \text { Chicago }\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.

-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and a DELETE CASCADE between AGENT and CLIENT,the first record in the table AGENT can be deleted.

Question 36

Describe the delete set-to-null option (for implementing a referential integrity constraint).

Question 37

Describe the delete cascade option (for implementing a referential integrity constraint).

Question 38

Describe the update set-to-default option (for implementing a referential integrity constraint).

Question 39

What is linear search?

Question 40

Describe the update cascade option (for implementing a referential integrity constraint).

Question 41

Show the SQL statement that will for HAPPY INSURANCE database create and index on the ClientName column of the table CLIENT.

Question 42

Assume a form is created for HAPPY INSURANCE database where a user can perform the following action:
A user highlights value A1 in the first row of the CLIENT table and changes it to A4.
Write the SQL statement that will be issued on the user's behalf based on this action.

Question 43

What is a report?

Question 44

Assume a search form for HAPPY INSURANCE database is created where a user can perform the following action:
ENTER AREA ID:
ENTER AREA NAME:
ENTER AREA HQ:
ENTER AgentID:
ENTER AgentName:
ENTER AgentArea: 3 (<--- Entered by the user)
ENTER AgentRating:
ENTER AgentYearOfHire:
ENTER SupervisedBY:
(User clicks on the search button upon entering the value above. )
Write the SQL statement that will be issued on the user's behalf based on this action.

Question 45

What are corrective data quality actions?

Question 46

Assume a data-entry form for HAPPY INSURANCE database is created where a user can perform the following data-entry action:
ENTER AREA ID: 4 (<--- Entered by the user)
ENTER AREA NAME: South (<--- Entered by the user)
ENTER AREA HQ: Atlanta (<--- Entered by the user)
Write the SQL statement that will be issued on the user's behalf based on this action.

Question 47

What is binary search?

Question 48

What is a form?

Question 49

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
AGENT
AREA

Show the CREATE TABLE statements for HAPPY INSURANCE database for the table CLIENT (assume that non-primary key columns can be optional)with the DELETE SET-TO-NULL and UPDATE CASCADE option for its referential integrity constraint.

Question 50

What are preventive data quality actions?

Question 51

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
AGENT
AREA

Show the CREATE TABLE statements for HAPPY INSURANCE database for the table CLIENT (assume that non-primary key columns can be optional)with the DELETE CASCADE option for its referential integrity constraint.

Question 52

Assume a search form for HAPPY INSURANCE database is created where a user can perform the following action:
ENTER AREA ID:
ENTER AREA NAME:
ENTER AREA HQ:
ENTER AgentID:
ENTER AgentName:
ENTER AgentArea:
ENTER AgentRating:
ENTER AgentYearOfHire: 2010 (<--- Entered by the user)
ENTER SupervisedBY: A3 (<--- Entered by the user)
(User clicks on the search button upon entering the values above. )
Write the SQL statement that will be issued on the user's behalf based on this action.

Question 53

What is a trigger?

Question 54

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
AGENT
AREA

Show the CREATE TABLE statements for HAPPY INSURANCE database for the table AGENT (assume that non-primary key columns can be optional)with the user defined constraint specifying that the agent rating must be between 50 and 150.

Question 55

Assume a form is created for HAPPY INSURANCE database where a user can perform the following action:
A user highlights the first row of the CLIENT table and presses the delete key on the keyboard.
Write the SQL statement that will be issued on the user's behalf based on this action.