K201 CHAPTER 5

Byte

A character of data

Database

A self-describing collection of integrated records

What is a database?

A self-describing collection of integrated records

How is a data model transformed into a database design?

By defining foreign keys

Database Application

Collection of forms, reports, queries, and application programs that process a database

A Key (Primary Key)

Column or group of columns that identifies a unique row in a table

Metadata

Data that describes data

Relational Databases

Databases that carry their data in the form of tables that represent relationships using foreign keys

Personal DMBS

Designed for smaller, simpler database applications

Foreign Keys

Keys of a different (foreign) table than the one in which they reside

Enterprise DBMS

Process large organizational and work group databases

Normalization

Process of converting a poorly structured table into two or more well structured tables

Database Management System (DBMS)

Program used to create, process and administer a database

Database Application System

Systems that make database data more accessible and useful

How are data models used for database development?

They describe the data and relationships that will be stored in the database

How do database applications make databases more useful?

They make data more accessible and purposeful

What is the purpose of a database?

To keep track of things

What are the components of a database application system?

User (you), Database Application (forms, reports, queries, application and programs), DBMS and Database (tables, relationships and metadata

What is the users' role in the development of databases?

Users should review and approve the data model