banner
links
curriculume vitae (Resume)
Publications
graduation project
current research
E-journals
puplications
learn programming
lecture notes
database and information retrieval
software engineering
graphics
image processing
intelligent systems
cisco training & networks
awards received
everday English
albume
   ~ Back to Taif University on NOV 2012!      ~ Publications, Patents, Databases, Software Engineering, Graphics, Image Processing, Cisco Training, Lecture Notes are updated!      ~ E-Journals, Software Engineering, Cisco Training, Everyday English, and Album Sections have been updated!      ~ This website will be updated gradually since I am busy with my master project      ~ Welcome to u2learn.net... All my students are invited!      

Database Systems

Suggested Book:

-Fundamentals of Database Systems (6th Edition), 2011
-Fundamentals of Database Systems (5th Edition), 2005
-Database Systems: Models, Languages, Design, AND Application Programming (6th Edition), 2011

Author: Ramez Elmasri and Shamkant B. Navathe
ISBN-10: 0136086209
ISBN-13: 9780136086208
Publisher: Addison-Wesley
Copyright: ©2011  |  Addison-Wesley
Table of Contents

Part 1: Introduction to Databases

Chapter 1 Databases and Database Users
Chapter 2 Database System Concepts and Architecture

Part 2: Relational Data Model and SQL

Chapter 3 The Relational Data Model and Relational Database Constraints
Chapter 4 Basic SQL
Chapter 5 More SQL: Complex Queries, Triggers, Views, and Schema Modification
Chapter 6 The Relational Algebra and Relational Calculus

Part 3: Conceptual Modeling and Database Design

Chapter 7 Data Modeling Using the Entity-Relationship (ER) Model
Chapter 8 The Enhanced Entity-Relationship (EER) Model
Chapter 9 Relational Database Design by ERand EER-to-Relational Mapping
Chapter 10 Practical Database Design Methodology and Use of UML Diagrams

Part 4: Object, Object-Relational, and XML Models

Chapter 11 Object and Object-Relational Databases
Chapter 12 XML: Extensible Markup Language

Part 5: Database Programming Techniques

Chapter 13 Introduction to SQL Programming Techniques
Chapter 14 Web Database Programming Using PHP

Part 6: Database Normalization Theory

Chapter 15 Basics of Functional Dependencies and Normalization for Relational Databases
Chapter 16 Relational Database Design Algorithms and Further Dependencies

Part 7: File Structures, Indexing, and Hashing

Chapter 17 Disk Storage, Basic File Structures, and Hashing
Chapter 18 Indexing Structures for Files

Part 8: Query Processing, Optimization, and Database Tuning

Chapter 19 Algorithms for Query Processing and Optimization
Chapter 20 Physical Database Design and Tuning

Part 9: Transaction Processing, Concurrency Control, and Recovery

Chapter 21 Introduction to Transaction Processing Concepts and Theory
Chapter 22 Concurrency Control Techniques
Chapter 23 Database Recovery Techniques

Part 10: Additional Database Topics: Security and Distribution

Chapter 24 Database Security
Chapter 25 Distributed Databases

Part 11: Advanced Database Models, Systems, and Applications

Chapter 26 Enhanced Data Models for Advanced Applications
Chapter 27 Introduction to Information Retrieval and Web Search
Chapter 28 Data Mining Concepts
Chapter 29 Overview of Data Warehousing and OLAP

Summary:

Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems. Intended for computer science majors, this text emphasizes math models, design issues, relational algebra, and relational calculus.

A lab manual and problems give students opportunities to practice the fundamentals of design and implementation. Real-world examples serve as engaging, practical illustrations of database concepts. The Sixth Edition maintains its coverage of the most popular database topics, including SQL, security, and data mining, and features increased emphasis on XML and semi-structured data.

Book page @ Pearson: Take a closer look on this book at the publisher's companion page .

 

Important Links:
1) Dowload Oracle Database 11g Release 2
Standard Edition, Standard Edition One, and Enterprise Edition http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
2) IBM Rational Rose- Unified Modeling Language™ (UML®) http://www-01.ibm.com/software/rational/uml/

 


:: Home :: Lecture notes :: Calendar :: E-Learning :: Contact us :: Guest book :: Taif University :: CIT ::

All rights reserved for © u2learn.net 2008-2012

For best resolution use: 1024 x 768
You are using :