Scribd
Upload
4 views1 page

Database Concepts Study Guide

Chapter 2 covers fundamental database concepts, including the transition from early file systems to centralized databases managed by DBMS, emphasizing qualities like reliability and security. It explains relational databases, their structure with tables, primary and foreign keys, and operations like Select and Join, along with the importance of data modeling and integrity constraints. Additionally, it addresses object-oriented concepts and their integration with databases, highlighting the differences between RDBMS, OODBMS, and ORDBMS.

Uploaded by

Stefan Gittens
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Database Concepts Study Guide

Chapter 2 covers fundamental database concepts, including the transition from early file systems to centralized databases managed by DBMS, emphasizing qualities like reliability and security. It explains relational databases, their structure with tables, primary and foreign keys, and operations like Select and Join, along with the importance of data modeling and integrity constraints. Additionally, it addresses object-oriented concepts and their integration with databases, highlighting the differences between RDBMS, OODBMS, and ORDBMS.

Uploaded by

Stefan Gittens
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Chapter 2: Fundamental Database Concepts — Study Guide

2.1 Introduction to Databases


• Early file systems stored separate data files (like spreadsheets). Problem: duplication and
inconsistency.
• Database approach stores data once in a central database, managed by a Database
Management System (DBMS).
• Qualities of a good DB: Reliability (keeps working during failures), Integrity (data is correct),
Security (access control), User Views (different access for different users).

2.2 Relational Databases


• Relational model stores data in tables (relations). Rows = tuples, Columns = attributes.
• Primary Key (PK) uniquely identifies rows. Foreign Key (FK) links one table to another.
• Operations: Select (rows), Project (columns), Join (combine tables).
• SQL is the standard language for querying databases.
• Other models: Hierarchical (tree, rigid), Network (many-to-many, complex), Deductive (facts +
rules).

2.3 Database Development


• Data models act as blueprints before building databases.
• Conceptual Model: abstract big picture (e.g., Books, Authors).
• Logical Model: adapts conceptual to DBMS type (e.g., relational).
• Physical Model: actual implementation.
• E-R Modeling: Entities (things), Attributes (properties), Relationships (connections).
• Relationship types: One-to-One, One-to-Many, Many-to-Many.
• Integrity constraints keep data accurate (e.g., unique IDs, valid links).

2.4 Object Orientation


• Problem: Impedance mismatch between programming (objects) and relational (tables).
• Objects = state (attributes) + behavior (methods). Classes = blueprints.
• OO Concepts: Identity (unique objects), Encapsulation (hide details), Inheritance (shared
properties), Polymorphism (same op, different behavior), Association (links).
• OODBMS: stores objects directly, natural but slower.
• ORDBMS: hybrid combining relational + object features.

Key Study Pointers


• Define relation, tuple, attribute, PK, FK.
• Understand relational operations (Select, Project, Join).
• Know how E-R modeling works.
• Memorize OO features: identity, encapsulation, inheritance, polymorphism, association.
• Compare RDBMS, OODBMS, ORDBMS.

You might also like