Question 1

What are the components of a database application system?

Accepted Answer

The answer of What are the components of a database...

Question 2

Bill, a database designer, says that the tables in the manager's database are not normalized. What does he mean by this?
A) He means that the tables have irregular, not-normal data.
B) He means that the tables have a format that could cause data integrity problems.
C) He means that the tables do not have duplicated data.
D) He means that the tables do not represent entities.

Accepted Answer

Normalization is the process of organizing data in a database to avoid data redundancy and improve data integrity. A non-normalized database can have duplicate data and update anomalies, leading to data inconsistencies and inaccuracies. Therefore, Bill means that the tables in the manager's database have a format that could cause data integrity problems if they are not normalized.

Question 3

The database design team transforms entities into ________.
A) normal forms
B) foreign keys
C) tables
D) bytes

Accepted Answer

The database design team transforms entities into tables. Tables are the basis for storing and organizing data in a relational database.

Option A, normal forms, are a set of rules that help in organizing and structuring tables in a relational database. It is not a result of transforming entities.

Option B, foreign keys, are used to establish a relationship between tables in a relational database. It is not a result of transforming entities.

Option D, bytes, are units of data used for storage and processing in a computer system. It is not a result of transforming entities into tables.

Question 4

In a university, a single student can be associated to many classes and one class can be associated to many students. This is an example of a(n)________.
A) 1:N relationship
B) N:1 relationship
C) N:N relationship
D) N:M relationship

Accepted Answer

The relationship between a student and a class is many-to-many (N:M) because a student can be associated with many classes and a class can be associated with many students.

Question 5

What is a database management system (DBMS)? How does it differ from a database?

Accepted Answer

The answer of What is a database management system (DBMS)?...

Question 6

________ is the process of converting a data model into tables, relationships, and data constraints.
A) Data acquisition
B) Database design
C) Data enrichment
D) Data warehousing

Accepted Answer

Database design involves the process of transforming a data model into a logical and physical database design that includes tables, relationships between tables, and data constraints such as primary keys, foreign keys, and unique constraints. Data acquisition refers to the process of collecting and capturing data, data enrichment involves enhancing the value of existing data, and data warehousing involves the process of collecting and storing data from different sources to support business decisions.

Question 7

In entity-relationship diagrams, crow's feet indicate ________.
A) relationships between the various items
B) the number of attributes each entity possesses
C) whether a database is single-user or multi-user
D) the number of applications in a database

Accepted Answer

Crow's feet indicate relationships between entities in an entity-relationship diagram. They can be used to indicate the cardinality of the relationship, such as whether it is one-to-many or many-to-many.

Question 8

What is a database? Explain the contents of a database.

Accepted Answer

The answer of What is a database? Explain the contents...

Question 9

What are metadata? How are metadata used in databases?

Accepted Answer

The answer of What are metadata? How are metadata used...

Question 10

________ refers to the number of entities that can be involved in a relationship.
A) Attribute
B) Normal form
C) Identifier
D) Cardinality

Accepted Answer

Cardinality refers to the number of entities that can be involved in a relationship. Options A, B, and C are not related to cardinality.

Question 11

An N:M relationship cannot be written as N:N, because ________.
A) N:N is similar to 1:N relationship, which is a one-to-many relationship
B) N:N implies that the relationship is between two of the same kind of entity
C) N:N implies that there are the same number of entities on each side of the relationship
D) N:N implies that the relationship is within a single entity

Accepted Answer

N:N implies that there are the same number of entities on each side of the relationship.

Question 12

A(n)________ is an attribute (or group of attributes)whose value is associated with one and only one entity instance.
A) relationship
B) query
C) identifier
D) primary key

Accepted Answer

An identifier is an attribute (or group of attributes) whose value is associated with one and only one entity instance, uniquely identifying it.

Question 13

Every normalized table has ________.
A) multiple topics
B) data integrity problems
C) a single theme
D) duplicated data

Accepted Answer

