Welcome to IRDT Uttarakhand E-Syllabus Web Portal

17 PGDCA
Duration : 2 Years
Eligibility : Graduate
Intake : 40/60 (As approved by AICTE)
Pattern of the Examination : Semester System
Assessment Type : The assessment will we carry out through credit point system/Learning Based Out comes.
Theory & Practical Ratio : 60: 40
Industrial Training: Included after IInd Semester
Ecology & Environment :
Entrepreneurship Development: A subject on Entrepreneurship Development has been incorporated after IInd Semester.
General Proficiency : A provision of 6 periods per week has been made. It Included of various cocurricular activities like games, hobby clubs, seminars, declamation contests, extension lectures, NCC, NSS, cultural activities and discipline etc.

Syllabus


Paper Code :
172003
Paper Name :
DATABASE MANAGEMENT SYSTEM WITH SQL
Database and database systems have become an essential component of everyday
life in modern society. This course will acquaint the students with the knowledge of
fundamental concepts of DBMS and its application in different areas, storage,
manipulation and retrieval of data using query languages. Oracle/MySQL/SQL Server
can be use as package to explain concepts.
Database Systems; Database and its purpose, Characteristics of the database approach,
Advantages and disadvantages of database systems. Classification of DBMS
Users; Actors on the scene, Database Administrators, Database Designers, End
Users, System Analysts and Application Programmers, Workers behind the scene
(DBMS system designers and implementers, tool developers, operator and
maintenance personnel).
Data models, schemas, instances, data base state. DBMS Architecture; The External
level, The conceptual level, The internal level, Mappings. Data Independence; Logical
data Independence, Physical data Independence. Database Languages and Interfaces;
DBMS Language, DBMS Interfaces. Classification of Database Management Systems
Data Models Classification; File based or primitive models, traditional data models,
semantic data models. Entities and Attributes, Entity types and Entity sets,
Key attribute and domain of attributes, Relationship among entities.
Relational Model Concepts: Domain, Attributes, Tuples and Relations. Relational
constraints and relational database schemes; Domain constraints, Key constraints and
constraints on Null. Relational databases and relational database schemes, Entity
integrity, referential integrity and foreign key.
Concept of Normalization, Need of Normalization, Non-loss decomposition and
functional dependencies, First, Second and Third normal forms, Boyce Codd normal
form (BCN).
SQL's basic objects, data types, aggregate functions, scalar functions, null values,
creating database objects, modifying database objects, removing database objects.
Creating Tables, Creating a table with data from another table, Dropping a Table,
Inserting values into a table, updating columns of a table, Deleting Rows, Database
Security and Privileges, Grant and Revoke Command, Maintaining Database Objects,
Commit and Rollback, various types of select commands, various types of join.
1. Creating, modifying and removing database objects.
2. Working with queries involving joins, correlation, sub-queries, set operators.
3. Creating and using stored procedures and user defined functions.
4. Creating indexes
5. Creating and using views.
6. Using and understanding grant, revoke and deny statements.
1. Data Base Management System By Ivan Byross.
2. C.J. Date, "An Introduction to Data Base Systems", 3rd Ed., Narosa Publishers,
1997.
3. Jeffrey D. Ullman, "Principles of Database Systems", 2nd Ed., Galgotia Pub., 1984.
4. D. Kroenke., "Database Processing", Galgotia Publications, 1987.
5. Henry F. Korth, “Database System Concepts”, McGraw Hill. Inc., 1997.
6. Naveen Prakash, “Introduction to Database Management”, TMH, 1993.
7. Elmisry Nawathy, "Introduction to database System", Pearson Education India.
8. Beginning Microsoft SQL Server 2008 Programming by Robert Vieira, Wrox.
9. Microsoft SQL Server 2008 Bible by Paul Nielsen, Uttam Parui; Wiley India
Publication.


Website Developed By Softmaart