
71
Chapter 3
Table Normalization and
Windows Azure SQL Database
Objectives
◾ Learn in detail about database tables
◾ Identify problems in table structures
◾ Normalize tables
◾ Convert a data model to a relational database
3.1 Introduction
Once a data model is developed, the next task is to convert the data model to a relational data-
base. e goal of this chapter is to prepare for and carry out the conversion of a data model to a
relational database. A relational database is constructed with tables and relationships among these
tables. Your first task is to study table structures. Concepts such as relations, keys, and functional
dependency will be ...