FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Database Design Fundamentals

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

____ is the duplication of data.

A(n)____________________ is the association between entities.

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

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 matrix is the association between entities.

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

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

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.

A relationship is an association between ____________________.

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.

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

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

Columns are sometimes called tuples.

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

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

A tabular database is a collection of tables.