Exam 7: Database Systems

Attributes are usually selected to capture the relevant characteristics of entities.

Shauna is the Database Administrator for an online store that sells cosmetics. They grew so fast that they ended up with seven different databases, and Shauna is now investigating how to set up a centralized database approach. -One of the first benefits to a centralized database approach that Shauna discovers is the relationship between the data and the application program. All of the following statements are true EXCEPT: ____.

The functions of a DBMS include all of the following EXCEPT: ____.

-Referring to the figure above, it is clear that ____ are combined to make a field.

A(n) ____ is a characteristic of an entity.

Object-relational databases combine features of the object-oriented model with the relational model. _________________________

A database, a DBMS, and the application programs that utilize the data in the database make up a database ____.

Credit card companies use the customer's credit card expiration date as the primary key. _________________________

Oracle, Sybase, and IBM databases are examples of ____ database software that can be used by most organizations for many different types of applications.

In general, a data ____ language is a specific language provided with the DBMS that allows people and other database users to access, modify, and make queries about data contained in the database and to generate reports.

A(n) ____ application interacts with other programs and databases; it interacts only indirectly with users.

____ of data is a measure of the changes, such as additions, deletions, or modifications, typically required in a given period of time.

Sky computing refers to accessing data and information services from the Internet utilizing a standard Web-based interface.

A collection of related records is a file, also called a ____ in some databases.

A(n) ____ is a field in a record that is used to identify the record.

The object-oriented model encapsulates ____ functionality in software objects.

Good data should be all of these EXCEPT: ____.

A(n) ____ consists of a group of programs that manipulate the database and provide an interface between the database and the user or the database and application programs.

How is data organized when using a relational database model? Please define these terms as they are used when working with relational databases: relations, selecting, and joining.

Employee number, last name, first name, hire date, and department number are ____ for an employee.