Databases - Chapter 3

Form

• Used to collect data

• A type of document

• A method of analysis

• A visual representation

Query

• Search database by asking a question

• Browse database manually

• Use keywords to filter results

• Access database through a GUI

3 relationship types

• one-to-one

• one-to-few

• one-to-many

• many-to-many

Report

• Used to present results from queries

• A document for internal communication

• A summary of financial transactions

• A list of employee names

Key field/primary key

• Holds unique data

• Stores multiple values

• Is optional for database entries

• Can be duplicated

Field

• Represented by a column

• Represented by a row

• Represented by a table

• Represented by a cell

Referential integrity

• table relationships must always be consistent

• data must be stored in a specific format

• tables can have duplicate entries

• relationships can be ignored during data entry

Record

• Represented as a row in a table

• A collection of related fields

• A type of database query

• An operation to retrieve data

Database

• Electronic filing cabinet

• Physical storage unit

• Data processing center

• Information retrieval system

Relationships

• Link 2 or more tables

• Combine multiple data types

• Sort data in ascending order

• Filter data based on criteria