Database Management Systems (Diploma)

Data models, ER diagrams, relational model, normalization, SQL and transactions.

6 महीनेअवधि 5Chapters24टॉपिक

अभी पूछताछ करें

सिलेबस · पाठ्यक्रम

Download PDF

01Unit 1: Introduction to DBMS 4 टॉपिक

File system vs DBMS
Three-schema architecture and data independence
Data models: hierarchical, network, relational
DBMS users and DBA

02Unit 2: Entity-Relationship Model 5 टॉपिक

Entities, attributes and relationships
Types of attributes
Cardinality and participation
Keys: super, candidate, primary, foreign
Weak entity and ER to table conversion

03Unit 3: Relational Model and Normalization 5 टॉपिक

Relation, tuple, attribute, domain, degree, cardinality
Integrity constraints
Relational algebra: select, project, join, union, difference
Functional dependency
1NF, 2NF, 3NF and BCNF

04Unit 4: SQL 5 टॉपिक

DDL, DML, DCL and TCL commands
SELECT with WHERE, ORDER BY
Aggregate functions, GROUP BY and HAVING
Joins and subqueries
Views and indexes

05Unit 5: Transactions, Concurrency and Security 5 टॉपिक

Transaction and ACID properties
Transaction states and schedules
Concurrency problems and locking (2PL)
Deadlock
Recovery, backup and GRANT / REVOKE

परिचय

आप यह कर पाएँगे

Explain the advantages of DBMS over file systems and the three-schema architecture
Draw ER diagrams and convert them to relational tables
Identify keys and integrity constraints and apply relational algebra
Normalize relations up to 3NF / BCNF using functional dependencies
Write SQL queries with joins, grouping, subqueries and views
Explain transactions, ACID properties, concurrency control, recovery and security

यह किसके लिए है

Diploma Computer Science & Engineering students of Semester 3 (BTEUP)
Polytechnic students of other boards studying the same subject who want unit-wise coaching

आपको क्या चाहिए

Basic computer knowledge and programming fundamentals of earlier semesters

सवाल

Which syllabus does the Database Management Systems course follow?

It follows the BTEUP (Board of Technical Education, Uttar Pradesh) diploma syllabus for Database Management Systems (Computer Science & Engineering, Semester 3). If your own board's or institute's syllabus differs, the centre follows your own syllabus.

Will this help in the semester examination?

Yes. Teaching is unit-wise as per the BTEUP scheme, with previous-year question practice, MCQ tests and doubt sessions before the semester exam.

Which database software is used?

SQL is practised on MySQL (or Oracle / PostgreSQL where the institute uses it).