Exam 12: Database Design

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, the order of the rows and the order of the columns are _____.

A table is in third normal form (3NF) if it is in second normal form and if the only determinants it contains are _____ keys.

A tuple is a property of an entity.

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.

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. To convert the table to _____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.

Modified Multiple Choice Columns in a table often are called _____.

If there are two possibilities for a primary key, both fields are referred to as ____________________ keys.

The formal term for a table is _____.

Modified Multiple Choice Rows in a table often are called _____.

What is the goal of normalization?

When duplicate field names exist in a database, you need to indicate the field to which you are referring. You do so by writing both the table name and the field name separated by a _____.

The relationship between business analysts and clients is an example of a one-to-one relationship because one business analyst is associated with many clients, but each client has only one business analyst.

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

A table is in third normal form (3NF) if it is second normal form and if the only determinants it contains are candidate keys.

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered a(n) _____ key.

If a client can be offered many courses and each course is offered to many clients, there is a(n) _____ relationship between clients and courses.

The ____________________ key provides an important way of distinguishing one row in a table from another.

The process of determining the particular tables and fields that will make up a database is known as _____.