DATABASE MANAGEMENT SYSTEM UOP BBA(CA) First Sem

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