NDSS Academy

Database Management System (BCA)

Data models, ER diagrams, relational model, SQL, normalisation, transactions and concurrency control.

6 MonthsDuration 5Chapters24Topics
Enquire now

Syllabus · पाठ्यक्रम

Download PDF
01Unit 1: Introduction to DBMS 5 topics
  1. File system vs DBMS
  2. Three-schema architecture
  3. Data independence
  4. Data models
  5. DBA and database users
02Unit 2: Entity-Relationship Model 5 topics
  1. Entities and attributes
  2. Relationships and cardinality
  3. Weak entities
  4. Generalisation and specialisation
  5. ER to relational mapping
03Unit 3: Relational Model and SQL 5 topics
  1. Keys - super, candidate, primary, foreign
  2. Relational algebra
  3. DDL and DML commands
  4. Joins and sub-queries
  5. Aggregate functions, GROUP BY and HAVING
04Unit 4: Normalisation 4 topics
  1. Anomalies
  2. Functional dependencies
  3. 1NF, 2NF and 3NF
  4. BCNF
05Unit 5: Transactions and Concurrency 5 topics
  1. Transaction and ACID properties
  2. Schedules and serializability
  3. Lock-based protocols and two-phase locking
  4. Deadlocks in databases
  5. Recovery - log-based

About

You will be able to

  • Explain the advantages of a DBMS, the three-schema architecture and data independence
  • Draw ER diagrams and convert them into relational tables
  • Write SQL queries - DDL, DML, joins, sub-queries and aggregate functions
  • Use relational algebra operations
  • Normalise relations up to BCNF using functional dependencies
  • Explain transactions, ACID properties, concurrency control and recovery

Who it is for

  • BCA students of Semester 5 (UP state universities, Lucknow University pattern)
  • Students preparing for developer and database jobs

What you need

  • Basic programming and data structures

Questions

Which syllabus does this Database Management System course follow?

It follows the common UP state university BCA syllabus (University of Lucknow pattern) for BCA Semester 5. If your own university's syllabus differs, the centre follows your university's syllabus and unit order.

Which database is used for practice?

MySQL (or Oracle where the college uses it) in the DBMS and Java Lab.

Are SQL queries asked in the theory exam?

Yes - writing queries on a given table is a standard question, along with ER diagrams and normalisation.

Download the syllabus (PDF)

Tell us who you are — your copy is made with your name, and our counsellor can help you choose the right course and centre.

Want to join right away? Enquire now — our centre will call you.