Request for consultation
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.
- Updated diagrams, boxes, and tables that visually reinforce key concepts.
- There are now 13 chapters instead of 12, and there will be a Bibliography at the end of the book, rather than a separate endnotes section in each chapter. Appendix C and D have been deleted.
- Offers substantial coverage of higher degree relationships and other complex relationships in the entity-relationship diagram.
- Presents unique features under the topic of normalization rarely found in business database books.
- Includes in-depth coverage of relational algebra supported by a significant number of examples of their operationalization in ANSI/ISO SQL.
- Provides an extensive discussion of conceptual data modeling.
- Features challenging end-of-chapter exercises that provide opportunity to learn and assimilate through practice.
Part I: CONCEPTUAL DATA MODELING.
2. Foundation Concepts.
3. Entity-Relationship Modeling.
4. Enhanced Entity-Relationship (EER) Modeling.
5. Modeling Complex Relationships.
Part II: LOGICAL DATA MODELING.
6. The Relational Data Model.
Part III: NORMALIZATION.
7. Functional Dependencies.
8. Normal Forms Based on Functional Dependencies.
9. Higher Normal Forms.
Part IV: DATABASE IMPLEMENTATION USING THE RELATIONAL DATA MODEL.
10. Database Creation.
11. Relational Algebra.
12. Structured Query Language (SQL).
13. Advanced Data Manipulation Using SQL.