MidTerm Study Flashcards
T/F: 2 tables can be linked or joined together through a common field.
True
Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?
A. 1NF
B. 2NF
C. 3NF
D. 4NF
A. 1NF
Which of the following is used to create and maintain the physical database?
A. SQL
B. schema
C. DBMS
C. DBMS
What represents a characteristic or attribute that is being collected about an entity?
A. Row
B. Tuple
C. Column
D. Field
D. Field
T/F: Tables can be linked or joined together through their primary keys.
False
For every occurance of A, there can only be one occurance of B.
This is an example of what type of relationship?
A. One-to-One
B. One-to-Many
C. Many-to-Many
A. One-to-One
A field in the logical design of a database corresponds to a ____ in the physical database.
A. Row
B. Column
C. Field
D. Entity
B. Column
Which of the following is used to determine the correct organization for data that is to be stored in a database?
A. SDLC
B. DBMS
C. Data Model
D. Normalization
D. Normalization
A(n) ____________________ table can be added to the physical database to eliminate a many-to-many relationship.
Bridging
If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?
A. One-to-One
B. One-to-Many
C. Many-to-Many
C. Many-to-Many
Which of the following is used to uniquely identify each record?
A. Foreign Key
B. Unique Field
C. Primary Key
D. Relation
C. Primary Key
T/F: The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.
True
T/F: The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.
True
A composite primary key can lead to what?
A. Transitive Dependencies
B. Partial Dependencies
C. Total Dependencies
B. Partial Dependencies
A ____ is a group of interrelated files.
A. database
B. field
C. column
D. entity
A. database
T/F: A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.
True
In a real-world environment, we must strike a balance between design integrity and ____.
A. ease of use
B. stability
C. flexibility
D. efficiency
C. flexibility
T/F: Repeating groups must be eliminated by making sure that each row defines a single entity.
True
An attribute that is part of a key is known as a(n) ____ attribute.
prime
A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
A. duplicate group
B. repeating group
C. multi-valued
B. repeating group
A relational table must not contain a(n) ____.
repeating group
Dependencies based on only a part of a composite primary key are called ____ dependencies.
partial
T/F: Normalization should be performed after the design process
False
Should be done during the design process
Normalization works through a series of stages called ___________________ forms
normal
Because a partial dependency can exist only if a table’s primary key is composed of several attributes, a table whose ____________________ key consists of only a single attribute is automatically in 2NF if it is in 1NF.
primary
