Database Systems: Design, Implementation, and Management - Hardcover

Peter, Rob; Coronel, Carlos; Rob, Peter

Hardcover

ISBN 10: 1418836508 ISBN 13: 9781418836504

Publisher: Cengage Learning Ptr, 2006

Synopsis

Database Systems: Design, Implementation, and Management, Seventh Edition is one of the most comprehensive database textbooks available. The proven success of database design treatment is sustained and further improved in this revision. The proven Parts organizations streamline the chapter coverage, so it is an ideal choice for your classroom. Each Part opens with a new business vignette, which provides real world examples to engage your students. The new edition includes updates in every chapter as well as added exercises and cases. There are new chapters such as Advanced Modeling Concepts, Database Performance Tuning and Query Optimization, and Database Connectivity and Web Development. In the seventh edition you will find examples of database usage, which highlights eBAY for compelling context. In our new Query Optimization chapter, we cover database performance tuning concepts, index selectivity and SQL coding practices. There is added EERD coverage such as clusters and subtype discriminator attributes. With the authors? strong writing style and outstanding balance of theory and practice, this is just a small sampling of the improvements we have made to the new edition of Database Systems: Design, Implementation, and Management by Peter Rob and Carlos Coronel.

About this title

About the Author

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. 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 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.

Review

PART I: DATABASE SYSTEMS Chapter 1: The Database Approach Chapter 2: Data Models Chapter 3: Relational Model Characteristics Chapter 4: Relational Algebra PART II: DATABASE ALTERNATIVES Chapter 5: Data Modeling with Entity Relationship Diagrams Chapter 6: Data Modeling Advanced Concepts Chapter 7: Normalizing Database Designs PART III: DATABASE PROGRAMMING Chapter 8: Beginning Structured Query Language Chapter 9: Procedural Language SQL and Advanced SQL PART IV: DATABASE DESIGN Chapter 10: Database Development Process Chapter 11: Conceptual, Logical and Physical Database Design PART V: IMPLEMENTATION ALTERNATIVES Chapter 12: Managing Transactions and Concurrency Chapter 13: Managing Database and SQL Performance PART VI: DATABASE MANAGEMENT Chapter 14: Distributed Databases Chapter 15: Databases for Decision Support Chapter 16: Interacting with Databases Through the Web ONLINE APPENDICES (Available on CourseMate) Appendix A: Designing Databases with Visio Professional: A Tutorial Appendix B: New Case study TBC : Conceptual, Logical and Physical Database Design Appendix C: The University Lab: 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

Edition details

• Publisher: Cengage Learning Ptr
• Publication date: 2006
• ISBN 10: 1418836508
• ISBN 13: 9781418836504
• Binding: Hardcover
• Language: English
• Number of pages: 716