UNITED INTERNATIONAL UNIVERSITY

Department of Computer Science and Engineering (CSE)

Course Syllabus

1 Course Title Database Management Systems Laboratory

2 Course Code CSE 3522

3 Trimester and Year Fall 2023

4 Pre-requisites NIL

5 Credit Hours 1.00

6 Section --
7 Class Hours Day : StartTime – EndTime

8 Classroom Computer Lab ---

9 Instructor’s Name ----------------------

10 Email ----------------------
11 Office Room # ----
12 Counselling Hours
Day Time Slot
Day Time Slot
Day Time Slot
Day Time Slot
Day Time Slot

13 Text Book 1. Database System Concepts (6th Edition)

by Abraham Silberschatz, Henry F. Korth and S. Sudarshan
2. Database Systems: The Complete Book
by Garcia-Molina, Ullman and Widom
14 Reference http://www.db-book.com/

15 Course Contents Laboratory work based on CSI 221.

(approved by UGC)
16 Course
Outcomes (COs) COs Description
CO1 Design relational database models to manage correlated data based
on software requirements.
CO2 Extrapolate the theories and techniques in developing interactable
database applications
CO3 Engage in effective communication through presentation of the
project work, database modeling and project reports.
CO4 Contribute to the DBMS project development using enterprise
DBMS products such as SQL server and lead the team.

17 Teaching Methods Lecture (L), Case Study (CS), Q/A, Assignment (A), Quizzes, Project

18 CO with
Assessment CO Assessment Method (%)
Methods - Attendance 5%
- Assignment 10%
- Class Performance (Quiz) 30%
CO2, CO4 ER Diagram Design, Report 15%
and Viva
CO1 Weekly Project Updates 15%
CO3 Final Project Presentation 25%

19 Mapping of COs and Program outcomes

CO Statement Bloom’s Program Knowledge Complex Engineerin

Domain Outcome Profile Problem g Activities
CO1 Design relational C 1: Engineering Depth of Range of
database models to Engineering fundamental Knowledge Resources
manage correlated data Knowledge s (K3) (P1) (A1)
based on software
requirements. Specialist Depth of
Knowledge Analysis
CO2 Extrapolate the theories C 2: (K4) (P3)
and techniques in Problem
developing interactable Analysis Engineering Interdepen
database applications Design dence (P7)
(K5)
CO3 Engage in effective A 10:
communication through Communicat Engineering
presentation of the ion Practice
project work, database (K6)
modeling and project
reports.
CO4 Contribute to the DBMS C 5: Modern
project development Tool Usage
using enterprise DBMS
 products such as SQL
server and lead the
team.

20 Lab Outline

Class Topics/Assignments Cos Lab Outcomes/Activities

Introduction to relational databases. Students will be familiarized with
Lab1 Environment to work with relationalCO2 relational database system as well as
databases. environment to work with it.
Students will learn how to design
Implementation of relational database
Lab2 CO2 and implement a database from any
based on case study.
case study.
Student will implement the
Manipulation of implemented
Lab3 CO1 manipulation operations in a
relational databases.
relational database.
Student will learn the difference of
Introduction to the development of
web server and database server.
Lab4 database project using database server CO4
They will initiate the project using
and web server.
web server and database server.
Student will learn Basic database
Basic database queries
Lab5 CO1 queries with mathematical and
implementation using sql
logical operations.
Student will learn Intermediate
Intermediate database queries
Lab6 CO1 database queries like joining,
implementation using sql
aggregation, and grouping.
Student will learn Advanced
Advanced database queries
Lab7 CO1 database queries like subqueries and
implementation using sql
set operations
Partial project presentation and group CO3, Student will understand the team
Lab8
work evaluation CO4 work to build a project.
Students will formally develop the
Develop the initiated project with
Lab9 CO4 final databases for project using
database theories and techniques
theories and techniques.
Project presentation and group work CO3, Team work and management will
Lab10
evaluation CO4 be evaluated for project.
Final Presentation of the developed Student will learn to impose the
CO3,
Lab11 projects using database and web security, integrity and management
CO4
server in team hierarchies in database.
Team work as well as project
Lab12 Lab Final Exam CO2
management will be evaluated.
Appendix 1: Assessment Methods

Assessment Types Marks

Attendance 5%
Assignment 10%
Class Performance 20%
Presentation, Report and Viva 20%
Project Development 30%
Lab Final 15%

Appendix 2: Grading Policy

Letter Grade Marks % Grade Point Letter Grade Marks% Grade Point
A (Plain) 90-100 4.00 C+ (Plus) 70-73 2.33
A- (Minus) 86-89 3.67 C (Plain) 66-69 2.00
B+ (Plus) 82-85 3.33 C- (Minus) 62-65 1.67
B (Plain) 78-81 3.00 D+ (Plus) 58-61 1.33
B- (Minus) 74-77 2.67 D (Plain) 55-57 1.00
F (Fail) <55 0.00

Appendix-3: Program outcomes

Program Outcomes
1 Engineering knowledge: Apply knowledge of mathematics, natural science, engineering
fundamentals and Computer Science and Engineering to the solution of complex
engineering problems.
2 Problem analysis: Identify, formulate, research literature and analyse complex
engineering problems reaching substantiated conclusions using first principles of
mathematics, natural sciences and engineering sciences.
3 Design/development of solutions: Design solutions for complex engineering problems
and design systems, components or processes that meet specified needs with appropriate
consideration for public health and safety, cultural, societal, and environmental
considerations.
4 Investigation: Conduct investigations of complex problems using research-based
knowledge and research methods including design of experiments, analysis and
interpretation of data, and synthesis of information to provide valid conclusions
5 Modern tool usage: Create, select and apply appropriate techniques, resources, and
modern engineering and IT tools, including prediction and modelling, to complex
engineering problems, with an understanding of the limitations.
6 The engineer and society: Apply reasoning informed by contextual knowledge to assess
societal, health, safety, legal and cultural issues and the consequent responsibilities
relevant to professional engineering practice and solutions to complex engineering
problems.
7 Environment and sustainability: Understand and evaluate the sustainability and impact
of professional engineering work in the solution of complex engineering problems in
societal and environmental contexts.
8 Ethics: Apply ethical principles and commit to professional ethics and responsibilities and
norms of engineering practice.
9 Individual work and teamwork: Function effectively as an individual, and as a member
or leader in diverse teams and in multi-disciplinary settings.
10 Communication: Communicate effectively on complex engineering activities with the
engineering community and with society at large, such as being able to comprehend and
write effective reports and design documentation, make effective presentations, and give
and receive clear instructions.
11 Project management and finance: Demonstrate knowledge and understanding of
engineering management principles and economic decision-making and apply these to
one’s 13 own work, as a member and leader in a team, to manage projects and in
multidisciplinary environments.
12 Life-long learning: Recognize the need for, and have the preparation and ability to
engage in independent and life-long learning in the broadest context of technological
change.