Fundamentals of Data, Information, and Databases

Data

consists of raw facts.

Raw

indicates that the facts have not yet been processed to reveal their meaning.

Information

is the result of processing raw data to reveal its meaning.

Information

can be used as the foundation for decision making.

FILE

A collection of related records.

Data processing

can be as simple as organizing data to reveal patterns or as complex as making forecasts or drawing inferences using statistical modeling.

Knowledge

implies familiarity, awareness, and understanding of information as it applies to an environment.

Database

is a shared, integrated computer structure that stores a collection of data and metadata.

End-user data or data

raw facts of interest to the end user.

Metadata, or data about data

describes the data characteristics and the set of relationships that links the data found within the database.

Database design

It refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

DATA

raw facts, such as a telephone number, a birth date, a customer name, and a year-to-date (ytd) sales value.

FIELD

A character or group of characters (alphabetic or numeric) that has a specific meaning.

RECORD

A logically connected set of one or more fields that describes a person, place, or thing.

Business Rules

A brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

Business rules

set the stage for the proper identification of entities, attributes, relationships, and constraints.

Noun

in a business rule will translate into an entity in the model.

Verb

that associates the nouns will translate into a relationship among the entities.

Relational Database

Table is perceived as a two-dimensional structure composed of rows and columns.

Row

represents a single entity occurrence within the entity set.

Column

represents an attribute, and each column has a distinct name.

Attribute Domain

Each column has a specific range of values known as the______.

Keys or Superkeys

In the relational model, _____are important because they are used to ensure that each row in a table is uniquely identifiable.

Key

consists of one or more attributes that determine other attributes.

Composite key

is a key that is composed of more than one attribute.

Candidate key

is a minimal superkey—that is, a superkey without any unnecessary attributes.

Candidate keys

they are the eligible options from which the designer will choose when selecting the primary key.

Primary Key (PK)

is the candidate key chosen to be the primary means by which the rows of the table are uniquely identified.

Entity Integrity

is the condition in which each row (entity instance) in the table has its own unique identity.

Foreign Key (FK)

is the primary key of one table that has been placed into another table to create a common attribute.

Entity

is an object of interest to the end user.

Attributes

are characteristics of entities.

Required Attribute

is an attribute that must have a value; in other words, it cannot be left empty.

Optional Attribute

is an attribute that does not require a value; therefore, it can be left empty.

Composite Attribute

is an attribute that can be further subdivided to yield additional attributes.

Simple Attribute

is an attribute that cannot be subdivided.

Single-Valued Attributes

is an attribute that can have only a single value.

Multivalued Attributes

attributes that can have many values.

Derived Attributes

The attribute need not be physically stored within the database; instead, it can be derived by using an algorithm.

Cardinality

expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

SQL

A database language allows you to create database and table structures, perform basic data management chores (add, delete, and modify), and perform complex queries designed to transform the raw data into useful information.

Data Manipulation Language (DML)

SQL includes commands to insert, update, delete, and retrieve data within the database tables.

Data Definition Language (DDL)

SQL includes commands to create database objects such as tables, indexes, and views, as well as commands to define access rights to those database objects.

Transaction Control Language (TCL)

The DML commands in SQL are executed within the context of a transaction, which is a logical unit of work composed of one or more SQL statements, as defined by business rules.

Data Control Language (DCL)

commands are used to control access to data objects, such as giving a one user permission to only view the PRODUCT table, and giving another user permission to change the data in the PRODUCT table.

Character Data

is composed of any printable characters such as alphabetic values, digits, punctuation, and special characters.

Numeric Data

is composed of digits, such that the data has a specific numeric value.

Date Data

composed of date and, occasionally, time values.

SELECT

specifies the attributes to be returned by the query.

FROM

specifies the table(s) from which the data will be retrieved.

WHERE

filters the rows of data based on provided criteria.

GROUP BY

groups the rows of data into collections based on sharing the same values in one or more attributes.

HAVING

filters the groups formed in the GROUP BY clause based on provided criteria.

ORDER BY

sorts the final query result rows in ascending or descending order based on the values of one or more attributes.