Purchase Solution

relational database

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

A relational database is emphasized.

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 ...

Purchase this Solution

Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.