Database

False

Database applications are seldom intended for use by a single user.

modification anomalies

For some relations, changing the data can have undesirable consequences called

creating, processing and administrating databases

Functions of a DBMS

database

Helping people keep track of things is the purpose of a

False

Microsoft Access is an enterprise-class database product.

True

Ordered Columns are not a restriction for a table to be a relation

record

Row is synonymous with the term:

True

The XML family of standards is very important in database processing today

candidate keys

The primary key is selected from the:

False

The purpose of a database is to help people stop using spreadsheets.

IDMS

Which product implemented the CODASYL DBTG model

Microsoft's Access

A DBMS that combines a DBMS and an application generator is

True

A database administrator designs, constructs, and manages the databases.

True

A database design may be based on existing data.

False

A database has a built-in capability to create, process and administer itself

True

A database has data and relationships

True

A database is called "self-describing" because it contains a description of itself

attributes

A functional dependency is a relationship between or among:

identifies a row.

A key:

Domain/key normal form

A relation in this form is free of all modification anomalies.

True

A relation is a two-dimensional table.

two-dimensional table.

A relation is considered a

A tuple is a

A tuple is a

multi-user database application

An Enterprise Resource Planning application is an example of a

single-user database application

An application where only one user accesses the database at a given time is an example of a

column of a table

An attribute is a

e-commerce database application

An on-line commercial site such as Amazon.com is an example of a

True

Any table that meets the definition of a relation is said to be in first normal form.

False

Applications are programs that interact directly with the database.

self-describing

Because it contains a description of its own structure, a database is considered to be

False

Enterprise Resource Planning (ERP) is an example of a single user database

A → B

If attribute A determines both attributes B and C, then it is also true that:

(A,B) is a composite determinant.

If attributes A and B determine attribute C, then it is also true that:

False

In a relation, the order of the rows matters.

True

In a relation, the rows are sometimes called "records"

True

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.

False

In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

foreign keys

In the relational model, relationships between relations or tables are created by using:

False

One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.

True

Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

True

SQL is an internationally recognized standard language that is understood by all commercial database management system products.

Structured Query Language

SQL stands for

True

Splitting the relation into two relations, each with a single theme is one solution to the multivalued dependency constraint problem

relation

Table is synonymous with the term

Database application and the database

The DBMS acts as an interface between what two components of an enterprise-class database system?

False

The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle.

False

The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.

Oracle Corporation's Oracle

The DBMS that is most difficult to use is

normal forms.

The different classes of relations created by the technique for preventing modification anomalies are called:

True

The relational database model was created by E.F. Codd.

Key

What is a group of one or more attributes that uniquely identifies a row?

DB2

What products was an early implementation of the relational model developed by E.F. Codd of IBM?

R:base

What was the first product to implement true relational algebra in a PC DBMS?

referential integrity constraint

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created

v

You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at