Exam 1 Comprehensive Review - CIS 3060, Database Management Systems

Chapter 1 Quiz (Database Systems), Chapter 2 Quiz (Data Models), Chapter 3 Quiz (The Relational Database), Chapter 4 (Entity Relationship Modeling), Chapter 6

Which of the following statements is true?

A DBMS is a set of processes that manage and control access to data stored in the database.

Which of the following is not an advantage of a DBMS?

Complexity

What is the result of redundant data in the database?

Data anomalies that lead to data inconsistencies

What are the components of database systems?

Hardware, software, people, procedures, data

Which of the following statements best defines a record?

A record is a set of logically connected fields.

Which of the following is not a disadvantage of DBMS?

Data Integration

Which of the following is not a function of a DBMS?

User Management

Which of the following is not a valid statement?

Raw data is the collection of processed knowledge.

Which of the following is not a valid statement?

Production databases focus primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making.

Which of the following lists problems with file system data processing?

Development complexity, administration complexity, and lack of security

Which of the following is a fundamental data modeling component, helping ensure data integrity?

Constraint

Which of the following is not a valid business rule?

An invoice must be paid in a reasonable amount of time.

Why is identifying and documenting business rules essential to database design?

It helps to standardize the company's view of data.

Which of the following two-dimensional structures is known as a relation?

Table

In an entity relational model (ERD), what is each row in a table known as?

An entity occurrence

Which of the following is a disadvantage of various database models?

System complexity

Which of the following entity relationship (ER) connectivity statements is invalid?

A CUSTOMER gender is MALE or FEMALE

Which of the following is not a valid component of object-oriented data models?

Volume

A CEO of a company wants to find a new and improved way to manage and extract business insights from large amounts of web- and sensor-generated data. Which of the following could they use to achieve this goal?

Big Data

Which of the following technologies is not used in Big Data?

SQL

Which of the following is not a valid characteristic of a relational table?

All values in a column may have different data formats.

Which of the following statements best describes a functional dependency?

The value of one or more attributes determines the value of one or more other attributes.

Which of the following is not a legitimate DB key in a relational model?

Entity Key

Which of the following statements best defines the purpose of entity integrity?

It guarantees each entity has a unique value for the primary key and that there are no null key values.

Dr. Codd published a list of 12 relational database rules in 1985; which of the following is not a valid rule?

Any database view that is theoretically updatable must be updated outside of the database structure.

Which of the following best describes an index?

An index is an orderly arrangement used to logically access rows in a table.

A composite entity is also referred to as a _____ entity.

bridge

The proper use of foreign keys _____ data redundancies and the chances that destructive data anomalies will develop.

minimizes

Which of the following statements best defines a data dictionary?

The data dictionary provides a detailed description of all tables in the database created by the user and designer.

Which of the following is not a valid relational set operator?

ADD Operator

When working with entity relationship models (ERM), which of the following is not a valid statement regarding an entity?

An entity is an object of interest to the end designer.

In an entity relationship model (ERM), attributes are characteristics of entities. Which of the following statements best describe an optional attribute?

An optional attribute is an attribute that does not require a value and can be left empty.

What type of attribute allows for no more than one value?

Single-valued attribute

The CUSTOMER entity includes the attributes CUST_LNAME, CUST_FNAME, CUST_PHONE, and CUST_PHONE_TYPE. The CUST_PHONE_TYPE attribute stores the string "HOME, WORK, MOBILE, OTHER". Which term best describes CUST_PHONE_TYPE?

Multivalued attribute

A derived attribute is an attribute whose value is calculated (derived) from other attributes. What is not an advantage of storing derived attributes in the database?

Uses CPU processing cycles

What type of entity can exist in the database only when it is associated with another related entity?

Existence-dependent

What element expresses the specific number of entity occurrences associated with an occurrence of a related entity?

Cardinality

A relationship degree indicates the number of entities or participants associated with a relationship. Which is not a valid relationship that's specifically named?

Quarterly relationship

Database designers must often compromise design due to conflicting goals. What are examples of contradictory goals in database design?

Design standards, processing speed, and information requirements

While a relationship degree indicates the number of entities associated with a relationship, which relationship type is within a single entity type?

Recursived relationship

Normalization is a process for evaluating and correcting table structures to minimize _____.

data redundancy and anomalies

Which of the following is false about unnormalized data?

Unnormalized data is related data.

Which of the following is NOT true?

Fourth normal form (4NF): 3NF and no dependent multivalued dependencies

Which of the following statements best describes partial dependency?

A partial dependency exists when there is a functional dependence in which the determinant is only part of the primary key.

Which of the following statements best defines transitive dependency?

d. A condition in which an attribute is dependent on another attribute that is not part of the primary key

Repeating group is defined as _____.

a characteristic describing a group of multiple entries of the same or multiple types for a single key attribute occurrence

Atomicity refers to?

An attribute is atomic that cannot be further subdivided.

Which of the following is not valid about the ER model?

Should contain redundant relationships except as required

Which of the following is not valid related to attribute naming convention?

Should not use the entity abbreviation as a prefix

Which of the following is valid?

Each entity should represent a set of distinguishable entity instances.

STUDENT_ID Consistent or Inconsistent?

Inconsistent

STUDENT_NAME Consistent or Inconsistent?

Consistent

ADDRESS Consistent or Inconsistent?

Consistent

CITY Consistent or Inconsistent?

Inconsistent

STATE Consistent or Inconsistent?

Inconsistent

PHONE Consistent or Inconsistent?

Inconsistent

Your company is concerned there is a problem with the design of some of the database tables. They want you to look at the tables and determine if there is a problem. Management is concerned about data anomalies and data redundancies. They have stressed it is important to have correct design as it is used for making decisions and used as a basis for reports in the various departments.

Examine the fields in each table and determine if the table is designed correctly or incorrectly.

STUDENT TABLE

Incorrect

Your company is concerned there is a problem with the design of some of the database tables. They want you to look at the tables and determine if there is a problem. Management is concerned about data anomalies and data redundancies. They have stressed it is important to have correct design as it is used for making decisions and used as a basis for reports in the various departments.

Examine the fields in each table and determine if the table is designed correctly or incorrectly.

ADVISOR TABLE

Correct

Your company is concerned there is a problem with the design of some of the database tables. They want you to look at the tables and determine if there is a problem. Management is concerned about data anomalies and data redundancies. They have stressed it is important to have correct design as it is used for making decisions and used as a basis for reports in the various departments.

Examine the fields in each table and determine if the table is designed correctly or incorrectly.

DORM TABLE

Incorrect