Question 1

Which type of database stores structured data in two-dimensional tables?
A) Relational
B) Object-oriented
C) NoSQL
D) All of these answer choices are correct.

Accepted Answer

Relational databases store structured data in two-dimensional tables, which allows for the organization of data into rows and columns.

Question 2

In a relational database, data is stored in tables of related data. The database for Motorcycle Parts Warehouse has the following tables: Items, Employees, Sales, and Customers. Into which table would you insert a field to store the delivery address used to ship a customer their order?
A) Items
B) Employees
C) Sales
D) Customers

Accepted Answer

The delivery address used to ship a customer their order is directly related to the customer's information. Therefore, it would be most appropriate to insert a field for the delivery address in the Customers table, as this table is likely to contain other relevant information about the customers, including their addresses.

Question 3

An advantage that object-oriented databases have over relational databases are
A) that the two-dimensional structure is easy to understand.
B) the ability to store both structured and unstructured data.
C) its wide adoption for accounting systems.
D) All of these answer choices are correct.

Accepted Answer

Object-oriented databases are designed to handle a wide variety of data types, including both structured and unstructured data, which gives them an advantage over traditional relational databases that are primarily designed for structured data.

Question 4

Object-oriented databases group similar objects together in a
A) class.
B) record.
C) variable.
D) file.

Accepted Answer

Object-oriented databases group similar objects together in a class, which defines the properties and behaviors of those objects.

Question 5

Attributes of an object in an object-oriented database are referred to as
A) classes.
B) records.
C) variables.
D) files.

Accepted Answer

Attributes of an object in an object-oriented database are referred to as variables. These variables hold the data or state of the object and are defined by the class of the object.

Question 6

NoSQL databases store data
A) individually with key-values.
B) in rows and columns.
C) in classes.
D) in schemas.

Accepted Answer

NoSQL databases are known for storing data individually using key-value pairs, which is a method that differs from the traditional relational database structure of rows and columns. This allows for more flexible and scalable data storage solutions.

Question 7

What advantages does a NoSQL database have over an object-oriented and relational database?
A) NoSQL databases store data in objects that can handle the high velocity of big data generated.
B) NoSQL databases allow for faster processing and flexible storage for big, unstructured data.
C) NoSQL databases allow for faster processing of unstructured data by using rows and columns to quickly locate data.
D) NoSQL databases store data using key-values to categorize into classes and objects for speed of retrieval.

Accepted Answer

NoSQL databases are designed to handle large volumes of data that can be unstructured or semi-structured, offering faster processing and more flexible storage options compared to traditional relational databases that rely on a fixed schema. They do not store data in objects like object-oriented databases or primarily use rows and columns for data organization.

Question 8

Campbell Marketing Solutions (CMS) has grown in the past few years and is considering upgrading their current database management system. The data that CMS would like to store in the new database includes social media posts, photographs, and videos, though the type of data seems to continually change. CMS knows that they will need to scale often and retrieve large amounts of various data. Which kind of database should CMS use?
A) Relational
B) Object-oriented
C) NoSQL
D) Any of these database models could work for CMS.

Accepted Answer

Given the need to store various types of data (social media posts, photographs, videos) that continually change, along with the requirement for scalability and the retrieval of large amounts of data, a NoSQL database is the most suitable choice. NoSQL databases are designed to handle a wide variety of data types, are highly scalable, and can efficiently manage large volumes of unstructured data, which aligns with CMS's needs.

Question 9

Tables in a relational database must be connected in a meaningful order to allow for the retrieval of information. The design process for a database is referred to as
A) database diagraming.
B) entity modeling.
C) data modeling.
D) entity diagramming.

Accepted Answer

Data modeling is the process of creating a data model for the data to be stored in a database. This process involves defining and analyzing data requirements needed to support the business processes within the scope of corresponding information systems in organizations.

Question 10

The first step in data modeling is to identify the entities or tables that the database will need to capture in a
A) conceptual ERD.
B) logical ERD.
C) physical ERD.
D) All of these answer choices are correct.

Accepted Answer

The first step in data modeling involves creating a conceptual Entity-Relationship Diagram (ERD), which focuses on identifying the entities or tables and the relationships between them without getting into the details of database implementation.

Question 11

How do database designers identify the connections between entities?
A) Database designers consult with end users to understand how data is used.
B) Database designers analyze business events.
C) Database designers write statements of relationships based on business events.
D) All of these answer choices are correct.

Accepted Answer

Database designers use a combination of consulting with end users, analyzing business events, and writing statements of relationships based on those events to identify the connections between entities.

Question 12

