Scribd
Upload
30 views1 page

Dbms CO PO

The document outlines the Database Management System Laboratory course for the academic year 2023-24, detailing course codes, faculty, assessment tools, and course outcomes. It provides a mapping of course outcomes to program outcomes and the percentage of sessions allotted to each. Additionally, it includes attainment metrics for various assessments and overall performance statistics.

Uploaded by

KC KC
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
30 views1 page

Dbms CO PO

The document outlines the Database Management System Laboratory course for the academic year 2023-24, detailing course codes, faculty, assessment tools, and course outcomes. It provides a mapping of course outcomes to program outcomes and the percentage of sessions allotted to each. Additionally, it includes attainment metrics for various assessments and overall performance statistics.

Uploaded by

KC KC
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Course: Database Management System Laboratory

Course Codes: DJ19ECSBL2


Academic Year: 2023-24
Year: TE Sem: V
Faculty: Karamchandani/Kavedia/Patil/Raichada

Assessment Tools: Lab Experiment 1 CO1


Lab Experiment 2 and 3 CO2
Lab Experiment 4 and 9 CO3
Lab Experiment 5 and 6 CO4
Lab Experiment 7 and 8 CO5
Course Outcomes: CO1 Analyze a case study and create ER diagram of the scenario and able to create Database schema fromthis using given software and SQL
Write basic SQL queries to apply constraints, insert rows, do basic operations like alter and delete and to use basic aggregate functions and
CO2 retrieve information from databases.
CO3 Perform normalization on tables by analyzing functional dependancies
CO4 Write SQL queries to make joins and views on table
CO5 Perform nested queries and triggers.

PO1 PO2 PO3 PO4 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3 Class Sessions Lab Sessions Tut Sessions Total Session Attainment
CO1 1 1 1 0 0 1 1 1 0 0 1 0 7 7 85.18
CO2 1 1 1 0 0 1 1 1 0 0 1 0 7 7 86.45
CO3 1 1 1 0 0 1 1 1 0 0 1 0 7 7 86.20
CO4 1 1 1 0 0 1 1 1 0 0 1 0 10 10 80.87
CO5 1 1 1 0 0 1 1 1 1 0 1 0 9 9 84.68
Total 0 40 0 40

Total Sessions allotted to PO/PSO 40 40 40 0 0 40 40 40 9 0 40 0


% of sessions allotted to PO/PSO 100.00 100.00 100.00 0.00 0.00 100.00 100.00 100.00 22.50 0.00 100.00 0.00

Mapping Strength of Course to 3 3 3 0 0 3 3 3 1 0 3 0


PO/PSO PO1 PO2 PO3 PO4 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3

% of Sessions Level
>= 40 3
>25 and <40 2
>5 and <25 1
<5 0

Summation 423.38 423.38028 423.3803 0 0 423.38028 423.3803 423.38028 84.676056 0 423.38028 0

Average 84.676 84.676056 84.67606 #DIV/0! #DIV/0! 84.676056 84.67606 84.676056 84.676056 #DIV/0! 84.676056 #DIV/0!

Mapped PO/PSO Attainment 84.68 84.68 84.68 #DIV/0! #DIV/0! 84.68 84.68 84.68 84.676056 #DIV/0! 84.68 #DIV/0!

You might also like