Topics Search

Relational Databases

Relational Databases
Views: 243
This tutorial covers what many people agree is one of the most difficult database conceptshow to create and work with . 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.
Sponsored Links:

More topics

 

Relational Databases and Database Applications

Preview
The first databases implemented during the 1960s and 1970s were based upon either flat data files or the hierarchical or networked data models. These methods of storing data were relatively inflexible due to their rigid structure and heavy reliance on applications programs to perform even the most routine processing.
In the late 1970s, the relational database model which originated in the academic research community became available in commercial implementations such as IBM DB2 and Oracle. The relational data model specifies data stored in relations that have some relationships among them (hence the name relational).
 

Understanding Data Relationships

Preview
Access is not restricted, however, in how you can organize your data. It also lets you set up relational databases. In this tutorial, you will learn what a relational database is and how to create one in Access.
By the time you finish this tutorial, you will understand the following key concepts: what a relational database is, how information in tables can be related, why keys are important in a relational environment, how to create a relationship between two tables and what referential integrity means.
 

MS-Access 2007 Table creation

Preview
Relational databases are constituted by one or more tables than contain the information in an organized form. Databases usually contain more than one table and each one will have a fixed number of fields.
 

Help, Tutorials and Tips

Preview
Microsoft Access is a database management system (DBMS). It lets you create relational databases, which means that Access databases can link to tables that have similar fields. Access databases are the workhorses of many offices, often used for mailing lists, phone lists, and as address books. But there's a lot more to Access than that, as the articles in this section prove.
 

Tips and Tutorials

Preview
Microsoft Access is a database management system (DBMS). It lets you create relational databases, which means that Access databases can link to tables that have similar fields. Access databases are the workhorses of many offices, often used for mailing lists, phone lists, and as address books. But there's a lot more to Access than that, as the articles in this section prove.
 

Working with Databases: Using Access 2007, 2010, and 2013

Preview
When you have a lot of data to organize, putting it into a database can be a big help. The right software makes it easy for you to add new data, to edit existing data, to sort data, and to group your data into useful forms and reports.
These lessons will introduce you to some simple types of databases in Project 1. The later projects will teach you about relational databases, using Microsoft Access.
 

RDBMS Basics (Relational Database Management System)

Preview
Basically RDBMS (Relational Database Management System) is nothing but a standard. For many years database industry was not having any standard for storing and retrieving information. As a result of this standard we came up the language called SQL or Structured Query Language. We use SQL to communicate with RDBMS databases including but not limited to MS Access, Oracle, MS SQL Server etc. MS Access databases used to have file extension as .mdb but in 2007 release the default extension is .accdb.
 

Designing Good Relational Databases

Preview
Databases have a reputation for being difficult to construct and hard to maintain. The power of modern database software makes it possible to create a database with a few mouse-clicks. The databases created this way, however, are typically the databases that are hard to maintain and difficult to work with because they are designed poorly. Modern software makes it easy to construct a database, but doesn't help much with the design aspect of database creation.
Database design has nothing to do with using computers. It has everything to do with research and planning. The design process should be completely independent of software choices.
 

Using Access 2007, 2010, and 2013

Preview
When you have a lot of data to organize, putting it into a database can be a big help. The right software makes it easy for you to add new data, to edit existing data, to sort data, and to group your data into useful forms and reports.
These lessons will introduce you to some simple types of databases in Project 1. The later projects will teach you about relational databases, using Microsoft Access.
 

Learn Database SQL Technology

Preview
Structured Query Language (SQL) is a language that was developed by IBM for processing data in mainframe databases. The relational nature of databases and the ease of SQL usage has made SQL the standard language for databases. SQL technology is also standardized which makes it ideal for usage across multiple fields. Learning SQL database technology will enable you to program and maintain any database with ease.