Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
A table is in BCNF if every determinant in the table is a candidate key.
Because every request for structural changes requires retracing the SDLC steps, the
system is always at some stage of the SDLC.
Usually, the native database connectivity interface provided by the vendor is not the
only way to connect to a database; most current DBMS products support other database
connectivity standards, the most common being ODBC.
In today's Internet environment, the DBA must also work with ____________________
and network administrators to implement efficient and secure Web-to-database
connectivity.
U.S. state abbreviations are always two characters, so ____________________(2) is a
logical choice for the data type representing a state column.
A dependency based on only a part of a composite primary key is called a(n)
____________________.
A(n) ____________________ is a unique name by which the data source will be known
to ODBC, and therefore, to applications.
A(n) ____________________ derives its name from the fact that a group of multiple
entries of the same type can exist for any single key attribute occurrence.
A transaction processor is also known as the ____________________ processor.
In a 1:M relationship, you must alwayscreate the table for the ____________________
side first.
List and describe some typical DBMS processes.
Explain the "no change over time" characteristic of a good primary key.
The ____________________ clause of the GROUP BY statement operates very much
like the WHERE clause in the SELECT statement.
Composite keys are useful as identifiers of weak entities, where the weak entity has a
strong ____________________ relationship with the parent entity.
A(n) ____________________ joinreturns not only the matching rows but also the rows
with unmatched attribute values for one or both tables to be joined.
A table is in BCNF if every determinant in the table is a foreign key.
Explain how database designers design and normalize databases.
What do business rules require to be effective?
Although the DBMS is designed to recover a database to a previous consistent state
when an interruption prevents the completion of a required set of transactions, the
transactions themselves are defined by the end user or programmer and must be
semantically correct.
Indexes are very useful in small tables or tables with low sparsity.
