1. Database
A Database is an organized collection of data stored electronically.
Example:
A college database stores:
- Student Details
- Faculty Details
- Marks
- Attendance
Example table:
Student_ID Name Department 101 Suganya CSE 102 Divya IT
2 DBMS (Database Management System)
A DBMS is software that allows users to create, store, update, delete, and retrieve data from a database.
Features: Create databases Insert records Update records Delete records Search data Manage users Examples: FoxPro dBase Microsoft Access
3. RDBMS (Relational Database Management System)
An RDBMS is an advanced type of DBMS where data is stored in tables, and relationships are established using Primary Keys and Foreign Keys.
Example:
Department Table
Dept_ID Department 1 CSE 2 IT
Employee Table
Emp_ID Name Dept_ID 101 Suganya 1 102 Divya 2
SQL (Structured Query Language) SQL is a standard language used to create, manage, and manipulate data in relational databases.
Uses of SQL: Create databases and tables Insert data Retrieve data Update data Delete data MYSQL MySQL is an open-source RDBMS developed by Oracle Corporation that stores data in tables and uses SQL to perform database operations.
Features of MySQL: Open source Fast and reliable Supports multiple users Stores data in tables
SQL Data Types
INT FLOAT DECIMAL CHAR VARCHAR TEXT DATE TIME DATETIME TIMESTAMP BOOLEAN
SQL Commands
DISPLAY EMPLOYEE TABLE
DISPLAY ATTENDANCE TABLE
DISPLAY LEAVE_REQUESTS TABLE
DISPLAY PAYROLL TABLE
Display Employee Names and Attendance Status
