Relational Concepts  «Prev  Next»

Lesson 1

Relational Database Concepts

Before you can create databases and other database objects, it's important that you understand basic relational concepts. Without such understanding, you will not be able to implement your databases effectively.
This module outlines some basic principals of relational databases.

Learning objectives

After completing this module, you will be able to:
  1. Define a SQL Server table
  2. Describe the elements of a basic table
  3. Define data integrity and explain how to enforce it.
  4. Define data normalization and denormalization
  5. Recognize candidates for data normalization and denormalization
  6. Explain when to use primary and foreign keys
  7. Define null values

Logical Data Independence

The ability to make changes to the logical layer without disrupting existing users and processes is called logical data independence. It is the transformation between the logical layer and the external layer that provides logical data independence. As with physical data independence, there are degrees of logical data independence. It is important that you understand that most logical changes also involve a physical change. For example, you cannot add a new database object (such as a table in a relational DBMS) without physically storing the data somewhere; hence, a corresponding change is made in the physical layer. Moreover, deletion of objects in the logical layer will cause anything that uses those objects to fail but should not affect anything else. Here are some examples of changes in the logical layer that can be safely made thanks to logical data independence:
  1. Adding a new database object
  2. Adding data items to an existing object
  3. Making any change in which a view can be placed in the external model that replaces (and processes the same as) the original object in the logical layer, such as combining or splitting existing objects
In the next lesson, you will learn all about the concepts underlying relational databases.