VIKRAMA SIMHAPURI UNIVERSITY, NELLORE
DEPARTMENT OF COMPUTER SCIENCE
Syllabus for Master of Computer Applications (2 Year Course) for V.S. University Constituent Colleges(S) and Affiliated
Colleges under the jurisdiction of Vikrama Simhapuri University, Nellore with effect from the Academic Year 2022-’23.
______________________________________________________________________________________________
Programme MCA Semester Second
Course Code 22RACMCA2MC2 Course Name Database Management Systems
L T P
Course Hours/Week
Core 3 1 0
Category
Credits 4
This course is designed to:
1.Train in the fundamental concepts of database management systems
Course
2.Demonstrate the use of SQL commands
Objectives
3. Usage of formal relational Query languages
4. To create a database for real world scenario.
Introduction to Relational Model
Introduction: Database systems applications, Purpose of Database Systems, view of
UNIT -1 Data, Database Languages, Relational Databases, Database Design, Data Storage and
Querying, Transaction Management, Database Architecture, Database users and
Administrators, Structure of Relational Databases, Database Schema, Keys, Schema
Diagrams, Relational Query Languages, Relational Operations.
Introduction to SQL
Introduction to SQL: Overview of the SQL Query Language, Data Definition, Basic
UNIT -2 Structure of SQL Queries, Set Operations, Null Values, Aggregate Functions, Nested
Sub-queries, Modification of the Database. Intermediate SQL: Joint Expressions,
Views, Transactions, Integrity Constraints, SQL Data types and schemas,
Authorization.
Accessing SQL from a Programming Language, Functions and Procedures, Triggers,
UNIT -3
Recursive Queries, OLAP, Formal relational query languages.
Programme MCA Semester Second
Database Design and the E-R Model, Relational Database Design
Database Design and the E-R Model: Overview of the Design Process, The Entity-
Relationship Model, Constraints, Removing Redundant Attributes in Entity Sets,
Entity-Relationship Diagrams, Reduction to Relational Schemas, Entity-Relationship
UNIT -4 Design Issues.
Relational Database Design: Features of Good Relational Designs, Atomic Domains
and First Normal Form, Decomposition Using Functional Dependencies, Functional-
Dependency Theory, Algorithms for Decomposition, Decomposition Using
Multivalued Dependencies.
Text Books 1.A.Silberschatz, H.F.Korth, S.Sudarshan, “Database System Concepts”,6/e, TMH
2019.
1. Database Management System, 6/e RamezElmasri, Shamkant B. Navathe,
PEA.
2. Database Principles Fundamentals of Design Implementation and
References
Management, Carlos Coronel, Steven Morris, Peter Robb, Cengage Learning.
3. Database Management Systems, 3/e, Raghurama Krishnan, Johannes
Gehrke,TMH.
Course Outcomes : After completion of the course student able to
Knowledge
Course Outcome Description
Level
Understand the fundamental concepts of database management systems.
K1, K2
CO1
Implement structured query languages to work with databases
CO2 K3
1.
Implement PL/SQL constructs to work with Database Objects .
CO3 K3
CO4 .Design Databases using Normal Forms and ER Model. K6
K1- Remembering, K2- Understanding, K3- Applying, K4- Analyzing, K5- Evaluating, K6- Creating
COURSE AND PROGRAMME OUTCOMES MAPPING
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PSO1 PSO2 PSO3
CO1 3 1 1 - - - - -- - - - - -
CO2 1 1 3 - - - - - - - - - -
CO3 1 1 3 - - - - - - - - - -
CO4 3 3 3 - - - - - - - - - -
1-Low, 2-Medium, 3-High
