Database Management System
  • Database Management System

Database Management System

₹210.00
1796
15 Items

Specific References

According to New CBCS (CHOICE BASE CREDIT SYSTEM) Syllabus w.e.f. 2019-20

A Text Book of

Database Management System (CS 102)

Author: Dr. Reena Bharathi, Vandana Bhat

ISBN: 978-93-5016-443-3

Price: 210/-

Quantity
In Stock

Contents

1. Introduction to DBMS   

1. Introduction

2. File System Versus Databases

3. Levels of Abstraction  

4. Structure of a DBMS    

5. Users of a DBMS  

6. Advantages of DBMS

2. Conceptual Design(ER - Model)    

1. Overview of DB Design  

2. Introduction to Data Models 

3. Conceptual Design using E-R Model

4. Constraints 

5. Extended E–R Features  

6. Pictorial representation of E–R model  

7. Structure of Relational Databases

8. DBMS Vs RDBMS    

9. Case Studies on E-R Model  

3. SQL    

1. Introduction to Query Languages  

2. Basic Structure of SQL 

3. Data Definition Language (DDL)   

4. DML Commands 12

5. Forms of a Basic SQL Query  

6. Set Operations   

7. Aggregate Function

8. Null Values 

9. Nested Queries   

10.SQL Mechanism for Joining Relations

11.Views

4. Relational Database Design  

1. Introduction to Relational Database Design  

2. Functional Dependency  

3. Concept of Decomposition

4. Concept of Normalization    

5. Key Concepts with Examples