Database Modeling and Design

Database systems and database design technology have significant growth in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your business?

In the extensively revised fourth edition, you can see any SQL-based system . But you'll also be able to get a lot of help developing industrial-sized systems.

+ a detailed look at the Unified Modeling Language (UML-2) as well as the application-relationship (ER).
+ the details and examples of the data modeling concepts in the logical database design;
+ the fundamentals of database normalization through the fifth normal form;
+ practical coverage of the major issues in business intelligence - data warehousing, and OLAP for decision support systems, and data mining;
+ examples for the most popular CASE tools to handle complex data modeling problems.
+ Exercises that test understanding of all material, plus solutions for many exercises.

Chapter 1 Introduction
Chapter 2 The Entity-Relationship Model
Chapter 3 Unified Modeling Language
Chapter 4 Requirements Analysis and Conceptual Data Modeling
Chapter 5 Transforming the Conceptual Data Model to SQL
Chapter 6 Normalization
Chapter 7 An Example of Logical Database Design
Chapter 8 Business Intelligence
Chapter 9 CASE Tools for Logical Database Design
Appendix The Basics of SQL