|
Data Modelling & Database Design
Data Modeling and Database Design presents a conceptually complete coverage of indispensable topics that each MIS student should learn if that person takes only one database course. Data modeling and database design encompass the minimal set of topics with which students should be comfortable. The text, rich examples, and figures work together to cover
material with a depth and precision that is not available in database books oriented toward broad coverage of a wide variety of topics.
* 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 relationship algebra supported by a significant number of examples of their operationalization in ANSI/ISO SQL.
* Provides a plethora of diagrams, boxes, and tables that visually reinforce key concepts.
* Features exercises at the end of each chapter that provide opportunity for practice and skill application.
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
|
