SQLConfiguration SQLConfiguration

Relational Concepts  «Prev  Next»
Lesson 9

Relational Concepts Conlusion

This module introduced you to several key points regarding relational concepts. Having completed this module, you should now be able to:
  1. Define a SQL Server table
  2. Describe the elements of a basic table
  3. Explain why data integrity is important
  4. Explain how to enforce entity and relational integrity
  5. Describe how tables are normalized or denormalized and why
  6. Define null values and why they are important

Glossary terms

This module introduced you to the following terms:
  1. clustered index: A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages
  2. data integrity: Data integrity is the maintenance of, and the assurance of the accuracy and consistency of, data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data
  3. denormalize: Denormalization is a strategy used on a previously-normalized database to increase performance.
  4. entity: An entity is any object in the system that we want to model and store information about. Entities are usually recognizable concepts, either concrete or abstract, such as person, places, things, or events which have relevance to the database.
  5. entity integrity:Entity integrity is a basic constraint of database relational model (abbreviated RM) that refers to the morphology of the primary key but afterwards, the same format is applied to the foreign key and, also to any of simple components of any of two.
  6. foreign key:A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables.
  7. identity flag: An identity flag is an attribute that ensures that values in a column are automatically incremented and unique within the column
  8. normalize
  9. primary key:A column whose values uniquely identify a row in a table.
  10. relational integrity:Guaranteeing the quality of data between tables in a database by enforcing the relationships between those tables.
  11. unique key:One or more columns that cannot contain duplicate data in a table. Similar to a primary key, except that it doesn’t have to uniquely identify a row of data.
In the next module, you will learn about Structured Query Language (SQL), the standard language used by all relational databases.

Relational Concepts - Quiz

Before moving on to the next lesson, click the Quiz link below to check your knowledge of relational concepts with a short, multiple-choice quiz.
Relational Concepts - Quiz