This second edition of Database Design book covers the concepts used in database systems and the database design process. Topics include: The history of databases -- Characteristics and benefits of databases -- Data models -- Data modelling-- Classification of database management systems -- Integrity rules and constraints -- Functional dependencies -- Normalization Database development process.
New to this edition are more examples, highlighted and defined key terms, both throughout and at the end of each chapter, and end-of-chapter review exercises. Two new chapters have been added on SQL, along with appendices that include a data model example, sample ERD exercises and SQL lab with solutions.