DATABASE MANAGEMENT SYSTEM UOP BBA(CA) First Sem

₹150.00

Tax excluded

Quantity

AUTHORS: Prof.(Dr.) Prasanna Ganpatrao Chavan , Prof. Kiran Rajendra Taksale , Prof. Mayuri Padhye 

ISBN : 978-93-6180-270-6

Syllabus

 

Database Management System

 

Unit

Title and Contents

No. of Lecture

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

15

2

SQL (Structured Query Language)

2.1 Introduction

2.2 Normalization

2.2.1 First Normal Form0

2.2.2 Second Normal Form

2.2.3 Third Normal Form

2.2.4 Boyce - Codd Normal Form

2.2 Basic Structure

2.3 DDL Commands

2.4 DML Commands

2.5 Simple Queries

2.6 Constraint (Not NULL, Check, Unique, Default)

2.7 Aggregate function (Min, Max, Avg, Count, Sum)

2.8 Clause (Group By, Order By, Having)

2.9 Nested Queries

2.10 Case Study on SQL

15

 

UOP/2024/BBA(CA)/1/02
50 Items
New product

16 other products in the same category: