DSS Midterm

A database stores......

• Data

• Relationships

• Applications

• Both data and relationships are correct

A program whose job is to create, process, and administer databases is called a.......

• database modeling system

• database management system

• data business model system

• relational model manager

The smallest unit of data a computer can handle is called a:

• file

• record

• field

• byte

• bit

In a business relational database, tables contain:

• one table for each entity

• relations among entities

• bytes

• three-dimensional relations

• links to other tables

A characteristic or quality describing an entity is called a(n):

• field

• tuple

• key field

• attribute

• table

In a table for customers, the information about a single customer would reside in a single:

• field

• entity

• column

• table

• row

Relational databases organize data into two-dimensional tables, called ____ with columns and rows.

• tuples

• key field

• attributes

• fields

• relations

A schematic of the entire database that describes the relationships in a database is called a(n):

• data dictionary

• intersection relationship diagram

• field key diagram

• data definition diagram

• entity-relationship diagram

A DBMS makes the:

• relational database available for different analytical views

• logical database available for different analytical views

• physical database available for different relational views

• relational database available for different physical views

• physical database available for different logical views

The logical view of a database:

• shows how data are organized and structured on the storage media

• presents an entry screen to the user

• allows the creation of supplementary reports

• presents data as they would be perceived by end users

• shows the relationships between entities and attributes