Exam 2: Database Design Fundamentals

When you convert an unnormalized table to a table in first normal form,the primary key of the table in first normal form is usually the concatenation of at least two columns.

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

Many organizations and institutions are moving toward using Social Security numbers as primary keys because of privacy issues.

When you write a column in the format CUSTOMER.REP_NUM,you say that you ____________________ the column name.

A(n)____________________ is the association between entities.

A(n)____________________ is a person,place,thing,or event for which you want to store and process data.

A table's design should be as simple as possible;you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n)____________________ group)in an individual location in the table.

Each column in a table of a relational database should have a distinct name.

Columns are sometimes called tuples.

____ is the formal term for combining two or more columns to form a primary key.

The same column name can appear in two different tables in a relational database.

A relationship is an association between ____________________.

A tabular database is a collection of tables.

A(n)____________________ column is a column that is not part of the primary key.

A matrix is the association between entities.

In an entity-relationship (E-R)diagram,____ are used to represent an entity.

____ is the duplication of data.

How does a DBMS that follows the relational model handle entities,attributes of entities,and relationships between entities?

The process of determining the particular tables and columns that will comprise a database is known as database design.

Which of the following is the primary key of the ORDER_LINE (ORDER_NUM,ITEM_NUM,NUM_ORDERED,QUOTED_PRICE)table?