Chapter 15: Introduction to Database Concepts

For two tables to be related, they must share a common field.

True

Inconsistency is the main reason to avoid redundancy of information in a database.

True

Queries are also used to create views

True

Relationships are part of the metadata of a database.

True

the logical database shows users the view of the information that they need and want

True

In a one-to-one relationship, the shared field between two tables cannot be unique.

false

Relationships are specified by the user of a database

false

What operation combines two tables based on matching fields? A) Join operation B) Bind operation C) Combine operation D) Unite operation

A

Relationships: A) are not relevant in building the logical database B) establish a correspondence between the columns within a table C) should be given meaningful names to assist those who work with the database D) all of the above

B

The key field for the student database on a campus is probably the student: A) address B) ID C) phone D) last name

B

An attribute or set of attributes that could potentially be chosen as the table's key is a: A) primary key B) secondary key C) candidate key D) provisional key

C

Relationships in a database schema show how: A) data types of all attributes within each table B) queries are related to one another C) information in a table is related to information in another table D) fields are related to one another in a table

C

A logical database: A) is created from existing information B) is created fresh each time it is needed C) may combine information from multiple tables D) all of the above

D

Which is true about a row in a table? A) A technical term for a row is a tuple. B) A row is often called a record. C) A row is an entity instance, defining one particular object. D) all of the above

D

The logical database is the permanent repository of the data

False

To successfully use a database, a user must be able to write SQL.

False

Access to sensitive information in a database should be limited.

true

In relational databases, think of an attribute as a "column of a table," where the "attribute names" are column headings and "attribute values" are the entries.

true

Relationships connect rows of one table with rows of another table.

true