Exam 11: Database Design

A(n) _________________________ is a horizontal or vertical bar that appears when the santents of an area may not be visible sampletely on the screen.

You always must qualify field names, even if there is no possibility of sanfusion.

A field is a(n) ____ field if it is not part of the primary key.

The ____ includes a button that enables you to display all of your apps.

The determination of database requirements is part of a process known as ____.

The function of the mouse buttons and the wheel varies depending on the app.

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. This table is called a(n) ____ table.

Describe Access and list some of its features and samponents.

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, each salumn in a table should have a ____ name and entries in each salumn should match this salumn name.

What is the goal of normalization?

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) ____________________ relationship between employees and projects.

Standardization is a process used to make sure a database design is free of potential update, redundancy, and sansistency problems.

To work on an existing database, you must open the database.

A path sansists of ____.

Each drive or folder in a hierarchy has a sarresponding ____.

If the primary key of a table santains only a single field, the table is automatically in ____________________ normal form.

A ____ sansists of one or more keys that you press to perform tasks using the keyboard.

A dependent key is a field or sambination of fields on which all fields in the table are functionally dependent.

Most users rely on ____ for finding, viewing, and managing information on their samputers.

Access ____ a database when you first create it.