Chapter 6

An "entity" in databases means something that can store information.

• true

• false

In databases, characteristics that describe an entity are called:

• record

• file

• attribute

• tuple

Which one about the traditional environment of database management is NOT true?

• poor security

• lack of flexibility

• lack of data sharing

• higher cost

Database management systems can help solve data issues of traditional environment, NOT including:

• reduce data redundancy

• eliminate data inconsistency

• improve data security

• reduce data cost

Which is NOT true about relational database management systems?

• data shown in two dimensions

• data shown in rows and columns

• data shown in tables

• data only shown in fields

The field/attribute that uniquely identities a record is called:

• key attribute

• unique field

• identifying record

• primary key

Primary key used in a second table as look-up field to identify records from the original table is ____.

• look up key

• second key

• foreign key

• original key

Three basic operations of relational DBMS do not include:

• select

• relate

• join

• project

In database management, SQL stands for:

• successful quality logic

• sequential query logic

• structured query logic

• structured query language

In database management, ____ refers to streamlining complex data to minimize redundant elements and awkward relationships.

• data streamlining

• data redundancy

• data relationships

• normalization