# Database Management System (313302) StudySpace

Welcome to the StudySpace index for Database Management System. AI agents can retrieve raw Markdown formats by calling these URLs with the "Accept: text/markdown" header or appropriate bot User-Agents.

## Course Index

### Unit 1: Introduction To Database System
- **Unit Summary Markdown**: https://www.learningway.in/studyspace/313302?unit=1&summary=1
- **Topics**:
  - **[Topic 1.1]** Database Concepts: Data, Database, DBMS, File System vs DBMS, Applications of DBMS: https://www.learningway.in/studyspace/313302?topic=1.1
  - **[Topic 1.2]** Data Abstraction, Data Independence, Database Schema, Codd's Rules, Overall Structure of DBMS: https://www.learningway.in/studyspace/313302?topic=1.2
  - **[Topic 1.3]** Architecture: Two Tier and Three Tier Architecture of Database: https://www.learningway.in/studyspace/313302?topic=1.3
  - **[Topic 1.4]** Data Models: Hierarchical, Network, Relational Data Models: https://www.learningway.in/studyspace/313302?topic=1.4

### Unit 2: Relational Data Model
- **Unit Summary Markdown**: https://www.learningway.in/studyspace/313302?unit=2&summary=1
- **Topics**:
  - **[Topic 2.1]** Relational Structure: Tables (Relations), Rows (Tuples), Domains, Attributes, Entities: https://www.learningway.in/studyspace/313302?topic=2.1
  - **[Topic 2.2]** Keys: Super Keys, Candidate Key, Primary Key, Foreign Key: https://www.learningway.in/studyspace/313302?topic=2.2
  - **[Topic 2.3]** Data Constraints: Domain Constraints, Referential Integrity Constraints: https://www.learningway.in/studyspace/313302?topic=2.3
  - **[Topic 2.4]** Entity Relationship Model: Strong Entity Set, Weak Entity Set, Types of Attributes, ER Diagrams: https://www.learningway.in/studyspace/313302?topic=2.4
  - **[Topic 2.5]** Normalization: Functional Dependencies, Normal Forms: 1NF, 2NF, 3NF: https://www.learningway.in/studyspace/313302?topic=2.5

### Unit 3: Interactive SQL and Performance Tuning
- **Unit Summary Markdown**: https://www.learningway.in/studyspace/313302?unit=3&summary=1
- **Topics**:
  - **[Topic 3.1]** SQL: Data Types, DDL, DML, DCL, TCL: https://www.learningway.in/studyspace/313302?topic=3.1
  - **[Topic 3.2]** Clauses and Joins: Where, Group By, Order By, Having, Types of Joins, Nested Queries: https://www.learningway.in/studyspace/313302?topic=3.2
  - **[Topic 3.3]** Operators: Relational, Arithmetic, Logical, Set Operators: https://www.learningway.in/studyspace/313302?topic=3.3
  - **[Topic 3.4]** Functions: Numeric, Date and Time, String Functions, Aggregate Functions: https://www.learningway.in/studyspace/313302?topic=3.4
  - **[Topic 3.5]** Views, Sequences, Indexes: Create, Update, Drop: https://www.learningway.in/studyspace/313302?topic=3.5

### Unit 4: PL/SQL Programming
- **Unit Summary Markdown**: https://www.learningway.in/studyspace/313302?unit=4&summary=1
- **Topics**:
  - **[Topic 4.1]** Introduction to PL/SQL: Advantages, Block Structure, Data Types, Variables, Constants: https://www.learningway.in/studyspace/313302?topic=4.1
  - **[Topic 4.2]** Control Structures: Conditional Control, Iterative Control, Sequential Control: https://www.learningway.in/studyspace/313302?topic=4.2
  - **[Topic 4.3]** Exception Handling: Predefined Exceptions, User-Defined Exceptions: https://www.learningway.in/studyspace/313302?topic=4.3
  - **[Topic 4.4]** Cursors: Implicit and Explicit Cursors, Cursor For Loops, Parameterized Cursors: https://www.learningway.in/studyspace/313302?topic=4.4
  - **[Topic 4.5]** Procedures: Advantages, Create, Execute, Delete Stored Procedure: https://www.learningway.in/studyspace/313302?topic=4.5
  - **[Topic 4.6]** Functions: Advantages, Create, Execute, Delete a Function: https://www.learningway.in/studyspace/313302?topic=4.6
  - **[Topic 4.7]** Database Triggers: Types of Triggers, Create Trigger, Delete Trigger: https://www.learningway.in/studyspace/313302?topic=4.7

### Unit 5: Database Administration
- **Unit Summary Markdown**: https://www.learningway.in/studyspace/313302?unit=5&summary=1
- **Topics**:
  - **[Topic 5.1]** Database Administration: Types of Users, Create and Delete Users, Assign Privileges: https://www.learningway.in/studyspace/313302?topic=5.1
  - **[Topic 5.2]** Transaction: Concept, Properties and States of Transaction: https://www.learningway.in/studyspace/313302?topic=5.2
  - **[Topic 5.3]** Database Backup: Types of Failures, Physical and Logical Backups: https://www.learningway.in/studyspace/313302?topic=5.3
  - **[Topic 5.4]** Data Recovery: Recovery Concepts, Roll Forward, Rollback: https://www.learningway.in/studyspace/313302?topic=5.4
  - **[Topic 5.5]** Advanced Database Concepts: Data Warehouse, Data Lakes, Data Mining, Big Data, MongoDB, DynamoDB: https://www.learningway.in/studyspace/313302?topic=5.5