Relational Databases - Understanding database concepts!
Tutorials Shared by the Internet Community
Total Hits - 36902
Total Votes - 119 votes
Vote Up - 53 votes
Vote Down - 66 votes
Domain - www.brainbell.com
Category - MS Access/Building Databases
Submitted By - Shekhar
Submitted on - 2008-04-15 06:11:04
A relational database contains two or more tables that are related to each other in some way. For example, a database might contain a Customers table and an Invoices table that contains the customer's orders.
In this tutorial you will learn how to link tables in an existing database together in a one-to-many relationship to create a relational database. You will also learn how to enforce referential integrity between those tables to keep records in related fields valid and accurate.
Relational databases can be confusing at first, so we'll take things slowly and explain everything in great detail as we go. Let's get started! More detail...