Purchase Solution

Relational Database Components

Not what you're looking for?

Ask Custom Question

I need help with doing some web search research on relational databases and explain briefly how such a database works, and basic components. Then, go to a website with a data entry form and discuss that form in terms of a relational model. I also want to include important information about linking two flat files, what information goes into each file, and what may possibly be used as a key field.

Purchase this Solution

Solution Summary

The relational database components are examined.

Solution Preview

1. How do relational databases work?

Relational databases are software programs, which store, organize, and manage access to data. A simple relational database would be a text file. If you store first name and last name in each row in the file, like this:

Joe Smith
Anna Leopard
Jenny Brown

This above is a list of rows, and columns. At a basic level this is a database. In a next text file you could put the age of each person:

Joe 23
Anna 18
Jenny 32

Each of these files would be considered a "table". Each line is a "row", and each column a "field". The two files relate to each other by the first name of the person. That's how it is relational. Most databases will have internal controls to make sure the relations are valid and cannot be broken. The primary key in our files would the first name of the person. This is obviously a poor decision, because if we try to add Joe Shmoe, the name Joe is ...

Purchase this Solution

Free BrainMass Quizzes
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.

Basic Networking Questions

This quiz consists of some basic networking questions.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

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.

C++ Operators

This quiz tests a student's knowledge about C++ operators.