Database Management System

Rs. 90.00
Rs. 100.00
Rs. 90.00
(-10%)
Order within the next hours minutes to receive it. Estimated delivery is between and
Publisher: Prime Publishing House
ISBN: 9789373442006
Year: 2025
Pages: 68

Database Management System (DBMS) is a comprehensive and student-friendly textbook that provides a strong foundation in the concepts and applications of database systems. The book introduces the importance of data management in modern organizations and explains how databases support efficient storage, retrieval, and analysis of information.

It covers essential topics such as data models, entity-relationship diagrams, relational database concepts, and key structures, along with a detailed introduction to SQL. Important areas like normalization, database design, and query processing are explained in a clear and systematic manner. The inclusion of examples, case studies, and practical exercises helps learners develop both conceptual understanding and hands-on skills.

Designed with a focus on clarity and application, this book enables readers to build proficiency in managing and manipulating data effectively. It serves as a valuable resource for students and beginners aspiring to develop expertise in database systems and pursue careers in information technology and data management.

1. Introduction to Databases Management and Data Models
1.1 Introduction
1.2 Application Of DBMS
1.3 Advantages of DBMS
1.4 Users of DBMS
1.4.1 Database Designers
1.4.2 Application Programmer
1.4.3 Sophisticated Users
1.4.5 End Users
1.5 Views of Data
1.6 Data Models
1.6.1 Relational Model
1.6.2 Network Model
1.6.3 Hierarchical Model
1.7 Entity Relationship Diagram (ERD)
1.8 Features of ERD
1.9 Cases Studies on ER Model
1.10 Introduction to Relational Model
1.11 Basic Concepts: Relation, tuple, attribute
1.12 Key: Super Key, Candidate Key, Primary Key, Foreign Key

2. SQL (Structured Query Language)
2.1 Introduction
2.2 Normalization
2.2.1 First Normal Form
2.2.2 Second Normal Form
2.2.3 Third Normal Form
2.2.4 Boyce - Codd Normal Form
2.3 Basic Structure
2.4 DDL Commands
2.5 DML Commands
2.6 Simple Queries
2.7 Constraint (Not NULL, Check, Unique, Default)
2.8 Aggregate function (Min, Max, Avg, Count, Sum)
2.9 Clause (Group By, Order By, Having)
2.10 Nested Queries
2.11 Case Study on SQL

BBA-CA | First Year Semester – I, Major Mandatory This textbook is aligned with the revised syllabus as outlined by the National Education Policy 2020 (NEP 2020) for the Faculty of Commerce & Management Bachelor of Business Administration in Computer Application (BBA-CA), effective from June 2025.

तुम्हाला हे देखील वाचायला आवडेल

ही पुस्तके तुम्ही नुकतीच पाहिलीत – आताच खरेदी करा!