Database Concepts Test #1 chapter 1 & 2

A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n) constraint

Referential Integrity

A(n)________________is a unique, numeric value that is appended to the relation to serve as the primary key.

Surrogate Kay

A composite key is made up of two or more attributes

True

A relational database can be defined as a self-describing collection of related tables

True

By separating data into tables containing data only one theme each, making changes to the data is simplified

True

Every cell in a relation can hold only a single value

True

Metadata is the data about our tables and other structures that is stored in the database.

True

The first step of the normalization process is to identify all the candidate keys ofd a relation.

True

To create a well-formed relation through normalization, every determinant must be a candidate key.

True

To represent a relationship in the relational model, the primary key of one relation is placed into a second relation

True

In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that:

A. A. The relation is well formed.

A key that contains more than one attribute is called a(n):

A. Composite key

Why do we want to keep data in a database instead of just keeping it in a spreadsheet?

B. Spreadsheets can contain modification problems.

STUDENT (SID, StudentName, Major, AdvisorID) ADVISOR (AdvisorID, AdvisorName, Office, Phone) Given the relations above such that each student is assigned to one advisor, which of the following is true?

C. AdvisorID is a foreign key

During the normalization process, the remedy for a relation that is not well-formed is to:

C. Break it into two or more relations that are well-formed

Which of the following is NOT a basic component of a database system?

C. ERD

When the primary key of one relation is placed into a second relation, it is called a:

C. Foreign Key

Which of the following terms is synonymous with "relation"?

C. Table

Today almost every commercial database is based on:

C. The relational model

A key that contains two or more attributes is called a(n) _________________key.

Composite Key

Which of the following is a function of the DBMS in a database system?

D. Perform backup and recover

A candidate key is:

E, a) and c)

Which of the following are true about null values?

E. All of the above

Which of the following is true about a key?

E. All of the above

A surrogate key may be appropriate under which of the following circumstances?

E. both A and C

The recognized author of the Relational model is _______________.

E.F. Codd Codd EF Co9dd Edgar Frank Codd Edgar Codd Any of these are acceptable

A key must be unique

False

Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems

False

In the relational model, each row of a table contains data that represents an attribute of the entity.

False

Normalization is the process of removing all functional dependencies from a relation

False

Null values are represented with a zero in their cell.

False

SQL stands for Structural Question Language (SQL)

False

When using SQL to create a table, specifying the NULL property for a column indicates that only null values may be stored in that column'

False

Data that the database keeps about its own structure is called___________________

Metadata