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

Question 1

Match the database integrity rule to the appropriate definition.

A)Each record in the database must have a unique identifier called a primary key.
B)Data referenced and stored in related tables must be consistent across the database.
C)The primary key value cannot be null (empty).
D)The field values must be from a predefined domain.
Rule 2: Primary Key Integrity

Answer 1

Answers: C

Question 2

Match the database integrity rule to the appropriate definition.

A)Each record in the database must have a unique identifier called a primary key.
B)Data referenced and stored in related tables must be consistent across the database.
C)The primary key value cannot be null (empty).
D)The field values must be from a predefined domain.
Rule 1: Entity Integrity

Answer 2

Answers: A

Question 3

Well-designed databases and queries determine whether accounting professionals are able to retrieve accurate accounting data.

Answer 3

True

Question 4

________ store data that is analyzed for business intelligence to enhance tactical and strategic decision making.

Question 5

The database integrity rule Referential Integrity states that field values must be from a predefined domain.

Question 6

Match the database integrity rule to the appropriate definition.

A)Each record in the database must have a unique identifier called a primary key.
B)Data referenced and stored in related tables must be consistent across the database.
C)The primary key value cannot be null (empty).
D)The field values must be from a predefined domain.
Rule 3: Domain Integrity

Question 7

The ________ database structure is used by data warehouses.

Question 8

________ databases contain data collected by other organizations and agencies, such as the Securities and Exchange Commission (SEC).

Question 9

Match the database realm to the appropriate activity.

A)Update data
B)Create database tables
C)Create database model
Database designer realm

Question 10

Match the database integrity rule to the appropriate definition.

A)Each record in the database must have a unique identifier called a primary key.
B)Data referenced and stored in related tables must be consistent across the database.
C)The primary key value cannot be null (empty).
D)The field values must be from a predefined domain.
Rule 4: Referential Integrity

Question 11

The database ________ creates the database model.

Question 12

Database modeling may require additional investment of time as the database is being developed.

Question 13

________ databases can be classified as (1)operational databases, (2)data warehouses, or (3)XBRL databases.

Question 14

________ is a piece of information about events and objects.

Question 15

The database design impact how well the database serves the needs of the enterprise.

Question 16

The database ________ creates the database.

Question 17

Database anomalies are removed through ________ and/or database modeling.

Question 18

Operational databases almost exclusively use the ________ structure.

Question 19

The database integrity rule Primary Key Integrity states each record in the database must have a unique identifier called a primary key.

Question 20

Database anomalies are problems within a database table that result in inaccurate or incomplete data.

Question 21

Many-to-many relationships are not problematic when building a database.

Question 22

What does a database designer do?

A)Uses the database
B)Creates the database
C)Creates the database model
D)Restores the database

Question 23

An entity occurrence describes a property of the entity (an object or event).

Question 24

Data integrity refers to data being

A)current and active
B)current and complete
C)accurate and current
D)accurate and complete

Question 25

Entity identifiers are attributes that uniquely identify an entity occurrence.

Question 26

List and define the four database essentials.

Question 27

List and define three database anomalies.

Question 28

Which of the following is not considered a database element?

A)Table
B)Field
C)File
D)Record

Question 29

Which database architecture is typically used for data warehouses?

A)Dimensional
B)XBRL
C)Relational
D)Network

Question 30

In an ERD diagram, the entity attributes are listed in the entity box.

Question 31

Which database architecture is typically used for operational databases?

A)Dimensional
B)XBRL
C)Relational
D)Network

Question 32

Match the database realm to the appropriate activity.

A)Update data
B)Create database tables
C)Create database model
Database user realm

Question 33

What are the three classifications of internal database? How is each used?

Question 34

Match the database realm to the appropriate activity.

A)Update data
B)Create database tables
C)Create database model
Database builder realm

Question 35

In an ERD diagram, an entity is represented by a rounded box or rectangle.

Question 36

In designer terminology, for a one-to-one relationship, the maximum occurrence possible for each entity is one.

Question 37

What are the three realms of a database and what happens in each realm?

Question 38