Alice, a recent IT graduate, working in the database department is tasked with implementing the newly designed database for the company. Which type of ERD does Alice need to complete the task of database implementation?
A) Conceptual ERD
B) Logical ERD
C) Physical ERD
D) All of these answer choices are correct.

Accepted Answer

Physical ERD is specifically designed for the implementation phase of database design, detailing the database schema, including tables, columns, data types, and constraints, which are essential for actual database creation.

Question 13

Alfred took the conceptual ERD that Alice created and added field names for each table. Alfred's work resulted in a
A) physical ERD.
B) logical ERD.
C) conceptual ERD.
D) database ERD.

Accepted Answer

Adding field names to a conceptual ERD to specify details like data types and relationships without getting into the specifics of how the database will be physically implemented results in a logical ERD. This stage focuses on the structure and flow of data and is more detailed than a conceptual ERD but not as detailed as a physical ERD, which includes all constraints and indexes.

Question 14

Which of the following statements is FALSE?
A) Data redundancy occurs when the same piece of data is stored in more than one place.
B) Data redundancy could result in data integrity issues.
C) Relational databases use unique IDs and relationships to eliminate data redundancy.
D) Relational databases use cardinality and business rules to eliminate data redundancy.

Accepted Answer

Relational databases use unique IDs and relationships to manage data redundancy, not to eliminate it entirely. Cardinality and business rules help define the nature of relationships between data entities but do not directly eliminate data redundancy.

Question 15

Data integrity involves
A) managing data accuracy in a database.
B) managing consistency of data in a database.
C) ensuring management receives quality information for decision making from a database.
D) All of these answer choices are correct.

Accepted Answer

Data integrity involves managing data accuracy, consistency in a database, and ensuring that management receives quality information for decision-making, which encompasses all the options provided.

Question 16

Relational databases are designed to reduce redundancy by
A) not allowing more than 5 fields per table.
B) ensuring that the primary key is not null.
C) referencing needed data already stored in a different table.
D) storing duplicate data in foreign keys.

Accepted Answer

Relational databases reduce redundancy by referencing needed data already stored in a different table, rather than duplicating it. This is achieved through the use of foreign keys that reference primary keys in other tables, ensuring data consistency and minimizing storage space.

Question 17

The unique IDs that identify every record in a relational database are referred to as
A) keys.
B) data.
C) cardinals.
D) nulls.

Accepted Answer

Keys are used in relational databases to uniquely identify records. They ensure that each record can be precisely identified and accessed.

Question 18

The unique ID for a table is the
A) primary key.
B) foreign key.
C) referential integrity.
D) entity integrity.

Accepted Answer

The primary key uniquely identifies each record in a table. It cannot accept null values and must contain unique values to ensure that each row in the table can be uniquely identified.

Question 19

When a primary key is inserted into another table to create a relationship, the key in the related table is referred to as a
A) primary key.
B) foreign key.
C) relationship key.
D) unique key.

Accepted Answer

When a primary key from one table is inserted into another table to establish a relationship, it is referred to as a foreign key in the second table. This helps in maintaining referential integrity between the two tables.

Question 20

Referential integrity states that
A) the primary key cannot be null.
B) a foreign key cannot be inserted into a table unless it already exists as a primary key.
C) relational databases must reduce redundancy.
D) relational databases must manage data integrity, accuracy, and consistency.

Accepted Answer

Referential integrity ensures that a foreign key in one table must match a primary key in another table, preventing orphaned records and maintaining data consistency.

Quiz 6: Systems and Database Design

Which type of database stores structured data in two-dimensional tables?

In a relational database, data is stored in tables of related data. The database for Motorcycle Parts Warehouse has the following tables: Items, Employees, Sales, and Customers. Into which table would you insert a field to store the delivery address used to ship a customer their order?

An advantage that object-oriented databases have over relational databases are

Object-oriented databases group similar objects together in a

Attributes of an object in an object-oriented database are referred to as

NoSQL databases store data

What advantages does a NoSQL database have over an object-oriented and relational database?

Tables in a relational database must be connected in a meaningful order to allow for the retrieval of information. The design process for a database is referred to as

The first step in data modeling is to identify the entities or tables that the database will need to capture in a

How do database designers identify the connections between entities?

Alice, a recent IT graduate, working in the database department is tasked with implementing the newly designed database for the company. Which type of ERD does Alice need to complete the task of database implementation?

Alfred took the conceptual ERD that Alice created and added field names for each table. Alfred's work resulted in a

Which of the following statements is FALSE?

Data integrity involves

Relational databases are designed to reduce redundancy by

The unique IDs that identify every record in a relational database are referred to as

The unique ID for a table is the

When a primary key is inserted into another table to create a relationship, the key in the related table is referred to as a

Referential integrity states that