Book Title:-Database Principles: Fundamentals of Design,
Implementation and Management
Author :-Carlos Coronel | Stephen Morris | Peter Rob
ISBN :-9788131525937
Price :-INR 799
Pages :-762
Edition :-10
Binding :-Paperback
Imprint :-Course Technology
© Year :-2013
Overview :
Practical and easy to understand DATABASE PRINCIPLES: FUNDAMENTALS OF DESIGN,
IMPLEMENTATION, AND MANAGEMENT, 10E, gives students a solid foundation in database design
and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this market-leading
text provides in-depth coverage of database design, demonstrating that the key to successful database
implementation is in proper design of databases to fit within a larger strategic view of the data environment.
Renowned for its clear, straightforward writing style, this text provides students with an outstanding balance
of theory and practice. The tenth edition has been thoroughly updated to include hot topics such as green
computing/sustainability for modern data centers, the role of redundant relationships, and examples of web-
database connectivity and code security. In addition, new review questions, problem sets, and cases have
been added throughout the book so that students have multiple opportunities to test their understanding and
develop real and useful design skills.
Feature :
Full-color, detailed illustrations, tables, and diagrams enhance comprehension and facilitate
understanding of more complex concepts.
Multiple databases in various formats are used to provide readers with experience in implementation
using MS Access, MS SQL Server, and Oracle databases.
Business vignettes offer insight on the most current issues and challenges facing database
implementation today.
Clear, straightforward writing style provides an outstanding balance of theory and practice.
Instructor''s Manual includes all end-of-chapter solutions, suggested discussion material, and other
resources, giving teachers a complete teaching tool.
Figures, diagrams, and illustrations have been updated in order to provide students with improved
visual aids.
New review questions, problem sets, and cases have been added throughout the book so that students
have multiple opportunities to test their understanding.
To ensure that students are provided with the most up-to-date material available, content has been
expanded to include topics such as Open Source databases, embedded/mobile databases, data
replication, data analytics, explanatory models, predictive models, the role of redundant relationships,
and examples of web-database connectivity and code security.
In order to address new trends in the market, coverage now includes green computing/sustainability
for modern data centers.
Material on Ethics, as it pertains to the database administration function, is now included so that
students have a solid understanding of ethical dilemmas in the field.
Table Of Content :
PART I: DATABASE SYSTEMS.
1. The Database Approach.
2. Database Development Process.
PART II: DESIGN ALTERNATIVES.
3. Data Models.
4. Relational Model Characteristics.
PART III: DATABASE PROGRAMMING.
5. Beginning Structured Query Language.
6. Procedural Language SQL and Advanced SQL.
PART IV: DATABASE DESIGN.
7. Data Modeling with Entity Relationship Diagrams.
8. Data Modeling Advanced Concepts.
9. Normalizing Database Designs.
PART V: IMPLEMENTATION ALTERNATIVES.
10. Distributed Databases.
11. Interacting with Databases through the Web.
PART VI: DATABASE MANAGEMENT.
12. Database Administration and Security.
13. Managing Transactions and Concurrency.
14. Managing Database and SQL Performance.
15. Databases for Decision Support.
ONLINE APPENDICES.
Appendix A: Designing Databases with Visio Professional: 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 11G.
Appendix O: Data Warehouse Implementation Factors.
About Author :
Carlos Coronel
Carlos Coronel is currently the Lab Director for the College of Business Computer Labs at Middle
Tennessee State University. He has over 27 years of experience in various fields as a Database
Administrator, Network Administrator, Web Manager, and Technology Specialist, and has taught courses in
Web development, database design and development, and data communications at the undergraduate and
graduate levels.
Stephen Morris
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.
Peter Rob
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.