Database Design - 2nd Edition - Saylor Academy

Database Design - 2nd Edition

Database Design - 2nd Edition

Adrienne Watt Nelson Eng

Unless otherwise noted within this book, this book is released under a Creative Commons Attribution 3.0 Unported License also known as a CC-BY license. This means you are free to copy, redistribute, modify or adapt this book. Under this license, anyone who redistributes or modifies this textbook, in whole or in part, can do so for free providing they properly attribute the book. Additionally, if you redistribute this textbook, in whole or in part, in either a print or digital format, then you must retain on every physical and/or electronic page the following attribution: Download this book for free at Cover image: Spiral Stairs In Milano old building downtown by Michele Ursino used under a CC-BY-SA 2.0 license .

Database Design - 2nd Edition by Adrienne Watt and Nelson Eng is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted

Contents

Preface

vi

About the Book

vii

Acknowledgements

viii

Chapter 1 Before the Advent of Database Systems

1

Adrienne Watt

Chapter 2 Fundamental Concepts

6

Adrienne Watt & Nelson Eng

Chapter 3 Characteristics and Benefits of a Database

9

Adrienne Watt

Chapter 4 Types of Data Models

13

Adrienne Watt & Nelson Eng

Chapter 5 Data Modelling

15

Adrienne Watt

Chapter 6 Classification of Database Management Systems

21

Adrienne Watt

Chapter 7 The Relational Data Model

24

Adrienne Watt

Chapter 8 The Entity Relationship Data Model

29

Adrienne Watt

Chapter 9 Integrity Rules and Constraints

44

Adrienne Watt & Nelson Eng

Chapter 10 ER Modelling

55

Adrienne Watt

Chapter 11 Functional Dependencies

61

Adrienne Watt

Chapter 12 Normalization

66

Adrienne Watt

Chapter 13 Database Development Process

74

Adrienne Watt

Chapter 14 Database Users

82

Adrienne Watt

Chapter 15 SQL Structured Query Language

83

Adrienne Watt & Nelson Eng

Chapter 16 SQL Data Manipulation Language

94

Adrienne Watt & Nelson Eng

Appendix A University Registration Data Model Example

113

Appendix B Sample ERD Exercises

117

iv

Appendix C SQL Lab with Solution

120

About the Authors

127

v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download