Database Principles

Peter Rob has 32 years experience teaching file systems, database systems design, database design, database applications development, and more. Peter's real-world experience includes two years as a Director of Operations at an aviation chart company, 20 years as a consultant for hands-on operations systems analysis/development and database systems design, and 15 years experience as a statistical quality control systems analysis and systems/applications developer. 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. Dr Keeley Crockett is a Reader in Computational Intelligence in the School of Computing, Mathematics and Digital Technology at Manchester Metropolitan University. She gained a BSc Degree (Hons) in Computation from UMIST in 1993, and a PhD in the field of machine learning in 1998 entitled Fuzzy Rule Induction from Data Domains". She has been teaching within the field of database systems and data engineering for 14 years to both undergraduate and postgraduate students. She is a member of the Intelligent Systems Group which has established a strong international presence in its research into Conversational Agents and Adaptive Psychological Profiling including an international patent on "Silent Talker". She has published over 50 refereed conference papers and journal articles in major international conferences and journals. She is the current Chair of the IEEE Women into Computational Intelligence (2012) and a senior member of the IEEE Computational Intelligence Society" Steven Morris completed his Bachelor of Science and PhD 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.

PART I: DATABASE SYSTEMS
1. The Database Approach
2. Data Models
3. Relational Model Characteristics
4. Relational Algebra
PART II: DATABASE ALTERNATIVES
5. Data Modeling with Entity Relationship Diagrams
6. Data Modeling Advanced Concepts
7. Normalizing Database Designs
PART III: DATABASE PROGRAMMING
8. Beginning Structured Query Language
9. Procedural Language SQL and Advanced SQL
PART IV: DATABASE DESIGN
10. Database Development Process
11. Conceptual, Logical and Physical Database Design
PART V: IMPLEMENTATION ALTERNATIVES
12. Managing Transactions and Concurrency
13. Managing Database and SQL Performance
PART VI: DATABASE MANAGEMENT
14. Distributed Databases
15. Databases for Decision Support
16. Interacting with Databases Through the Web
ONLINE APPENDICES (Available on CourseMate)
Appendix A: Designing Databases with Visio Professional: A Tutorial
Appendix B: The University Lab : Conceptual, Logical and Physical Database Design
Appendix C: Global Tickets Ltd: Conceptual, Logical and Physical Database Design
Appendix D: Converting an ER model into a Database Structure
Appendix E: Comparison of ER Modelling Notations
Appendix F: Client /Server Systems
Appendix G: Object-Orientated Databases
Appendix H: Databases in e-Commerce
Appendix I: The Hierarchical Database Model
Appendix J: The Network Database Model
Appendix K: Database Administration
Appendix L: Data warehouse implementation factors
Appendix M: Creating a new database using ORACLE 11g
Appendix N: A Guide to using SQL Developer with ORACLE 11g
Appendix O: Building a simple Object-relational database using ORACLE Objects
Appendix P: Microsoft access tutorial