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

Question 1

Operational databases almost exclusively use the ________ structure.

Answer 1

relational

Question 2

Information assets are the new currency of business.

Answer 2

True

Question 3

Match the database realm to the appropriate activity.

-Database designer realm

A)Create database tables
B)Update data
C)Create database model

Answer 3

Create database model

Question 4

Match the database integrity rule to the appropriate definition.

-Rule 1: Entity Integrity

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 field values must be from a predefined domain.
D)The primary key value cannot be null (empty).

Question 5

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

Question 6

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

Question 7

The largest provider of relational database tools is Sun Microsystems Inc.

Question 8

________ is a technique used to develop an anomaly-free database with database integrity.

Question 9

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

Question 10

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

Question 11

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

Question 12

The database ________ creates the database model.

Question 13

________ are a crucial component of the enterprise system, containing intellectual property.

Question 14

The ________ database structure is used by data warehouses.

Question 15

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

Question 16

Match the database integrity rule to the appropriate definition.

-Rule 4: Referential Integrity

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 field values must be from a predefined domain.
D)The primary key value cannot be null (empty).

Question 17

The database ________ creates the database.

Question 18

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

Question 19

Match the database integrity rule to the appropriate definition.

-Rule 3: Domain Integrity

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 field values must be from a predefined domain.
D)The primary key value cannot be null (empty).

Question 20

Match the database integrity rule to the appropriate definition.

-Rule 2: Primary Key Integrity

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 field values must be from a predefined domain.
D)The primary key value cannot be null (empty).

Question 21

Match the database realm to the appropriate activity.

-Database user realm

A)Create database tables
B)Update data
C)Create database model

Question 22

Which of the following is NOT a database anomaly?

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

Question 23

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

Question 24

Which database architecture is a relatively new type of database?

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

Question 25

The third step in creating a ERD diagram is to determine the relevant business transactions that the enterprise must support.

Question 26

Provide an example of a deletion anomaly, update anomaly, and an insertion anomaly.

Question 27

Which database architecture is typically used for data warehouses?

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

Question 28

Entity identifiers are attributes that uniquely identify an entity occurrence.

Question 29

List and define the four database essentials.

Question 30

A candidate key is an entity identifier that uniquely identifies an entity.

Question 31

Data, such as accounting data, can be facts related to

A)Records
B)Tables
C)Objects
D)RDBMS software

Question 32

Sometimes, in an entity relationship diagram, the entity relationship is written on the connection line.

Question 33

What is data modeling?

Question 34

You are an intern at a company. Some managers want to copy some of the data in the accounting database into a data warehouse. Your boss is questioning why this is necessary. Create an email explaining why this is a good idea.

Question 35

Data integrity refers to data being

A)Current and active
B)Current and complete
C)Accurate and current
D)Accurate and complete

Question 36

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

Question 37

Match the database realm to the appropriate activity.

-Database builder realm

A)Create database tables
B)Update data
C)Create database model

Question 38

One-to-one relationships are problematic when building a database.

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

This database essential retrieves data from a database.

A)Report
B)Form
C)Query
D)Field

Question 41

Match the normalization rule to the appropriate definition.

-Rule 2. Second Normal Form (2NF)

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 42

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 43

Match the ERD symbols to the definition.

- $$\begin{array} { l | l } \text { PK } & \text { Cust No } \\\end{array}$$

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

Question 44

Match the normalization rule to the appropriate definition.

-Rule 3. Boyce-Codd Normal Form (BCNF)

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 45

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

Question 46

Match the ERD symbols to the definition.

-

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

Question 47

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

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

Question 48

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

Question 49

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

Question 50

Match the ERD symbols to the definition.

-

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

Question 51

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

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

Question 52

In database design terminology, a customer is an

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

Question 53

Match the normalization rule to the appropriate definition.

-Rule 1: First Normal Form (1NF)

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 54

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

Question 55

Database ________ removes anomalies from a database.

Question 56

A ________ relationship are problematic when designing databases

Question 57

Match the ERD symbols to the definition.

-Cust FName
Cust LName
Cust Address
Cust City

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

Question 58

Match the ERD symbols to the definition.

-

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

Question 59

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

Question 60

________ depicts the relationship among entities in the database.

Question 61

In a REA model, an agent is related to a resource through an event.

Question 62

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 63

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 64

Which of the following is a way to collect information about business transactions?

A)Interviewing users
B)Reviewing source documents
C)Observing procedures
D)All the above

Question 65

In an REA model, entities are business objects or events.

Question 66

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 67

What are the steps for designing an ERD?

Question 68

What is the purpose of an entity relationship diagram?

Question 69

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

Question 70

For an ERD, what do the business rules define?

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

Question 71

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 72

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

A)
B)
C)
D)

Question 73

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

Question 74

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

Question 75

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

A)
B)
C)
D)

Question 76

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

A)
B)
C)
D)

Question 77

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

A)
B)
C)
D)

Question 78

List and define the first three normalization rules.

Question 79

In a REA model, a resource has an intangible value.

Question 80

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