Database Management System (B.Sc Computer Science)

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

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

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

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

Download PDF

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

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 टॉपिक

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 टॉपिक

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 टॉपिक

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 टॉपिक

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

परिचय

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

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

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

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

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

B.Sc Computer Science Semester 1
Basic computer operation

सवाल

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.