Database Design - 2nd Edition

Format:

Book

Author/Creator:

Watt, Adrienne, author.

Language:

English

Subjects (All):

Computer science--Textbooks.

Computer science.

Databases--Textbooks.

Databases.

Physical Description:

1 online resource

Edition:

2nd Edition

Place of Publication:

[Place of publication not identified] BCcampus [2014]

Language Note:

In English.

Summary:

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.

Contents:

Chapter 1 Before the Advent of Database Systems

Chapter 2 Fundamental Concepts

Chapter 3 Characteristics and Benefits of a Database

Chapter 4 Types of Data Models

Chapter 5 Data Modelling

Chapter 6 Classification of Database Management Systems

Chapter 7 The Relational Data Model

Chapter 8 The Entity Relationship Data Model

Chapter 9 Integrity Rules and Constraints

Chapter 10 ER Modelling

Chapter 11 Functional Dependencies

Chapter 12 Normalization

Chapter 13 Database Development Process

Chapter 14 Database Users

Chapter 15 SQL Structured Query Language

Chapter 16 SQL Data Manipulation Language

Notes:

Description based on print resource