KANPUR INSTITUTE OF TECHNOLOGY
Database Management System Lab (KCS-551)
Submitted by: __________________
Roll No._________________________
MCA -1st Year (2nd Semester)
Session 2024-25
Submitted to:
Mr. Ajeet Singh
(Assistant Professor)
Department of Computer Application
Vision and Mission of the Department
Vision
Department of Computer Application at Kanpur Institute of Technology is
committed to promote professionals with knowledge and understanding, by
providing with latest Technology in Computer Applications so that they
Contribute not only in the progress of software and its applications but
even beset the entire domain of computer technology.
Mission
M1: To impart high quality education in the science of computing.
M2: To prepare educated and skilled computer professionals.
M3: To create excellence by providing comprehensive knowledge of the
latest tools and technologies in the domain of computer science, so that
students strive to become leaders.
M4: To inculcate ethical values in students so that they understand their
responsibility towards the nation with focus on upliftment of all sections of
society.
M5: To facilitate establishment of research centers and encourage students
to solve complex technological problems.
Program Educational Objectives
PEO1: Make valuable contributions to design, development and
production in the practice of computer science and engineering in related
engineering areas or application areas, and at the interface of computers
and physical systems.
PEO2: Promotes design, research and implementation of products through
strong communication skills, leadership and entrepreneurial skills.
PEO3: Engage in professional development or post-graduate education to
pursue flexible career paths amid future technological changes.
PEO4: Apply basic principles and practices of computing and science to
successfully complete software related projects to meet customer business
objectives and/or productively engage in research.
PEO5: To develop analytical, mathematical and scientific knowledge that
is used to analyze, formulate and solve any engineering problems.
Program specific outcomes (PSO’s):
PSO1: Ability to understand the mathematical methodology to cracks
problems using suitable data structure and mathematical approach.
PSO2: Ability to design and develop software for web based and mobiles
androids under real world environment.
PSO3: Ability to design the algorithm for machine learning, data
compression and IOT based application and also the successful career and
entrepreneurship.
INDEX
S. Name of Experiment Page Date Signature
No No.
1. Concept design with E-R Model 02/04/2024
2. Relational Model 09/04/2024
3. Normalization 16/04/2024
4. Practicing DDL commands 23/04/2024
5. Practicing DML commands 30/04/2024
6. Querying (using ANY, ALL, IN, Exists, NOT 07/05/2024
EXISTS, UNION, INTERSECT, Constraints etc.)
7. Queries using Aggregate functions, GROUP BY, 14/05/2024
HAVING and Creation and dropping of Views.
8. PL/SQL Functions 04/06/2024
9. PL/SQL Procedures 25/06/2024
10. PL/SQL Triggers (Creation of insert trigger, delete 02/07/2024
trigger, update trigger)
