This text is in accordance with the new syllabus NEP-2025 recommended by the Kavayitri Bahainabai Chaudhari North Maharashtra University, Jalgaon, which has been serving the need of S.Y.B.C.A. Computer Science students from various colleges. This text is also useful for the student of Engineering, B.Sc. (Information Technology and Computer Science), M.Sc, M.C.A., B.B.M., M.B.M. other different Computer courses.

UNIT 1...................................................................................................7
Introduction to basics of DBMS
1.1 What is Data & Information?
1.2 What is Data Management?
1.3 What is Optimization?
1.4 Pre-processing of Data
1.5 Importance of Data Quality
1.6 List of DBMS software’s

UNIT 2.................................................................................................23
Database Systems and Data Models
2.1 Introduction of File Processing System
2.2 Introduction of DBMS
2.3 Difference between File Processing System and DBMS
2.4 Applications of DBMS
2.5 View of Data
2.6 Concept of DBA
2.7 Relational Model
2.8 Network Model
2.9 Hierarchical Model
2.10 Entity Relationship Model: Symbols, Entity, Attributes, Relationships, Examples.

UNIT 3.................................................................................................55
Integrity Constraints & Normalization
3.1 Primary Key
3.2 Foreign Key
3.3 Candidate Key
3.4 Super Key
3.5 Null

3.6 Default
3.7 Not Null
3.8 Check constraint
3.9 Entity Integrity
3.10 Referential Integrity
3.11 Normalization
3.12 Normal Form: 1 NF, 2 NF, 3 NF

UNIT 4.................................................................................................73
Structured Query Language (SQL)
4.1 Introduction to SQL
4.2 Data types
4.3 Operators
4.4 Working with tables.
4.5 Introduction to: DDL, DML, DCL, TCL.
4.6 Clause: Where, Group by, having, order by. (12L, 15 M)
4.7 Functions: Numeric Function, Aggregate functions, Character Function, Date Function, Conversion Function.
4.8 Sub Queries, view, Sequence, Set Operators.
4.9 Joins: Inner joins, Equi, Non Equi, Self-join & Outer Joins.