Designing Relational Databases
http://www.kpiusa.com/BRBook/Files/Designing Relational Databases.pdf

KPIUSA

Abstract:

The phrase database design means the set of steps, techniques, guidelines, and tools for translating a logical data model into a database specification. The database design consists of a structural representation, but may also include an integrity representation for rules enforcement. The structural representation is usually a database design diagram, from which you generate database-specific definitions. The integrity representation can take many forms from database specifications that define rule enforcements in the dbms layer, program specifications that define rule enforcements in object methods or other implementation, as well as specifications that define rule enforcement in a rules layer. Think of relational database design as a process for transforming the Logical Data Model into a relational database where the database design preserves the high quality properties of the Logical Data Model described in the book.