Database Management Systems (DBMS)

Index to Articles

Introduction to Database Concepts
Defines DBMS and gives examples of common applications. Defines and describes DBMS terminology, including fields, records, and tables. Discusses the principles of relational databases and gives illustrated examples of one-to-many and many-to-many relations and the role played by primary and foreign keys.


Rationalizing Database Structures
Covers operation symbols used for math, string manipulation, logic, and comparison expressions. Includes order of precedence and truth table.


Math, Comparison, and Logical Operator Symbols
Covers operation symbols used for math, string manipulation, logic, and comparison expressions. Includes order of precedence and truth table.


Introduction to MS-Access
A quick review of basic database terms such as table, record, field, etc and an overview of the MS-Access DBMS. Describes the MS-Access program window as well as the purpose and characteristics of the common MS-Access database objects, including queries, forms, and reports.


Database Management Systems
Provides a list of database management systems which have been available on the personal computer over the years.


Case Studies


Illustrated examples of database designs which include fields, tables, relationships, and keys.


Club Membership
Mail Order Invoicing Database
Adult Ed Center
Boat Rental: Reservations
Boat Rental: Reservation & Billing
Dairy Milking Service
Social Security Contributions
Marketing Data Database
Magazine Subscriptions

Bruce Miller, 2014