Databases Illuminated

Front Cover
Jones & Bartlett Publishers, Mar 3, 2011 - Computers - 661 pages
1 Review
Databases Illuminated, Second Edition integrates database theory with a practical approach to database design and implementation. The text is specifically designed for the modern database student, who will be expected to know both theory and applied design and implementation as professionals in the field. This Second Edition has been revised and updated to incorporate information about the new releases of Access 2010, Oracle 11g, and Intersystems Cache. It includes material on the most recent topics such as, web access, JDBC, web programming, XML, data mining, and other emerging database technologies and applications. Instructor resources include Microsoft PowerPoint lecture slides, solutions to all the exercises and projects in the text, test bank, and a complete instructor's manual that includes objectives and teaching hints. Student resources include an open access companion website featuring: -downloadable code -projects with step-by-step guidance that ensure students fully understand each step before moving on to the next. -hands-on lab exercises that allow students to apply the concepts learned from the text -additional information not included in the text to allow for further study The integrated, modern approach to databases, combined with strong pedagogical features, accessible writing, and a full package of student and instructor’s resources, makes Databases Illuminated, Second Edition the perfect textbook for courses in this exciting field. New and Key Features of the updated Second Edition: -Covers the new features of the current versions of popular database management systems, including Oracle 11, Access 2010, and InterSystems Cache. -Incorporates the new curriculum recommendations in ACM Computer Science Curriculum 2008 and ACM/AIS IS2010 Curriculum Guidelines for IS2010.2, Data and Information Management, including more attention to security, concurrency, and net-centric computing. The chapter on computer ethics has been updated to take into account new regulations and practices. -Contains more material on recent and relevant topics, such as Web access, JDBC, web programming, XML, data warehousing, data mining, and other emerging database technologies and applications. -Includes the extensive object-relational features of the current release of Oracle, with downloadable code for students to implement; Object-oriented databases are implemented using InterSystems Cache, with downloadable code included on the website.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introductory Database Concepts
1
Database Planning and Database Architecture
25
The EntityRelationship Model
61
The Relational Model
93
41 Advantages of the Relational Model
94
42 Relational Data Structures
95
domain key foreign key general constraints
103
44 Representing Relational Database Schemas
104
Normalization
211
The ObjectOriented Model
249
The Enhanced EntityRelationship Model and the ObjectRelational Model
287
Introduction to Database Security
337
Transaction Management
363
Relational Query Optimization
409
Distributed Databases
449
Databases and the Internet
493

45 Relational Data Manipulation Languages
105
46 Views
115
47 Mapping an ER Model to a Relational Schema
117
48 Chapter Summary
123
Relational Database Management Systems and SQL
129
Social and Ethical Issues
553
Data Warehouses and Data Mining
593
Index
645
Copyright

Other editions - View all

Common terms and phrases

Bibliographic information