Introductory, theory-practice balanced text teaching the fundamentals of databases to advanced undergraduates or graduate students in information systems or computer science.

Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access. In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects. And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues.

The aim of this work is to provide a correct and up-to-date understanding of the practical aspects of crucial, yet little- understood core database issues. The author identifies fundamental concepts, principles, and techniques and assesses the treatment of those issues in SQL (both the standard and commercial implementations) and gives advice on how to deal with them. Topics covered include complex data types, missing information, data hierarchies, and quota queries. Annotation copyrighted by Book News, Inc., Portland, OR

A database management system (DBMS) is a collection of programs that enable users to create and maintain a database; it also consists of a collection of interrelated data and a set of programs to access that data. Hence, a DBMS is a general-purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications. The primary goal of a DBMS is to provide an environment that is both convenient and efficient to use in retrieving and storing database information. It is an interface between the user of application programs, on the one hand, and the database, on the other. The objective of Database Management System: An Evolutionary Approach, is to enable the learner to grasp a basic understanding of a DBMS, its need, and its terminologies discern the difference between the traditional file-based systems and a DBMS code while learning to grasp theory in a practical way study provided examples and case studies for better comprehension This book is intended to give under- and postgraduate students a fundamental background in DBMSs. The book follows an evolutionary learning approach that emphasizes the basic concepts and builds a strong foundation to learn more advanced topics including normalizations, normal forms, PL/SQL, transactions, concurrency control, etc. This book also gives detailed knowledge with a focus on entity-relationship (ER) diagrams and their reductions into tables, with sufficient SQL codes for a more practical understanding.

You can get there Where do you want to go? You might already be working in the information technology field and may be looking to expand your skills. You might be setting out on a new career path. Or, you might want to learn more about exciting opportunities in database management. Wherever you want to go, Introduction to Databases will help you get there. Easy-to-read, practical, and up-to-date, this text not only helps you learn fundamental database design and management concepts, it also helps you master the core competencies and skills you need to succeed in the classroom and in the real world. The book's brief, modular format and variety of built-in learning resources enable you to learn at your own pace and focus your studies. With this book, you will be able to: * Appreciate the key role of data in daily business operations and strategic decisions. * Understand databases, database management systems, and SQL, the software on which they are based, from the ground up. * Know how to gather and organize critical business information, design a database based on this information, and retrieve and modify that information in a useful manner. * Use accepted data modeling procedures to design a relational database. * Master the concept of data normalization and the use of standard normalization rules. * Explore critical real-world issues including application integration and securing data against disclosure and loss. Wiley Pathways helps you achieve your goals Not every student is on the same path, but every student wants to succeed. The Information Technology series in the new Wiley Pathways imprint helps you achieve your goals. The books in this series--Introduction to Databases, Introduction to Programming Using Visual Basic, Introduction to Operating Systems, Networking Basics, Windows Network Administration, Network Security Fundamentals, and PC Hardware Essentials--offer a coordinated information technology curriculum. Learn more at www.wiley.com/go/pathways

An updated, introductory management book which discusses object oriented data modeling and client server platforms. KEY FEATURES: It explores management and design within the context of the database development life cycle.

The contents of this second edition have been appropriately enhanced to serve the growing needs of the students pursuing undergraduate engineering courses in Computer Science, Information Technology, as well as postgraduate programmes in Computer Applications (MCA), MSc (IT) and MSc (Computer Science). The book covers the fundamental and theoretical concepts in an elaborate manner using SQL of leading RDBMS—Oracle, MS SQL Server and Sybase. This book is recommended in Guwahati University, Assam. Realizing the importance of RDBMS in all types of architectures and applications, both traditional and modern topics are included for the benefit of IT-savvy readers. A strong understanding of the relational database design is provided in chapters on Entity-Relationship, Relational, Hierarchical and Network Data Models, Normalization, Relational Algebra and Relational Calculus. The architecture of the legacy relational database R system, the hierarchical database IMS of IBM and the network data model DBTG are also given due importance to bring completeness and to show thematic interrelationships among them. Several chapters have been devoted to the latest database features and technologies such as Data Partitioning, Data Mirroring, Replication, High Availability, Security and Auditing. The architecture of Oracle, SQL of Oracle known as PL/SQL, SQL of both Sybase and MS SQL Server known as T-SQL have been covered. KEY FEATURES : Gives wide coverage to topics of network, hierarchical and relational data models of both traditional and generic modern databases. Discusses the concepts and methods of Data Partitioning, Data Mirroring and Replication required to build the centralized architecture of very large databases. Provides several examples, listings, exercises and solutions to selected exercises to stimulate and accelerate the learning process of the readers. Covers the concept of database mirroring and log shipping to demonstrate how to build disaster recovery solution through the use of database technology. Contents: Preface 1. Introduction 2. The Entity-Relationship Model 3. Data Models 4. Storage Structure 5. Relational Data Structure 6. Architecture of System R and Oracle 7. Normalization 8. Structured Query Language 9. T-SQL—Triggers and Dynamic Execution 10. Procedure Language—SQL 11. Cursor Management and Advanced PL/SQL 12. Relational Algebra and Relational Calculus 13. Concurrency Control and Automatic Recovery 14. Distributed Database and Replication 15. High Availability and RAID Technology 16. Security Features Built in RDBMS 17. Queries Optimization 18. Architecture of a Hierarchical DBMS 19. The Architecture of Network based DBTG System 20. Comparison between Different Data Models 21. Performance Improvement and Partitioning 22. Database Mirroring and Log Shipping for Disaster Recovery Bibliography Answers to Selected Exercises Index