Database Design



Download free course Database Design, pdf file on 153 pages by Adrienne Watt.
Database Design, 2nd Edition covers database systems and database design concepts. New to this edition are SQL info, additional examples, key terms and review exercises at the end of each chapter.

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.

Table of contents

  • Before the Advent of Database Systems
  • Fundamental Concepts
  • Characteristics and Benefits of a Database
  • Types of Data Models
  • Data Modelling
  • Classification of Database Management Systems
  • The Relational Data Model
  • The Entity Relationship Data Model
  • Integrity Rules and Constraints
  • ER Modelling
  • Functional Dependencies
  • Normalization
  • Database Development Process
  • Database Users
  • SQL Structured Query Language
  • SQL Data Manipulation Language
  • University Registration Data Model Example
  • Sample ERD Exercises
  • SQL Lab with Solution
Pages153
Size2.8 MB
File typePDF
Downloads204
Created2022-02-02
LicenseCC BY
Author(s) Adrienne Watt
Cover of Database Design

Download