Explore BrainMass

relational database

Solution provides an introduction to relational databases and Microsoft Access. It defines relational databases and describes some of the basics of creating relational databases.

© BrainMass Inc. brainmass.com June 21, 2018, 6:11 am ad1c9bdddf

Solution Preview

Relational Database - Definition

A database is an electronic storage system for data in raw form which can be used to glean information about that data in a useful and helpful form. A database system, such as a program like Microsoft Access, allows you to gain information from the database as a whole or select parts of the database, because all of the separate parts of the database are connected together.

A relational database contains several different units of data storage, called tables. Each table will contain fields that store information. An example of a field label would be "last_name" or "postal_code". An example of a table name would be "customer_addresses". The relational database allows you to connect several tables together. For example, a store might have a customer information database. The owner could query the database for information such as: a list of all customers that live on Oak Drive who bought more than $50 worth of merchandise in the last year. The ability to do this depends on a sound database structure.

The ability to have many tables, all connected together in one database, allows you to avoid repetition of data. For example, one table would be called "customer_addresses", and it would contain fields such as "last_name", "first_name", "street_address", etc. Another table in the database might be called "customer_accounts". This table could use ...

Solution Summary

A relational database is emphasized.