Question 1

Match the normalization rule to the appropriate definition.
-Rule 2. Second Normal Form (2NF)

Accepted Answer

A) No field can have multiple values. 
B) Every identifier should be a candidate key 
C) The table identifier (primary key)should not be a composite key. 
A) No field can have multiple values. 
B) Every identifier should be a candidate key 
C) The table identifier (primary key)should not be a composite key.

Question 2

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a ________ entity and the entity on the many side (sales order)is called a ________ entity.

Accepted Answer

parent, ch

Question 3

Match the ERD symbols to the definition.
-$$\begin{array} { l | l } 
\text { PK } & \text { Cust No } \

\end{array}$$

Accepted Answer

A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship 
A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship

Question 4

Match the normalization rule to the appropriate definition.
-Rule 3. Boyce-Codd Normal Form (BCNF)

Accepted Answer

A) No field can have multiple values. 
B) Every identifier should be a candidate key 
C) The table identifier (primary key)should not be a composite key. 
A) No field can have multiple values. 
B) Every identifier should be a candidate key 
C) The table identifier (primary key)should not be a composite key.

Question 5

A specific customer, such as Vincent, is an entity ________.

Accepted Answer

The answer of A specific customer, such as Vincent, is...

Question 6

Match the ERD symbols to the definition.
-

Accepted Answer

A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship 
A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship

Question 7

Which of the following uniquely identifies the occurrence of an object or event?

Accepted Answer

A) Entity occurrence 
B) Entity attribute 
C) Entity identifier 
D) Entity name 
A) Entity occurrence 
B) Entity attribute 
C) Entity identifier 
D) Entity name

Question 8

The name given to a relationship, for example one-to-one, defines the maximum cardinalities.

Accepted Answer

A) True 
 B)False

Question 9

Detail of the ERD and information about the tables fields, such as their size and type, are stored in a document called the ________.

Accepted Answer

The answer of Detail of the ERD and information about...

Question 10

Match the ERD symbols to the definition.
-

Accepted Answer

A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship 
A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship

Question 11

Which of the following describes a property of an object or event?

Accepted Answer

A) Entity attribute 
B) Entity occurrence 
C) Entity identifier 
D) Composite keys 
A) Entity attribute 
B) Entity occurrence 
C) Entity identifier 
D) Composite keys

Question 12

In database design terminology, a customer is an

Accepted Answer

A) Occurrence 
B) Object 
C) Attribute 
D) Entity 
A) Occurrence 
B) Object 
C) Attribute 
D) Entity

Question 13

Match the normalization rule to the appropriate definition.
-Rule 1: First Normal Form (1NF)

Accepted Answer

A) No field can have multiple values. 
B) Every identifier should be a candidate key 
C) The table identifier (primary key)should not be a composite key. 
A) No field can have multiple values. 
B) Every identifier should be a candidate key 
C) The table identifier (primary key)should not be a composite key.

Question 14

After ensuring compliance with the BCNF normalization rule, rarely does a database table need further normalization.

Accepted Answer

A) True 
 B)False

Question 15

Database ________ removes anomalies from a database.

Accepted Answer

The answer of Database ________ removes anomalies from a database....

Question 16

A ________ relationship are problematic when designing databases

Accepted Answer

The answer of A ________ relationship are problematic when designing...

Question 17

Match the ERD symbols to the definition.
-Cust FName 
Cust LName 
Cust Address 
Cust City

Accepted Answer

A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship 
A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship

Question 18

Match the ERD symbols to the definition.
-

Accepted Answer

A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship 
A) Entity Attributes 
B) Entity 
C) Entity identifier 
D) Relationship cardinality 
E) Entity relationship

Question 19

When using normalization for database development, all the attributes are placed in one huge table.

Accepted Answer

A) True 
 B)False

Question 20

________ depicts the relationship among entities in the database.

Accepted Answer

Entity rel

Match the normalization rule to the appropriate definition. -Rule 2. Second Normal Form (2NF)

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a entity and the entity on the many side (sales order)is called a entity.

Match the ERD symbols to the definition. - PK Cust No

Match the normalization rule to the appropriate definition. -Rule 3. Boyce-Codd Normal Form (BCNF)

A specific customer, such as Vincent, is an entity ________.

Match the ERD symbols to the definition. -

Which of the following uniquely identifies the occurrence of an object or event?

The name given to a relationship, for example one-to-one, defines the maximum cardinalities.

Detail of the ERD and information about the tables fields, such as their size and type, are stored in a document called the ________.

Match the ERD symbols to the definition. -

Which of the following describes a property of an object or event?

In database design terminology, a customer is an

Match the normalization rule to the appropriate definition. -Rule 1: First Normal Form (1NF)

After ensuring compliance with the BCNF normalization rule, rarely does a database table need further normalization.

Database ________ removes anomalies from a database.

A ________ relationship are problematic when designing databases

Match the ERD symbols to the definition. -Cust FName Cust LName Cust Address Cust City

Match the ERD symbols to the definition. -

When using normalization for database development, all the attributes are placed in one huge table.

________ depicts the relationship among entities in the database.

Accounting Systems Insights

Accounting Databases

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Filters

Exam 14: Database Design: ERD, REA, and SQL

Match the normalization rule to the appropriate definition. -Rule 2. Second Normal Form (2NF)

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a ________ entity and the entity on the many side (sales order)is called a ________ entity.

Match the ERD symbols to the definition. - PK Cust No

Match the normalization rule to the appropriate definition. -Rule 3. Boyce-Codd Normal Form (BCNF)

A specific customer, such as Vincent, is an entity ________.

Match the ERD symbols to the definition. -

Which of the following uniquely identifies the occurrence of an object or event?

The name given to a relationship, for example one-to-one, defines the maximum cardinalities.

Detail of the ERD and information about the tables fields, such as their size and type, are stored in a document called the ________.

Match the ERD symbols to the definition. -

Which of the following describes a property of an object or event?

In database design terminology, a customer is an

Match the normalization rule to the appropriate definition. -Rule 1: First Normal Form (1NF)

After ensuring compliance with the BCNF normalization rule, rarely does a database table need further normalization.

Database ________ removes anomalies from a database.

A ________ relationship are problematic when designing databases

Match the ERD symbols to the definition. -Cust FName Cust LName Cust Address Cust City

Match the ERD symbols to the definition. -

When using normalization for database development, all the attributes are placed in one huge table.

________ depicts the relationship among entities in the database.

Accounting Systems Insights

Accounting Databases

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Filters

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a entity and the entity on the many side (sales order)is called a entity.