Coursepack scheme



Download 299.95 Kb.
Page1/7
Date18.01.2024
Size299.95 Kb.
#63232
  1   2   3   4   5   6   7
DBMS Course pack 28-10-23
Java Unit 2 Notes




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




COURSE OVERVIEW



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



PREREQUISITE COURSE REQUIRED

No

Fundamental computer knowledge required

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


Download 299.95 Kb.

Share with your friends:
  1   2   3   4   5   6   7




The database is protected by copyright ©ininet.org 2024
send message

    Main page