Chapter 4 Flashcards
A data dictionary contains metadata - data about date.
True
Current relational database software generally provides only a system catalog (and not a data dictionary).
True
As rare as 1:1 relationships should be, certain conditions absolutely require their use.
True
____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
Predicate
The relational model’s creator, E.F. Codd, used the term relation as a synonym for _____.
Table
Date attributes contain calendar dates stored in a special format known as the ____ date format.
Julian
In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.
Keys
The attribute B is ____ the attribute A if each value in column A determines one and only one value in column B.
Functionally Dependent On
A ____ key is any key that uniquely identifies each row.
Superkey
Controlled ____ makes a relational database work.
Redundancy
A ____ key is defined as a key that is used strictly for data retrieval purposes.
Secondary
All primary key entries are unique, and no part of a primary key may be ____.
Null
____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
SELECT
The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.
Not null
____ combines all rows from two tables, excluding duplicate rows.
UNION
A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s).
Natural
In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.
Null
A ____ contains at least all of the attribute names and characteristics for each table in the system.
Data Dictionary
In a database context, the word ____ indicates the use of the same attribute name to label different attributes.
Homonym
The ____ relational type if the “relational model ideal.”
1:M
Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes - as foreign keys - at least the ____ keys of the tables that are to be linked.
Primary
A(n) ____ is an ordered arrangement of keys and pointers.
Index
Codd’s Rule of ____ state:
Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original tables values (changing order of columns or inserting columns).
Logical Data Independence
To make a new table using SQL, you would use the CREATE TABLE command with mandatory appropriate data types specified for each of the attributes in the table.
True
To permanently delete a table (its structure’s existence), including any and all data it may have populated within it, which would be the SQL DDL command to accomplish that:
DROP TABLE
The following single SQL command would actually define a structure and build a table, in this case for a table named COMPANY, within a relational database.
Also, it would not create any data within the table, but would be ready for SQL statements to follow up with populating the table given that it is now implemented.
Please assume syntax is correctly specified:
CREATE TABLE Company (
Co_Code INTEGER NOT NULL UNIQUE,
Co_Name VARCHAR(30) NOT NULL,
Co_Contact VARCHAR(30) NOT NULL,
Co_State CHAR(2) NOT NULL.
Co_Start_Dt DATE,
PRIMARY KEY (Co_Code) );
True
An ERM is dependent on the database type.
False
The word “entity” in the ER model corresponds to a table.
True
The ER diagram represents the conceptual database as viewed by the end user.
True
The ER model refers to a specific table row as an entity instance.
True
In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name.
True
Attributes are types of entities.
False
In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.
True
Software vendors have adopted the Chen representation because of its compact representation.
False
Attributes cannot share a domain.
False
In an ER diagram, primary keys are usually bolded.
False