Scribd
Upload
68 views1 page

DBMS Unit-Wise Notes

The document provides an overview of Database Management Systems (DBMS), detailing its functions for managing databases. Key topics include data models, types of keys, SQL commands, normalization processes, ER diagrams, transaction properties, concurrency control, and performance techniques like indexing and hashing. An example SQL command for creating a Student table is also included.

Uploaded by

sakshiphate0307
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
68 views1 page

DBMS Unit-Wise Notes

The document provides an overview of Database Management Systems (DBMS), detailing its functions for managing databases. Key topics include data models, types of keys, SQL commands, normalization processes, ER diagrams, transaction properties, concurrency control, and performance techniques like indexing and hashing. An example SQL command for creating a Student table is also included.

Uploaded by

sakshiphate0307
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

DBMS Unit-wise Notes

DBMS Notes

Introduction:
Database Management System (DBMS) is a software to manage databases efficiently.
It allows storage, retrieval, and manipulation of data.

Topics:
- Data Models: Hierarchical, Network, Relational.
- Keys: Primary Key, Candidate Key, Foreign Key, Composite Key.
- SQL:
* DDL (CREATE, ALTER, DROP)
* DML (INSERT, UPDATE, DELETE)
* DCL (GRANT, REVOKE)
- Normalization:
* 1NF: Remove repeating groups.
* 2NF: Remove partial dependency.
* 3NF: Remove transitive dependency.
- ER Diagrams: Entities, attributes, relationships, cardinalities.
- Transactions: ACID properties (Atomicity, Consistency, Isolation, Durability).
- Concurrency Control: Locking, Deadlock handling.
- Indexing & Hashing for performance.

Example SQL:
CREATE TABLE Student(RollNo INT PRIMARY KEY, Name VARCHAR(50), Marks INT);

You might also like