Hello dear reader!
I hope you are studying well. So let me guess why are you here? Ohk! You are looking for DBMS notes. You are at the right place I have special, handwritten, crisp and concise DBMS notes.
You can download it from here 👇:
I noticed a problem that happens with almost all students is not getting proper topic-wise notes. You can find many claiming PDF notes on Google but almost every PDF consist general topic which does not match our AKTU MCA syllabus. I also tried to find topic-wise notes but all I got was general topic PDFs or some paid notes. But the point is why a student will pay for notes? A student who paid for college fees and why should pay for notes. I know books are available in the library but what if any students aren’t interested in a particular subject then there is a total waste of time spent on any book. Some students only have an interest in a particular subject and they study another subject only to get general knowledge and I believe nothing is wrong with this.
Below is the list of all the probable topics covered in my DBMS handwritten notes. Please make sure to go through all the DBMS topics below. These are my handwritten notes so they may have some short names and abbreviations that I used for myself knowingly or unknowingly, so again I am telling you to recheck all the points at your convenience.
List of DBMS topics-
- Database
- Database System
- DBMS
- Database Management System
- Data
- Information
- Knowledge
- File
- Characteristics of Database
- Types of DataBase
- Single User DB
- Multiuser User DB
- Centralised Database
- Distributed Database
- File Oriented Approach
- Redundancy
- Inconsistency
- Data isolation
- Integrity
- Atomicity
- Concurrent
- Security Problem
- Components
- User
- Software
- Hardware
- Application of DBMS
- Advantages of DBMS
- Functions of DBMS
- Disadvantages of DBMS
- Database Basics
- Data Item
- Entity
- Attributes
- Logical Data
- Physical data
- Schema
- Subschema
- DBMS Architecture
- Three Level Architecture
- Internal Level
- Conceptual Level
- External Level
- Database Users
- Naive users
- Online users
- Application users
- Database Administrators
- Database Language
- Data Definition language
- Data Manipulation Language
- Data Control Language
- Elements of DBMS
- DML Pre-Compiler
- DDL Compiler
- File Manager
- Database Manager
- Query Processor
- Data Dictionary
- Data Model
- Object-Based Logical Model
- Record-Based Logical Model
- Physical Model
- ER Model
- Functional Model
- Semantic Model
- Hierarchical Model
- Network Model
- Relational Model
- Entity Set
- Simple Attribute
- Composite attribute
- Single Valued Attribute
- Multi-valued Attribute
- Null valued attribute
- Derived Attribute
- Domain
- Field or Column
- Record or Row
- Relationship Set
- Mapping Cardinalities
- ER Diagram
- Student ER Model
- Flight Database ER Diagram
- History of DBMS
- Charles Bachman
- Codd
- Peter Chen
- Most used DBMS Software
- Relational database management system
- RDBMS
- Primary Key
- Super Key
- Candidate Key
- Alternate Key
- Composite Key
- How to create a database
- How to create a table
- How to alter the table
- Insert query
- Update query
- Delete query
- Select query
- Where Clause
- Order by clause
- Important questions or DBMS
- ACID Properties
- Bank Management System
- Broadband Management System
- char
- nchar
- varchar
- varchar(max)
- Nvarchar
- nvarchar(max)
- Syntax
- Degree of Relationship
- Types of Relationship
- Cordiality of Relationship
- One to One (1-1)
- One to Many (1-M)
- Many to Many (M-N)
- Minimisation tables in ER Model
- Normalisation
- Types of Duplicacy
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Boyse Codd Normal Form
- BCNF
- Lossless composition
- Lossy Composition
- 4NF
- 5NF
- Closure Method
- Functional Dependency
- Reflexity
- Augmentation
- Transition
- Union
- Decomposition
- Psedotransitivity
- Composition
- Join
- Cross join
- Cross product
- Natural Join
- Conditional Join
- Equi Join
- Self join
- Outer join
- Left outer join
- Right outer join
- Full outer join
- Relational Algebra
- Procedural Query Language
- Formal Query Language
- Projection
- Cartesian Product
- Set Difference
- Division
- Tuple Relational Calculus
- TRC
- Atomic functions
- Unsafe Expression
- Structured Query Language
- SQL
- SEQUEL
- Simple English Query Langauge
- Domain Specific Language
- Declarative Language
- DDL command
- DCL command
- TCL command
- DML command
- Keys
- Constraints
- Aggregate Function
- PL SQL
- Alter command
- UPDATE command
- DELETE command
- DROP command
- TRUNCATE command
- Unique constraints
- NOT NULL
- FOREIGN KEY
- DEFAULT KEY
- Queries
- Subqueries
- Correlated Subquery
- Synchronised Query
- Nested Subquery
I covered the above topics in my handwritten notes in a very concise manner. You will not get confused while reading these notes because I covered every topic in multiple headings. You will get every heading highlighted with different colours for a better view and better understanding. I used multiple resources to make my own handwritten DBMS notes.
I created two notes which are created by utilizing multiple sources like YouTube playlists and Google. I am also sharing a YouTube Playlist link to cover all important topics for college and university exams or for interview questions. Here is the YouTube Playlist, click here to watch DBMS videos👇:
https://youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y&feature=shared
https://youtube.com/playlist?list=PLxCzCOWd7aiHqU4HKL7-SITyuSIcD93id&feature=shared
How to prepare for exams?
I would suggest studying in deep when you have enough time, but when you don’t have enough time then just find a well-maintained YouTube playlist of your subject or topics and start watching, you can increase video speed while watching it will save you time and this is also a good trick when you want take a quick recap.
You can make your own handwritten DBMS notes which will make you feel confident in every situation while reading your notes when exams or interviews because you can add or skip all and every topic which you want to. What I do is I study all the topics which are mentioned in my AKTU MCA DBMS Syllabus, then after completing the whole syllabus I go for the YouTube Playlist of DBMS and watch all the videos while opening up my handwritten notes. I watch videos and write down the points which I didn’t write earlier that is how I make my notes. This strategy is good for me but it might be a waste of time for someone, so I suggest please find your own energy and use a strategy which suits your study routine well.
Lastly, I am adding one more thing, please make sure to cross-check all the topics in the notes. It may have error by mistake and also there may be some spelling errors. So make sure to read all and every topic with focus. All the best for your study and further lifelong journey.