Module 8

synonymous with columns; the fields associated with an entity.

Attributes

____________ critical integity constraints enforce businees rules vital to an organization's success and often require more insight and knowledge

Business

Defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer

Business rule

Enforces business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Business-critical integrity constraints

3 Terms that represent data elements associaed with an entity:

Columns, Attributes, & Fields

compiles all the metadata about the data elements in a data model

Data dictionary

Two terms representing the smallest or basic unit of infomation.

Data element/field

Maintains information about various types of objecs, events, people, and places

Database

synonymous with table; stores information about a person, place, thing or event.

Entity

3 Business adavantages of a relational database.

Increased: Flexibility, informaton integrity, information security, scalability & performance Reduced: Information Redundance

The measure of the quality of information

Information integrity

The duplication of data, or storage of the same data in multiple places is...

Information redundancy

Provides details about data

Metadata

The ___________ view of information deals with the physical storage of information on a storage device.

Physical

Field that uniquely identifies a given record in a table

Primary key

A tool that helps users graphically design the answer to a question against a database.

Query-by-example

__________ integrity constraints are rules that enforce basic and fundamental information-based constraints

Relational

Allows users to create, read, update, and delete data in a relational database

Relational database management system

Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.

True

Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information-searching tasks.

True

Integrity _________ are rules that help ensure the quality of information.

constraints

The ____________ view of information focuses on how individual users logically access information to meet their own particular business needs.

logical

Data __________ are logical data sructures that detail relationships among data elements using graphics or pictures

models

While a database has only _____ physical view, it can easily support multiple _________ views that provides for flexiblity.

one; logical

Primary goal of a database is to eliminate infomation redundancy by recording each piece of information in ________ place in the database

only one

a collection of related data elements; Occupies one row in its respective table.

record

A ________ query language asks users to write lines of code to answer questions against a datbase.

structured