CA 221-223 : Database Management System with Practicals

CA 221 : Database Management System

1. 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

2. Database Systems & Data Models
2.1 Introduction of File Processing System
2.2 Introduction of DBMS
2.3 Difference between File processing system & 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

3. 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

4. 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
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

CA-223 : Practical based on Database Management System.

1. Demonstration of creating database.
2. Create table insert 10 records in it.
3. Demonstrate to INSERT, UPDATE, and DELETE, Records in Table.
4. Demonstrate to Alter Table (Add Column, Delete Column, Rename, Modify Column).
5. Demonstrate to SELECT with clauses (Simple and Parameterize).
6. Demonstrate: i. WHERE Clause ii. GROUP BY clause iii. HAVING Clause.
7. Demonstrate integrity constraints: PRIMARY KEY, FOREIGN KEY, CHECK, NOT NULL, and DEFAULT.
8. Demonstrate use of operator.
9. Demonstrate joins (Inner joins, Equi, Non Equi, Self-join & Outer Joins).
10. Demonstrate the use of Sub-Queries.
11. Write down SQL by using i. Aggregate functions, ii. Date functions, iii. String functions