Database Concepts Chapter 4
Which of the following are properties of relations?
-Unique name -Every attribute value must be atomic -Every row must be unique -Columns must have unique names -The order of the rows and columns must be irrelevant
True or False: Data integrity consists of powerful operations to manipulate data stored in relations.
?
True or False: Data structures include data organized in the form of tables with rows and columns.
?
An alternative name for an attribute
Alias
In the SQL language, the ________ statement is used to make table definitions.
CREATE TABLE
A primary key that consists of more than one attribute is called a
Composite PK
The relational data model consists of which components?
Data structure (tables), manipulation (SQL), and integrity
A non-key attribute is also called a(n)
Descriptor
The attribute on the left-hand side of the arrow in a functional dependency is the
Determinant
A domain definition consists of the following components:
Domain name, meaning, data type, size (or length), and allowable values/range (if applicable)
A primary key whose value is unique across all relations
Enterprise key
The ________ states that no primary key attribute may be null
Entity integrity constraint
True or False: A composite key consists of only one attribute.
False
When all multivalued attributes have been removed from a relation, it is said to be in
First Normal Form
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a
Foreign Key
A constraint between two attributes is called a(n)
Functional dependency
An attribute that may have more than one meaning
Homonym
Which of the following anomalies results from a transitive dependency?
Insertion, Deletion, and Modification
Which of the following are anomalies that can be caused by redundancies in tables?
Insertion, deletion, and modification
________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.
Integrity
All of the following are the main goals of normalization EXCEPT
Maximize storage space
The entity integrity rule states that
No primary key attribute may be null. All primary key fields MUST contain data values.
A functional dependency in which one or more non-key attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.
Partial functional
An attribute (or attributes) that uniquely identifies each row in a relation is called a
Primary Key
A rule that states that each foreign key value must match a primary key value in the other relation is called the
Referential integrity constraint
A two-dimensional table of data sometimes is called a
Relation
When a regular entity type contains a multivalued attribute, one must
Remove them
A relation that contains no multivalued attributes and has non-key attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?
Second
Two or more attributes having different names but the same meaning
Synonyms
A functional dependency between two or more non-key attributes
Transitive dependency
A relation that contains minimal redundancy and allows easy use is considered to be
Well-structured
Understanding the steps involved in transforming EER diagrams into relations is important because
if you do it incorrectly, you won't have a well-structured relation.
A candidate key must satisfy all of the following conditions EXCEPT
the key must indicate the row's position in the table