Cloud Database Development and Management

Table Normalization and Windows Azure SQL Database  ◾  111

3.5 Summary

In this chapter, we have discussed tables, table normalization, and transferring a data model

to a relational database. At the beginning of the chapter, the concepts of tables and functional

dependencies were introduced. We discussed the table components and how to link two tables

with a shared column. e definitions of primary keys and foreign keys were presented. Before

a data model can be converted to a relational database, you need to properly normalize the

table structures. During the normalization process, you may need to modify the initial E–R

model. You may need to add or remove some of the entities or attributes based on the result of

normalization. In a normali