Class 12 DBMS notes for NEB Computer Science should connect definitions to a small database you can design, query and explain. Check the current CDC curriculum and your school specification grid for exact coverage.
Database and DBMS
A database is an organized collection of related data. A DBMS helps authorized users define, store, retrieve, update and protect that data while reducing problems common in disconnected files.
Relational database basics
Table, record and field
A table represents a subject, a row represents one occurrence and a column stores one property. Select suitable data types and avoid combining several facts in one field.
Keys
A primary key uniquely identifies a row. A foreign key refers to a key in another table and supports relationships. Candidate and composite keys should be studied where required.
Relationships
Model one-to-one, one-to-many and many-to-many relationships. Resolve a many-to-many relationship with an appropriate connecting table.
Normalization
Normalization organizes data to reduce avoidable repetition and update problems. Start with the unnormalized information, identify dependencies and move through the normal forms included in your course. Do not split tables without a clear reason.
Queries and operations
Practise creating tables, inserting records, filtering, sorting, joining and summarizing data using the database language or software specified by your school. Always test queries with known sample results.
School database project
- Choose a small problem such as library loans or project tracking.
- Write users, requirements and exclusions.
- Draw an ER diagram.
- Convert it to related tables and keys.
- Create anonymous test records.
- Write and verify useful queries.
- Document limitations, backup and privacy.
Security and ethics
Use access controls, backups and minimum necessary data. Do not collect real student details for a demonstration project, share passwords or expose database files publicly.
Common mistakes
- Using duplicate or changeable identifiers as primary keys.
- Leaving relationships unenforced.
- Confusing a database with spreadsheet formatting.
- Showing query screenshots without explaining results.
- Using real personal information as test data.
Frequently asked questions
What should I practise for exams?
Definitions, comparisons, key identification, relationship design, normalization steps and queries appropriate to the official course.
Is a diagram enough for a project?
No. Build, test and document the database as well.
Related: Class 12 Computer Science study hub.
