Scribd
Upload
123 views7 pages

DBMS Revision Notes

The document provides quick revision notes on Database Management Systems (DBMS) covering key topics such as database models, keys, normalization, and SQL basics. It outlines the hierarchical, relational, and object-oriented models, as well as primary, foreign, and candidate keys. Additionally, it includes sample questions for practice to reinforce understanding of the material.

Uploaded by

bakrabu786
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
123 views7 pages

DBMS Revision Notes

The document provides quick revision notes on Database Management Systems (DBMS) covering key topics such as database models, keys, normalization, and SQL basics. It outlines the hierarchical, relational, and object-oriented models, as well as primary, foreign, and candidate keys. Additionally, it includes sample questions for practice to reinforce understanding of the material.

Uploaded by

bakrabu786
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

Database Management Systems – B.

Tech Quick
Revision Notes

Table of Contents
1. Introduction to DBMS
2. Database Models
3. Keys in DBMS
4. Normalization
5. SQL Basics
6. Sample Questions for Practice
1. Introduction to DBMS
A Database Management System (DBMS) is software for storing, retrieving, and managing data
efficiently.

It allows multiple users to interact with databases securely and concurrently.


2. Database Models
Hierarchical Model: Data is organized in a tree-like structure.

Relational Model: Data is stored in tables with rows and columns.

Object-Oriented Model: Data is stored as objects, similar to programming concepts.


3. Keys in DBMS
Primary Key: Uniquely identifies each record in a table.

Foreign Key: Links two tables together.

Candidate Key: Potential primary keys.


4. Normalization
Process of organizing data to minimize redundancy.

Normal Forms: 1NF, 2NF, 3NF, and BCNF.


5. SQL Basics
DDL: CREATE, ALTER, DROP.

DML: SELECT, INSERT, UPDATE, DELETE.

DCL: GRANT, REVOKE.


6. Sample Questions for Practice
Q1: Differentiate between Primary Key and Foreign Key.

Q2: Explain 3NF with an example.

Q3: Write an SQL query to fetch all employees earning above 50,000.

You might also like