COURSEPACK
SCHEME
The scheme is an overview of the learning pattern of the core subject of the Computer Science domain and gets students into the real-world scenario of the problem domain.
Course Title
|
Database Management System
|
Course Type
|
Comprehensive
|
Course Code
|
E2UC302B
|
Class
|
B. Tech Core and All specialization- III Semesters
|
Instruction delivery
|
Activity
|
Credits
|
Weekly Hours
|
Total Number of Classes per Semester
|
Assessment in Weightage
|
Lecture
|
3
|
3
|
Tutorial
|
0
|
0
|
Theory
|
Tut
|
Practical
|
Self- Learning
|
CIE
|
SEE
|
Practical
|
1
|
2
|
Self-Learning
|
0
|
7
|
Total
|
4
|
12
|
45
|
0
|
30
|
105
|
50%
|
50%
|
Names of Course Coordinators and Instructors
|
Course Lead: - Dr. Ashish Sharma
Course Coordinator: - Mr. Akhilesh Tripathi
|
Theory
Dr. Gulshan Shrivastava
|
Mr. A. Booblan
|
Mr. Amit Kumar
|
Mr. Arunendra Mani Tripathi
|
Mr. Arvindam M
|
Dr. Ashish Sharma
|
Mr. B. Thillaieswaran
|
Mr. C. Ramesh Kumar
|
Ms. Garima Pandey
|
Dr. Harshvardhan Choudhary
|
Ms. Indravati
|
Mr. K Bhaskar
|
Mr. Kalemoor Rehman
|
Mr. Anas Khan
|
Ms. Nidhi Agarwal
|
Mr. Nitin Jain
|
Ms. Pravesh
|
Dr. S. Janarthanan
|
Dr. S. Premkumar
|
Dr. Satheesh Kumar
|
Ms. Shalakha Tyagi
|
Ms. Deepika Kataria
|
Mr. Ashwini K Pradhan
|
Mr. Akhilesh K Singh
|
Mr. Akhilesh K Tripathi
|
Ms. Swati Sharma
|
|
|
Practical
Dr. Gulshan Shrivastava
|
Mr. A. Booblan
|
Mr. Amit Kumar
|
Mr. Arunendra Mani Tripathi
|
Mr. Arvindam M
|
Dr. Ashish Sharma
|
Mr. B. Thillaieswaran
|
Mr. C. Ramesh Kumar
|
Ms. Garima Pandey
|
Dr. Harshvardhan Choudhary
|
Ms. Indravati
|
Mr. K Bhaskar
|
Mr. Kalemoor Rehman
|
Mr. Anas Khan
|
Ms. Nidhi Agarwal
|
Mr. Nitin Jain
|
Ms. Pravesh
|
Dr. S. Janarthanan
|
Dr. S. Premkumar
|
Dr. Satheesh Kumar
|
Ms. Shalakha Tyagi
|
Ms. Deepika Kataria
|
Mr. Ashwini K Pradhan
|
Mr. Akhilesh K Singh
|
Mr. Akhilesh K Tripathi
|
Ms. Swati Sharma
|
|
This course introduces the core principles and techniques required to design and implement database systems. This course focuses on relational database management systems, including database design theory: E-R modeling, data definition, and manipulation languages, database security, and administration. It also covers essential DBMS concepts such as Transaction Processing, Concurrency Control, and Recovery, various types of databases like distributed databases and, Client/Server. Students undertake a semester mini project to design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS. It also provides students with theoretical knowledge and practical skills using MySQL tool in the use of databases and database management systems in information technology applications.
PREREQUISITE COURSE
If, yes please fill in the details
Prerequisite course code
|
Prerequisite course name
|
|
|
COURSE OBJECTIVES
The objective of this course is to deliver concepts of database management systems using a practical approach,
with an emphasis on how to design, populate, organize, maintain, and retrieve information from RDBMS efficiently.
COURSE OUTCOMES (COs)
After the completion of the course, the student will be able to
CO No.
|
Course Outcome
|
E2UC302B.1
|
Design database schema using ER diagrams and convert it into Relational tables.
|
E2UC302B.2
|
Implement the DDL, DML, and DCL queries.
|
E2UC302B.3
|
Apply database Normalization techniques up to BCNF for the removal of anomalies.
|
E2UC302B.4
|
Perform the serializability and recoverability tests on transactions.
|
BLOOM’S LEVEL OF THE COURSE OUTCOMES
Bloom's taxonomy is a set of hierarchical models used for the classification of educational learning objectives into levels of complexity and specificity. The learning domains are cognitive, affective, and psychomotor.
Blended Course
CO No.
|
Remember
KL1
|
Understand
KL2
|
Apply
KL3
|
Analyze
KL4
|
Evaluate
KL5
|
Create
KL6
|
E2UC302B.1
|
|
|
√
|
√
|
|
|
E2UC302B.2
|
|
|
√
|
|
|
|
E2UC302B.3
|
|
|
√
|
|
|
|
E2UC302B.4
|
|
|
√
|
|
|
|
PROGRAM OUTCOMES (POs): PO1 Computing Science knowledge: Apply the knowledge of mathematics, statistics, computing science, and information science fundamentals to the solution of computer application problems.
PO2 Problem analysis: Identify, formulate, review research literature, and analyze computing science problems reaching substantiated conclusions using the first principles of mathematics, natural sciences, and computer sciences.
PO3 Design/development of solutions: Design solutions for complex computing problems and design system components or processes that meet the specified needs with appropriate consideration for public health and safety, and the cultural, societal, and environmental considerations.
PO4 Conduct investigations of complex problems: Use research-based knowledge and research methods including design of experiments, analysis and interpretation of data, and synthesis of the information to provide valid conclusions.
PO5 Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern computing science and IT tools including prediction and modeling to complex computing activities with an understanding of the limitations.
PO6 IT specialist and society: Apply reason informed by the contextual knowledge to assess societal, health, safety, legal and cultural issues and the consequent responsibilities relevant to the professional computing science and information science practice.
PO7 Environment and sustainability: Understand the impact of professional computing science solutions in societal and environmental contexts, and demonstrate the knowledge of, and need for sustainable development.
PO8 Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of the computing science practice.
PO9 Individual and team work: Function effectively as an individual, as a member or leader in diverse teams and multidisciplinary settings.
PO10 Communication: Communicate effectively on complex engineering activities with the IT analyst 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.
PO11 Project management and finance: Demonstrate knowledge and understanding of computing science and management principles and apply these to one’s work, as a member and leader in a team, to manage projects and in multidisciplinary environments.
PO12 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.
Program Specific Outcomes (PSO’s)
PSO1: Have the ability to work with emerging technologies in computing requisite to Industry 4.0.
PSO2: Demonstrate Engineering Practice learned through industry internship and research projects to solve live problems in various domains.
COURSE ARTICULATION MATRIX
The Course articulation matrix indicates the correlation between Course Outcomes and Program Outcomes and their expected strength of mapping in three levels (low, medium, and high).
COs#/
POs
|
PO1
|
PO2
|
PO3
|
PO4
|
PO5
|
PO6
|
PO7
|
PO8
|
PO9
|
PO10
|
PO11
|
|
Share with your friends: |