ABSTRACT
This chapter describes a methodology to build an entity-relationship model. In this chapter we present best practices for the design of an information model with an eye towards its implementation as a relational database. The chapter introduces SQL, a query language for relational databases. The chapter explains how to use the four SQL commands necessary to create, read, update, and delete data. To deliver a quality database, it needs to be non-redundant and avoid data anomalies. This is done through normalization. The chapter describes how to bring an information model to third normal form.
