IST 210 Midterm

63 terms by KaitRO

Create a new folder

Advertisement Upgrade to remove ads

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 ___________________________________________.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set