Normalization is the process of removing duplicate data and ensuring data integrity by creating multiple tables with a single theme. Therefore, every normalized table has a single theme. Option A and D are incorrect because normalization aims to eliminate multiple topics and duplicated data. Option B is incorrect because normalization ensures data integrity and avoids data integrity issues.

Question 14

Many-to-many relationships are indicated using the ________ notation.
A) N:N
B) 1:N
C) M:1
D) N:M

Accepted Answer

Many-to-many relationships are indicated using the N:M notation. Option A is incorrect as the correct notation is N:M and not N:N. Option B is incorrect as it represents a one-to-many relationship. Option C is also incorrect as it represents a many-to-one relationship.

Question 15

The process of converting poorly structured tables into two or more well-structured tables is called ________.
A) conversion
B) certification
C) normalization
D) simplification

Accepted Answer

The process of converting poorly structured tables into two or more well-structured tables is called normalization. This involves breaking down a large table into smaller, more manageable tables that adhere to a set of rules to ensure data consistency and minimize redundancy. The end result is a more efficient and reliable database structure.

Question 16

The easiest time to change the database structure is during the ________ stage.
A) data modeling
B) data warehousing
C) database design
D) data entry

Accepted Answer

The easiest time to change the database structure is during the data modeling stage, as this is when the logical structure of the database is being defined.

Question 17

Developers use ________ to define the entities that will be stored in the database and the relationships among those entities.
A) the waterfall model
B) spiral models
C) incremental models
D) the E-R data model

Accepted Answer

The E-R (Entity-Relationship) data model is specifically designed to define the entities and their relationships within a database system. It is widely used in software development and database design. The other options mentioned (waterfall model, spiral models, and incremental models) are project management methodologies or process models and do not relate to database entity definition.

Question 18

The database design team expresses relationships by defining ________.
A) normal forms
B) foreign keys
C) attributes
D) queries

Accepted Answer

Relationships are expressed in a database by using foreign keys that link one table to another. Normal forms refer to the degree of data normalization and attributes refer to the characteristics or properties of a database object. Queries are used to retrieve data from a database, but do not define relationships.

Question 19

Which of the following is true of N:M relationships?
A) The number of entities on each side cannot be different.
B) More than one entity is allowed on each side of the relationship.
C) One side must have a greater number of entities than the other.
D) They are also called one-to-many relationships.

Accepted Answer

N:M relationships allow for more than one entity on each side of the relationship. The number of entities on each side can be different, and both sides can have multiple entities. Option A is incorrect because the number of entities on each side can be different. Option C is incorrect because there is no requirement for one side to have a greater number of entities than the other. Option D is incorrect because one-to-many relationships are different from N:M relationships.

Question 20

Constraints on the number of entities that can be in a relationship are called ________.
A) normal forms
B) minimum cardinalities
C) queries
D) primary keys

Accepted Answer

Minimum cardinalities specify the minimum number of entities that must be present in a relationship. Normal forms refer to rules for designing database tables, queries are used to retrieve data, and primary keys are unique identifiers for database records.

Quiz 4: Database Processing

What are the components of a database application system?

Bill, a database designer, says that the tables in the manager's database are not normalized. What does he mean by this?

The database design team transforms entities into ________.

In a university, a single student can be associated to many classes and one class can be associated to many students. This is an example of a(n) ________.

What is a database management system (DBMS)? How does it differ from a database?

________ is the process of converting a data model into tables, relationships, and data constraints.

In entity-relationship diagrams, crow's feet indicate ________.

What is a database? Explain the contents of a database.

What are metadata? How are metadata used in databases?

________ refers to the number of entities that can be involved in a relationship.

An N:M relationship cannot be written as N:N, because ________.

A(n) ________ is an attribute (or group of attributes) whose value is associated with one and only one entity instance.

Every normalized table has ________.

Many-to-many relationships are indicated using the ________ notation.

The process of converting poorly structured tables into two or more well-structured tables is called ________.

The easiest time to change the database structure is during the ________ stage.

Developers use ________ to define the entities that will be stored in the database and the relationships among those entities.

The database design team expresses relationships by defining ________.

Which of the following is true of N:M relationships?

Constraints on the number of entities that can be in a relationship are called ________.