Data Modelling & Database Design

Description

Data Modeling and Database Design presents a conceptually complete coverage of indispensable topics that each MIS student should learn if that student takes only one database course. Database design and data modeling encompass the minimal set of topics addressing the core competency of knowledge students should acquire in the database area. The text, rich examples, and figures work together to cover material with a depth and precision that is not available in more introductory database books.

CONTENTS:

Database Systems: Architecture and Components

Foundation Concepts

Entity-Relationship Modeling

Enhanced Entity-Relationship (EER) Modeling

Modeling Complex Relationships

The Relational Data Model

Functional Dependencies

Normal Forms Based on Functional Dependencies

Higher Normal Forms

Database Creation

Data Manipulation: Relational Algebra and SQL

Advanced Data Manipulation Using SQL

Appendix A: Data Modeling Architectures Based on the Inverted Tree and Network Data Structures

Appendix B: Object-Oriented Data Modeling Architectures

Appendix C: Overview of SQL Reserved Words

Appendix D: SQL SELECT Statement Features