This book takes an approach to database design to teach the reader how to reach into the inner depths of an organization to understand the business needs, data, and daily processes that will all blend together to formulate a successful database. Much emphasis is placed on logical design as it is imperative to understand the inner workings of an organization to produce the highest quality database, while proactively eliminating future problems that are not so easy for a beginner to foresee. Additionally, topics such as change control, business rule integration, database security implementation, and legacy database redesign are covered in detail. Examples of SQL code are shown to portray implementation tasks of a relational database. Examples are compliant with ANSI standard.

Hide more