Includes bibliographical references and index.

CHAPTER 1 INTRODUCTION TO DATABASE-SYSTEM 1 -- Introduction 2 -- Purpose of Database Systems 2 -- Database Languages 11 -- Database Design 17 -- Data Storage and Querying 23 -- Database Architecture 26 -- Database Users and Administrators 29 -- CHAPTER 2 RELATIONAL DATABASES 41 -- Introduction 42 -- Overview of Relational Database 42 -- Structure of Relational Databases 46 -- Database Schema 50 -- Relational Query Languages 55 -- Relational Operations 56 -- CHAPTER 3 INTRODUCTION TO SQL 63 -- Introduction 64 -- Overview of the SQL Query Language 64 -- SQL Data Definition 65 -- Basic Structure of SQL Queries 70 -- Additional Basic Operations 82 -- Set Operations 89 -- Aggregate Functions 95 -- Nested Subqueries 101 -- CHAPTER 4 DATABASE DESIGN AND THE E-R MODEL 121 -- Introduction 122 -- Overview of the Design Process 122 -- The Entity-Relationship Model 126 -- Constraints 135 -- Removing Redundant Attributes in Entity Sets 139 -- Entity-Relationship Diagrams 142 -- Reduction To Relational Schemas 152 -- CHAPTER 5 STORAGE AND FILE STRUCTURE 161 -- Introduction 162 -- Physical Storage Media 162 -- Magnetic Disk and Flash Storage 166 -- Redundant Arrays of Independent Disks (RAID) 178 -- Tertiary Storage 189 -- File Organization 192 -- Organization of Records in Files 199 -- Database Buffer 207 -- CHAPTER 6 DATA WAREHOUSING AND MINING 213 -- Introduction 214 -- Decision-Support Systems 214 -- Data Warehousing 217 -- Data Mining 224 -- Association Rules 238 -- Clustering 241 -- CHAPTER 7 DISTRIBUTED DATABASES 253 -- Introduction 254 -- Database Management System 254 -- Types of Distributed Database Systems 272 -- Architectural Alternatives 277 -- Distributed DBMSs Technical Issues 280 -- CHAPTER 8 DATABASE SECURITY 307 -- Introduction 308 -- Database Security: Concepts 308 -- Threats and Security Issues 311 -- Firewall and Database Recovery 327 -- Database Security Techniques 330.

"In the business industry, companies acquire customers who buy products or services that interest them. As customers grow, so do the transactions that accompany those purchases. In order to maintain an effective business, these companies need to find a way to organize the transactions where they can track product inventory as well as their customers for marketing purposes. The best technique to maintain both aspects of the business is to implement a database.Organizing data is an important activity in the development of computer systems. The performance of the IT system depends heavily on how data is organized. Database systems are playing an increasingly important role in today's knowledge-based society, where computers have permeated all areas of activity and the Internet tends to develop globally. The world of data is constantly changing and evolving every second. This in turn has created a whole new dimension of growth and challenges for businesses around the world. Because information plays a critical role inmost organizations, computer professionals have developed a variety of data management concepts and techniques.These concepts and techniques form the focus of this book, which introduces both the principles of database systems and the problems of database systems.The information contained in this edition is updated and new topics are added. You will find out the purpose and functions of a database management system, as well as the advantages and disadvantages of using a database management system in an organization. Additionally, it covers relational databases; database design processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems;storage and file structure; Data Warehousing and Mining; and distributed database that is spread physically across computers in multiple locations linked by a data communications network. This edition compel to students with a grounding in database and a technical context for understanding recent innovations in the subject area. " -- Back Cover