Which of the following is not a database anomaly?

A)Update
B)Commit
C)Deletion
D)Insertion

Question 39

For a single occurrence of one entity (one customer), cardinality defines the maximum and minimum number of occurrences that might relate to the other entity (sales orders).

Question 40

What is data modeling?

Question 41

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

Question 42

Match the ERD symbols to the definition.

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

Question 43

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

Question 44

Match the ERD symbols to the definition.

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

Question 45

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.

Question 46

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

Question 47

All the entity identifiers that uniquely identify the entity are called ________ keys in the database builder realm.

Question 48

In database modeling performed in the database designer realm, the term entity can refer to

A)Place
B)Event
C)Object
D)B and C

Question 49

Entity identifiers that uniquely identify the entity are called

A)Candidate keys
B)Primary keys
C)Foreign keys
D)Composite keys

Question 50

________ depicts the relationship among entities in the database.

Question 51

Match the normalization rule to the appropriate definition.

A)No field can have multiple values.
B)The table identifier (primary key)should not be a composite key.
C)Every identifier should be a candidate key
Rule 1: First Normal Form (1NF)

Question 52

Match the ERD symbols to the definition.

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

Question 53

Match the ERD symbols to the definition.

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

Question 54

________ rules define attribute limitations, referential integrity, and cardinality of relationships among entities.

Question 55

Experience does not help database designer define business entities and relationships among those entities.

Question 56

Match the normalization rule to the appropriate definition.

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

Question 57

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

Question 58

In database design terminology, a customer is an

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

Question 59

Match the normalization rule to the appropriate definition.

A)No field can have multiple values.
B)The table identifier (primary key)should not be a composite key.
C)Every identifier should be a candidate key
Rule 3. Boyce-Codd Normal Form (BCNF)

Question 60

Match the ERD symbols to the definition.

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

Question 61

Which symbol represents a cardinality of a maximum: many and minimum: 1?

A)
B)
C)
D)

Question 62

For an ERD, what do the business rules define?

A)Entities
B)Business transactions
C)Attribute limitations
D)Entity attributes

Question 63

When using normalization for database development, all the attributes are placed in

A)Three large tables
B)Two huge tables
C)One large table
D)B and C

Question 64

List the ERD design steps that are dependent on the database structure.

Question 65

What is the purpose of an entity relationship diagram?

Question 66

In an ERD diagram, relationship cardinality is represented as

A)PK symbol listed by attribute
B)Connector lines
C)Square box
D)Crow's feet symbols

Question 67

In a REA model, the relationship between the two events is called economic duality and represents resource exchange.

Question 68

In ________ modeling, a resource has economic value to the enterprise, such as inventory, cash, or other assets.

Question 69

In an ERD diagram, a relationship between entities is represented as

A)PK symbol listed by attribute
B)Connector lines
C)Square box
D)Crow's feet symbols

Question 70

How are business entities and their relationships identified?

A)Determining the business rules for business transactions
B)Determining the entity identifiers
C)Normalizing the database
D)Analyzing business transactions

Question 71

In an ERD diagram, an entity identifier is represented as

A)PK symbol listed by attribute
B)Connector lines
C)Square box
D)Crow's feet symbols

Question 72

Which symbol represents a cardinality of a maximum: 1 and minimum: 1?

A)
B)
C)
D)

Question 73

The REA model shows what is given and what is taken in a business exchange.

Question 74

In building an ERD, in which step is the database application chosen?

A)Step 2: Determine the business rules for a specific business transaction.
B)Step 7: Add business-related attributes to the ERD.
C)Step 9: Develop relational database tables.
D)Step 10: Build relational database tables.

Question 75

Which symbol represents a cardinality of a maximum: 1 and minimum: 0?

A)
B)
C)
D)

Question 76

List and define the first three normalization rules.

Question 77

Why does a database designer need to understand a business's rules?

Question 78

List the ERD design steps that are independent of the database structure.

Question 79

Which symbol represents a cardinality of a maximum: many and minimum: 0?

A)
B)
C)
D)

Question 80

What are the steps for designing an ERD?