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
