database system

database systems: a practical approach to design, implementation and management

(5th edition) Description:

This best-selling text introduces the theory behind databases in a concise yet

comprehensive manner, providing database design methodology that can be used by

both technical and non-technical readers. The methodology for relational Database

Management Systems is presented in simple, step-by-step instructions in conjunction

with a realistic worked example using three explicit phases—conceptual, logical, and

physical database design.

Background: Introduction to Databases; Database Environment; Database

Architectures and the Web. The Relational Model and Languages: The Relational

model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL:

Data Definition; Query-By-Example (QBE). Database Analysis and Design: Database

System Lifecycle; Database Analysis and the DreamHome Case Study;

Entity–Relationship Modeling; Enhanced Entity–Relationship Modeling;

Normalization; Advanced Normalization. Methodology: Methodology—Conceptual

Database Design; Methodology—Logical Database Design for Relational Model;

Methodology—Physical Database Design for Relational Databases;

Methodology—Monitoring and Tuning the Operational System. Selected Database

Issues: Security and Administration; Professional, Legal, and Ethical Issues;

Transaction Management; Query Processing. Distributed DBMSs and

Replication: Distributed DBMSs—Concepts and Design; Distributed

DBMSs—Advanced Concepts; Replication and Mobile Databases. Object

DBMSs: Object-Oriented DBMSs—Concepts and Design; Object-Oriented

DBMSs—Standards and Languages; Object-Relational DBMSs. Web and

DBMSs: Web Technology and DBMSs; Semistructured Data and XML. Business

Intelligence Technologies: Data Warehousing Concepts; Data Warehousing Design;

OLAP; Data Mining. Appendices: Users' Requirements Specification for

DreamHome Case Study;