Database Management Systems
This section provides an in-depth exploration of Database Management Systems (DBMS), covering fundamental concepts, data modeling, SQL, relational database models, security, and ethical issues in data management. The chapters and resources are designed to enhance your understanding of database concepts and their practical applications in various scenarios.
Key Topics Include:
- Data Modeling: Understanding how to represent data structures in a database.
- SQL and Relational Data Retrieval: Techniques for querying and managing data in relational databases.
- Security and Administration: Ensuring data security and managing database administration tasks.
Chapters
- Chapter 1: Data: The New Corporate Resource
- Chapter 2: Data Modeling
- Chapter 3: The Database Management System Concept
- Chapter 4: The Relational Database Model: Introduction
- Chapter 5: Relational Data Retrieval: SQL
- Chapter 6: Relational Algebra and Relational Calculus
- Chapter 7: The Relational Database Model: Additional Concepts
- Chapter 8: Logical Database Design
- Chapter 10: Security and Administration Transparencies
- Chapter 11: Professional, Legal, and Ethical Issues in Data Management
- Chapter 22: Transaction Management
- Chapter 24: Distributed DBMSs – Concepts and Design
- Revision Questions and Answers