CGS 2060 Database

Complex Database

Amazon.com allows you to search for thousands of items using images and information that are organized logically; much storage and management requires a ---

Database --- System

Management; Because Microsoft Access includes that only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities

Integrity

a centralized database can help improve data ----

Table

a collection of related records in a database

Multidimensional

a complex database that organizes and stores information in a cube format and measure attributes and feature attributes

Distributed Database

a database that stores in different physical locations and that users access though client/server networks

Database Field

a group of related characters in a database table that represents a characteristic of someone or something

Traditional Filing System Advantages

can hold larger amounts of data; can provide better data integrity

what field name will the data fall under; what data type will be included

data definition that tells users how each unit of data is defined in the database; Which elements are used to describe this data?

Data Administration

data recovery, support, and maintaining and securing the database

Database List

in 1984 Santa used this

Record

in a database view of relational database (Microsoft Access) a row of information

Database Hierarchy

structured in a hierarchy with characters starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table.

Logical View

the DBMS engine provides an interface for the end user of the database

Application General Subsystem

the DBMS subsystem that allows for form creation

Forms

to control how information is entered into a database, programmers create --- to help ensure data integrity

Reports

to display or distribute information from a database, programmers or database administrators

Query

to search a database for information

Database Fields

a group of related characters in a database; represents a characteristic of someone and something; Primary key is field designation

Relationship

a link between tables in a relational database that defines how data is related

Data Structure

an integral part of the database management system (DBMS) is the data definition subsection; uses a data schema called this

Data Manipulation Subsystem

the DBMS subsystem that provides for data maintenance and data analysis and the generation of reports

Relational Database

type of database that uses common fields to create links between tables

Data Type

what element of a database field specifies the data in a field such as text, numeric, and date/time

Foreign Key

when you need to link 2 tables in a database that don't have a field in common, one solution is to create a --- in one table that links to the primary key in the other table