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
1. Provides a comprehensive introduction to database systems.
2.A solid grounding in the technology | Field is taking shape in near future.
3.To stay current with database system trends ,remains on insight and not just on formalisms.
4.Crystal Clear explanations of models and systems and an up-to-date database technologies to database systems.
Practical illustrations of database coverage of topics of interest and emerging technologies.
5. integrates database theory and practical . Covers Access 2010, Oracle 11g.
6.web access, JDBC, web programming, XML, data mining,Web access, JDBC, XML, data warehousing, and other emerging database technologies, applications and emerging database technologies .
7.downloadable code -projects.
8.ACM Computer Science Curriculum 2008 and
9. ACM/AIS IS2010 Curriculum Guidelines for IS2010.2,
Data and Information Management,
10.Security, concurrency, and net-centric computing.
Introductory Database Concepts
Database Planning and Database Architecture
The EntityRelationship Model
The Relational Model
41 Advantages of the Relational Model
42 Relational Data Structures
domain key foreign key general constraints
44 Representing Relational Database Schemas
The ObjectOriented Model
The Enhanced EntityRelationship Model and the ObjectRelational Model
Introduction to Database Security
Relational Query Optimization
Databases and the Internet