Table of Contents

Part I: DATABASE CONCEPTS
1. Database Systems
2. Data Models
Part II: DESIGN CONCEPTS
3. The Relational Database Model
4. Entity Relationship (ER) Modeling
5. Advanced Data Modeling
6. Normalization of Database Tables
Part III: ADVANCED DESIGN AND IMPLEMENTATION
7. Introduction to Structured Query Language (SQL)
8. Advanced SQL
9. Database Design
Part IV: ADVANCED DATABASE CONCEPTS
10. Transaction Management and Concurrency Control
11. Database Performance Tuning and Query Optimization
12. Distributed Database Management Systems
13. Business Intelligence and Data Warehouses
14. Big Data Analytics and NoSQL
Part V: DATABASES AND THE INTERNET
15. Database Connectivity and Web Technologies
Part VI: DATABASE ADMINISTRATION
16. Database Administration and Security
ONLINE APPENDICES
Appendix Aa: Designing Databases with Lucicharts: A Tutorial
Appendix Ab: Designing Databases with Visio: A Tutorial
Appendix B: The University Lab: Conceptual Design
Appendix C: The University Lab: Conceptual Design Verification, Logical Design, and Implementation
Appendix D: Converting the ER Model into a Database Structure
Appendix E: Comparison of ER Model Notations
Appendix F: Client/Server Systems
Appendix G: Object-Oriented Databases
Appendix H: Unified Modeling Language (UML)
Appendix I: Databases in Electronic Commerce
Appendix J: Web Database Development with ColdFusion
Appendix K: The Hierarchical Database Model
Appendix L: The Network Database Model
Appendix M: Microsoft Access Tutorial
Appendix N: Creating a New Database Using Oracle 12c
Appendix O: Data Warehouse Implementation Factors
Appendix P: Working with MongoDB
Appendix Q: Working with Neo4j

About the Author

Carlos Coronel is currently the Lab Director for the College of Business Computer Labs at Middle Tennessee State University. He has more than 29 years of experience in various fields as a Database Administrator, Network Administrator, Web Manager, and Technology Specialist. He has taught courses in Web development, database design and development, and data communications at the undergraduate and graduate levels. Steven Morris completed his Bachelor of Science and Ph.D. from Auburn University. He has taught Database Design and Development, Database Programming with Advanced SQL and PL/SQL, Systems Analysis and Design, and Principles of MIS at Middle Tennessee State University. Steven has published many articles, and currently serves on the review boards of several journals.