Database Fundamentals - Interactive Learning

🎯 Introduction to Database Systems

What is a Database?

A database is an organized collection of data stored and accessed electronically. Think of it as a digital filing cabinet that's much smarter and more efficient!

📁 File Processing System

Each department has its own files
Data redundancy and isolation
Designed for single users
Limited data storage

🗄️ Database System

Centralized data storage
Multiple users can access simultaneously
Reduced data redundancy
Massive data storage capacity

🎮 Interactive DBMS Examples

Click on the DBMS examples below to learn more:

🔍 Basic Database Concepts

Entity-Relationship Fundamentals

🏷️ Entity

A person, place, thing, or event

Example: Student, Course, Book

🔗 Relationship

Association between entities

Example: Student "enrolls in" Course

📊 Attribute

Properties of an entity

Example: Student ID, Name, Age

🎯 Data Types Interactive Guide

Click on each data type to see examples:

📊 Data Hierarchy

Understanding Data Organization

Data in a database follows a systematic hierarchy from the smallest unit to the largest collection.

🔄 Interactive Data Hierarchy

Click on each level to understand the hierarchy:

Bit
Smallest unit

Byte
8 bits

Character
1 byte

Field
Characters

Record
Related fields

Table
Related records

Database
Related tables

📋 Entity-Relationship Diagrams

ER Diagram Components

Entity

Rectangle represents entities

Relation

Diamond represents relationships

Attribute

Oval represents attributes

🔗 Cardinality Examples

Click on each relationship type to see examples:

🛠️ Database Objects

📋 Table

Collection of related records organized in rows and columns

📝 Form

User interface for entering and viewing data one record at a time

🔍 Query

Request for specific data from the database with criteria

📊 Report

Formatted presentation of data for printing or viewing

🎓 Knowledge Check Quiz

1. What is a database?

A) A collection of programs

B) An organized collection of data stored electronically

C) A type of computer hardware

D) A web browser

2. In data hierarchy, what comes after 'Field'?

A) Character

B) Byte

C) Record

D) Database

3. Which cardinality represents "one teacher can teach many students"?

A) 1:1 (One-to-One)

B) 1:M (One-to-Many)

C) M:1 (Many-to-One)

D) M:N (Many-to-Many)

🗄️ Database Fundamentals