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