The practical significance of taking the logical view of a database is that it
serves as a reminder of the simple file concept of data
... [Show More] storage.
True
You can think of a table as a persistent representation of a logical relation.
True
The order of the rows and columns is important to the DBMS.
False
Character data can contain any character or symbol intended for mathematical
manipulation.
False
The row's range of permissible values is known as its domain.
False
Each table _____ represents an attribute.
column
Date attributes contain calendar dates stored in a special format known as the
_____ date format.
Julian
A table is also called a(n) _____ because the relational model's creator, E. F.
Codd, used the two terms as synonyms.
relation
In a relational table, each column has a specific range of values known as the
_____ domain.
attribute
_____ logic, used extensively in mathematics, provides a framework in which an
assertion (statement of fact) can be verified as either true or false.
Predicate
Each table in a relational database must have a primary key.
True
The idea of determination is unique to the database environment.
False
Only a single attribute, not multiple attributes, can define functional
dependence.
False
Only a single attribute, not multiple attributes, can define functional
dependence.
False
If the attribute (B) is functionally dependent on a composite key (A) but not on
any subset of that composite key, the attribute (B) is fully functionally
dependent on (A).
True
A null is created when you press the Enter key or the Tab key to move to the
next entry without making a prior entry of any kind.
True
Depending on the sophistication of the application development software, nulls
can create problems when functions such as COUNT, AVERAGE, and SUM are used.
True
In the relational model, _____ are important because they are used to ensure
This study source was downloaded by 100000830214522 from CourseHero.com on 11-12-2021 08:04:40 GMT -06:00
https://www.coursehero.com/file/29561013/ConceptModelstxt/
This study resource was
shared via CourseHero.com
that each row in a table is uniquely identifiable.
keys
A _____ is any key that uniquely identifies each row.
superkey
A _____ key can be described as a minimal superkey, a superkey without any
unnecessary attributes.
candidate
A _____ is the primary key of one table that has been placed into another table
to create a common attribute.
foreign key
A _____ key is defined as a key that is used strictly for data retrieval
purposes.
secondary
A(n) _____ join links tables by selecting only the rows with common values in
their common attribute(s).
natural [Show Less]