Database Management System (B.Sc Computer Science)

Data models, ER modelling, relational model, SQL, normalisation and transaction basics.

6 MonthsDuration 5Chapters25Topics

Enquire now

Syllabus · पाठ्यक्रम

Download PDF

01Unit 1: Introduction to DBMS 5 topics

File system vs DBMS
Three-level architecture and data abstraction
Physical and logical data independence
Database users and DBA
DBMS architecture

02Unit 2: Data Models and ER Modelling 5 topics

Hierarchical, network and relational models
Entities, attributes and relationships
Cardinality and participation
Weak entities, generalisation and specialisation
ER to relational mapping

03Unit 3: Relational Model and Relational Algebra 5 topics

Relations, tuples and domains
Super, candidate, primary and foreign keys
Integrity constraints
Selection, projection, join, set operations
Cartesian product and division

04Unit 4: SQL 5 topics

DDL, DML, DCL and TCL commands
Constraints in SQL
Aggregate functions, GROUP BY and HAVING
Joins and subqueries
Views

05Unit 5: Normalisation and Transactions 5 topics

Functional dependencies
1NF, 2NF, 3NF and BCNF
Transactions and ACID properties
Concurrency control: locking
Recovery basics

About

You will be able to

Explain the advantages of a DBMS, the three-level architecture and data independence
Draw ER diagrams and convert them into relational tables
Apply keys, integrity constraints and relational algebra operations
Write SQL queries using constraints, aggregate functions, GROUP BY, joins, subqueries and views
Normalise relations up to BCNF using functional dependencies
Explain ACID properties, concurrency control and recovery basics

Who it is for

B.Sc Computer Science students of Semester 2 (UP State Universities NEP 2020 common minimum syllabus)
Students preparing for BCA / MCA entrance and IT job interviews

What you need

B.Sc Computer Science Semester 1
Basic computer operation

Questions

Which syllabus does this course follow?

It follows the UP State Universities NEP 2020 common minimum syllabus for B.Sc Computer Science, Semester 2. Where your own university's syllabus differs, the centre follows your university's syllabus and question pattern.

Which database software is used?

MySQL or Oracle (as per your university); SQL practised in the Database Management System Lab of the same semester.

Is there a test after the course?

Yes. Unit-wise multiple-choice tests and a final exam paper are included for semester exam practice.