How can we help?

You can also find more resources in our Help Center.

63 terms

IST 210 Midterm

STUDY
PLAY
Metadata
provides a description of the data characteristics and the set of relationships that link the data found within the database.
Database Management System
The ______________________ serves as the intermediary between the user and the database.
Data inconsistency
exists when different versions of the same data appear in different places.
Enterprise
An _____________ database is used by an organization and supports many users across many departments.
Distributed
A _____________ database supports data distributed across several different sites.
Data warehouse
The _______ ____________ structure is quite different from that of an operational or transactional database.
Unstructured
_____________ data exists in a format that does not lend itself to processing that yields information.
Record
A __________ is a logically connected set of one or more fields that describes a person, place, or thing.
Single user
A desktop database is a _______ ________ database.
Entity
An _________ is anything about which data are to be collected and stored.
Attributes
An _____________ is the equivalent of a field in a file system.
Constraints
__________ are important because they help to ensure data integrity.
Many-to-many
Students and classes have a ____-___- ____ relationship.
a detailed description of an organizations operations.
Business rules are derived from _________________________________________.
Used to define entities, attributes, relationships, and constraints
Which is true of business rules?
Entity
A noun in a business rule translates an _______ in the data model.
Relationship
A verb associating two nouns in a business rule translates to a _____________ in the data model.
Entity relationship (ER)
The _________ ______________ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
Conceptual
A _____________ model represents a global view of the database as viewed by the entire organization.
False
The order of the rows and columns is important to the DBMS.
True
Numeric data are data on which you can perform meaningful arithmetic procedures.
True
A data dictionary contains metadata - data about data.
Keys
In the relational model, ______ are important because they are used to ensure that each row in a table is uniquely identifiable.
Determines
In the context of a database table, the statement "A __________ B" indicates that if you know the value of attribute A, you can look up the value of attribute B.
Key attribute
Any attribute that is part of a key is known as a _____ __________.
Null
No data entry at all is known as a ______.
Redundancy
Controlled ___________ makes a relational database work.
Integrity
Referential __________ means that if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
Secondary
A ____________ key is defined as a key that is used strictly for data retrieval purposes.
Null
A primary key entries are unique, and no part of a primary key may be _____.
Intersect operator
The ________ _________ yields only the row that appear in both tables.
1:1
The ____ relationship should be rare in any relational database design.
Primary
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.
Index
An _________ is an ordered arrangement of keys and pointers.
Composite
A ___________ identifier is composed of more than one attribute.
Composite
A __________ attribute can be further subdivided to yield additional attributes.
Weak
When the PK of one entity does not contain the PK of a related entity, the relationship is ______.
1,1
The Crow's foot symbol with two parallel lines indicates _________ cardinality.
Binary
A _________ relationship exists when two entities are associated.
Ternary
A _________ relationship exists when three entities are associated.
Binary
__________ relationships are most common.
Recursive
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ________ relationship.
Associative
An ______________ entity is composed of the primary keys of each of the entities to be connected.
Specialization hierarchy
The relationships depicted within the _____________ ______________ are sometimes described in terms of "is-a" relationships.
Generalization
______________ is the bottom-up process of identifying a higher-level, more generic entity super type from lower-level entity subtypes.
Surrogate
The most important characteristic of an entity is its ______________ key, used to uniquely identify each entity instance.
Natural key or Natural identifier
A _______________ ( or ___________) key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
Redundant
____________ relationships occur when there are multiple relationship paths between related entities.
3NF
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.
First three stages of normalization
1NF, 2NF, and 3NF are _______________________________.
4NF
Some very specialized applications may require normalization beyond the ______.
Determines
Attribute A ___________ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
Repeating groups
A relational table must not contain a _____________ ________.
Partial
Dependencies based on only a part of a composite primary keys are called ________ dependencies.
2NF
A table that is in 1NF and includes no partial dependencies is said to be in ______.
2NF
Before converting a table into 3NF, it is imperative that the table already be in ______.
3NF
A table that is in 2NF and contains no transitive dependencies is said to be in ______.
Numeric
The most likely data type for a surrogate key is ___________.
Flexibility
In a real-world environment, we must strike a balance between design integrity and ___________.
3NF
For most business transactional databases, we should normalize relations into ______.
AutoNumber
To generate a surrogate key, Microsoft Access uses an _____________ data type.
Make sure entities are in normal form
When designing a database, you should __________________________________________.
Compromises that may include denormalization
The conflicts between design efficiency, information requirements, and processing speed are often resolved through ___________________________________________.