This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases—conceptual, logical, and physical database design.
Introduction to Databases; Database Environment; Database Architectures and the Web. The Relational Model and The Relational model; Relational Algebra and Relational Calculus; Data Manipulation; Data Definition; Query-By-Example (QBE). Database Analysis and Database System Lifecycle; Database Analysis and the DreamHome Case Study; Entity–Relationship Modeling; Enhanced Entity–Relationship Modeling; Normalization; Advanced Normalization. Methodology—Conceptual Database Design; Methodology—Logical Database Design for Relational Model; Methodology—Physical Database Design for Relational Databases; Methodology—Monitoring and Tuning the Operational System. Selected Database Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs and Distributed DBMSs—Concepts and Design; Distributed DBMSs—Advanced Concepts; Replication and Mobile Databases. Object Object-Oriented DBMSs—Concepts and Design; Object-Oriented DBMSs—Standards andLanguages; Object-Relational DBMSs. Web and Web Technology and DBMSs; Semistructured Data and XML. Business Intelligence Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Users' Requirements Specification for DreamHome Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to Pyrrho—A Liteweight RDBMS. Web File Organization and Storage Structures; When Is a DBMS Relational?; Commercial Access and Oracle; Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts.
This book is ideal for readers interested in database management or database design.
"synopsis" may belong to another edition of this title.
Over 200,000 people have been grounded in good database design practice by reading Database Systems. The new edition of this bestseller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that has contributed to the success of previous editions.
A clear introduction to design, implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals alike
Features
Check out the web site at www.booksites.net/connbegg, for full implementations of the case studies, lab guides for Access and Oracle, and additional student support.
New! For the fourth edition
XQuery), and OMG.
Both Thomas Connolly and Carolyn Begg have experience of database design in industry, and now apply this in their teaching and research at the University of Paisley in Scotland.
This book comes with a free six-month subscription to Database Place, an online tutorial that helps readers master the key concepts of database systems. Log on at www.aw.com/databaseplace.
"About this title" may belong to another edition of this title.
(No Available Copies)
Search Books: Create a WantCan't find the book you're looking for? We'll keep searching for you. If one of our booksellers adds it to AbeBooks, we'll let you know!
Create a Want