Database Principles

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. 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, and a PhD in the field of machine learning entitled ‘Fuzzy Rule Induction from Data Domains’. She has been teaching within the field of database systems and data engineering for 20 years to both undergraduate and postgraduate students. She leads the Computational Intelligence Research Lab which has established a strong international presence in its research into Adaptive Psychological Profiling using artificial intelligence, fuzzy systems and natural language dialogue systems. She has published over 120 refereed conference papers and journal articles in major international conferences and journals. She is an active volunteer in the IEEE and is currently a member of the IEEE Women in Engineering Leadership committee amongst many other roles. Keeley is also proud to be a STEM Ambassador with a passion for outreach in computer science in rural schools. Dr Craig Blewett has been researching and teaching in the area of Information Systems and Technology for over 25 years. His Masters explored the application of Artificial Intelligence to database transaction management. His PhD, in education technology, resulted in the development of the Activated Classroom Teaching (ACT) model, a unique approach to teaching with technology. Craig is the founder of multiple technology companies and is the author of numerous books covering topics such as computer literacy, database systems, teaching with technology, running, and active living. He is also an internationally acclaimed speaker who is using his innovative approaches to help change education in our rapidly changing digital world.

• Part I: Database Systems Chapter 1: The Database ApproachChapter 2: Data ModelsChapter 3: Relational Model CharacteristicsChapter 4: Relational Algebra and CalculusPart II: Database AlternativesChapter 5: Data Modelling with Entity Relationship DiagramsChapter 6: Data Modelling Advanced ConceptsChapter 7: Normalising Database DesignsPart III: Database ProgrammingChapter 8: Beginning Structured Query LanguageChapter 9: Procedural Language SQL and Advanced SQLPart IV: Database DesignChapter 10: Database Development ProcessChapter 11: Conceptual, Logical and Physical Database DesignPart V: Implementation AlternativesChapter 12: Managing Transactions and ConcurrencyChapter 13: Managing Database and SQL PerformancePart VI: Database ManagementChapter 14: Distributed DatabasesChapter 15: Databases for Business IntelligenceChapter 16: Big Data and NoSQLChapter 17: Database Connectivity and Web Technologies