Database final pt. 1
A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes?
candidate key
Data redundancy produces ____.
data integrity problems
n-compatible" means that the _____?
names of the relation attributes must be the same and their data types must be alike
T or F: The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.
true
T or F:Normalization works through a series of stages called normal forms?
true
T or f: All relational tables satisfy the 1NF requirements?
true
The _____ relationship should be rare in any relational database design.
1:1
_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity?
Cardinality
expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.?
Cardinality
A table can be deleted from the database bu using the ___ command?
Drop table
T or F: A table is in BCNF if every determinant in the table is a foreign key?
False
T or F: All SQL commands must be issued on a single line?
False
A determinant is any attribute whose value determines other values within a column?
False(Row)
A _____ is any key that uniquely identifies each row?
Superkey
T or F: M:N relationships are not appropriate in a relational model?
True
Each table _____ represents an attribute?
column
The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.
entity
A dependency of one nonprime attribute on another nonprime attribute is a partial dependency?
false
A _____ is the primary key of one table that has been placed into another table to create a common attribute?
foreign
A table is in 4NF if it is in 3NF, and _____?
it has no multivalued dependencies
A(n) _____'s main function is to help one understand the complexities of the real-world environment?
model
Dependencies based on only a part of a composite primary key are known as _____ dependencies?
partial
A verb associating two nouns in a business rule translates to a(n) _____ in the data model?
relationship
A relational table must not contain a(n) _____.
repeating group
When using the Crow's Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity.?
solid
Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process?
three
T or F: Each table in a relational database must have a primary key.
True
T or F: SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
True
T or F:Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence?
True
When you define a table's primary key, the DBMS automatically creates a(n) _____ index on the primary key column(s) you declared?
unique
In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities?
(min, max)
A table that is in 2NF and contains no transitive dependencies is said to be in _____?
3nf
T or F: Most SQL implementations yield case-insensitive searches?
False
T or F: The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.?
False
A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values?
Outer
The SQL command that allows a user to list the contents of a table is _____?
Select
T or F: The DIVIDE operation uses one single-column table (e.g., column "a") as the divisor and one two-column table (e.g., columns "a" and "b") as the dividend?
True
T or F: 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
T or F: All relational tables satisfy the 1NF requirements.
True
T or F: Business rules must be rendered in writing.
True
T or F: Data type selection is usually dictated by the nature of the data and by the intended use?
True
T or F: Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF?
true
When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be _____.
union compatible
