Exam 10: Analyzing Database Design Using Northwind

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information. Suppose the student health database includes two tables, one table called Students that contains student information such as StudentID, student name, address, and telephone number and the other table called Documentation that contains several records for each student and records the dates and descriptions of various medical documents required by the university. What type of relationship would need to be established between the two tables?

A ____ is achieved by specifying the desired image using a report's Picture property.

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

In the figure above, all tables shown need to be directly related to all other tables in order to participate in a relational database.

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

A multi-field primary key uses ____.

The figure above is in ____ View.

One of the best ways to teach yourself advanced database skills is to study the sample Northwind database.

In the figure above, what is the primary key field of the Shippers table?

List three reasons why data normalization is valuable.

In the figure above, what type of control is to the left of the Employee Sales by Country label?

To move a field list in the Relationship window, drag its ____________________.

The Caption property keeps track of the order of the values in an indexed field.

In the figure above, what is true about the Order Details table?

A right join is the default join between two tables in an Access query. _________________________