DBMS

Download as pdf or txt
Download as pdf or txt
You are on page 1of 22

RGPV (DIPLOMA OBE CURRICULUM FOR FORMAT- Sheet

WING) BHOPAL DATABASE MANAGEMENT


SYSTEM
3 No. 1/3

Computer Science and


Branch Semester IV
Engineering/Information Technology
DATABASE
Course Code 403 Course Name MANAGEMENT
SYSTEM
Understand the Basic concepts and need of Database
Course Outcome 1 Management systems including Query Language and Hrs Marks
Data Model.

Learning Outcome Identify the need of Database Management systems 8 10


1 with the help of Architecture of DBMS.

DBMS Concepts, Database approach v/s Traditional file accessing approach,


Contents Advantages of database systems, Database system applications, Three level
architecture: Mapping between views, DBMS users , Functions of DBA and
designer, Schemas and instances, Data independence.

Method of Question Paper -External- End Sem Theory Exam


Assessment
Learning Outcome Elaborate Overall Structure of Database and Query
Language . 6 10
2
Data Base Language: Data Definition Language, Data Manipulation Language
Contents
and Data Control Language, Overall Database Structure.
Method of Question Paper -Internal Progressive Test
Assessment
Learning Outcome Classify Data Model and give Example of Entity
Relation Data Model. 8 10
3
Introduction and Classification of Data Model, Comparison between the three
types of models, ER data model: Entitles and attributes, Entity types,
Contents Relationship among entities, representation of association & relationship,
Defining the E-R diagram, Concept of Generalization, Aggregation and
Specialization, keys.
Method of Question Paper -External- End Sem Theory Exam
Assessment
Learning Outcome Explain Relational Model and Codd’s Relational 8 10
4 database Rules .
Relational Model: Attributes and Domains, tuples, relations and their schemas,
relation representation, relationship, integrity rules (Primary, Unique,
Contents Candidate, Check, Foreign key), Transforming ER diagram into the tables,
Codd’s Relational database rules .

Method of Question Paper -External- End Sem Theory Exam


Assessment
Design Data Base with the help of various Relational
algebra Operations and Normal Forms. Hrs Marks
Course Outcome 2

Learning Outcome Define various Relational algebra Operations. 8 10


1
Relational algebra and relational calculus, Relational algebra Basic operations
Contents like select, Project, Union ,set difference, Cartesian product, rename and
additional operations like Set intersection, Natural Join, Division ,Join(Left,
right and Full) .

Method of Question Paper -External- End Sem Theory Exam


Assessment

Learning Outcome Compare Relational algebra and relational calculus 8 10


2 Query Language.

Introduction and Comparison of relational calculus i.e. Tuple oriented and


Contents
domain oriented relational calculus

Question Paper-Internal Progressive Test


Method of
Assessment
Identify Functional dependency and Referential 8 10
Learning Outcome
integrity.
3
Functional dependency: Definition, inference axioms for functional
Contents dependency, closure, cover and equivalence of FD, Referential integrity

Question Paper -External- End Sem Theory Exam


Method of
Assessment
Build Data Base with the help of Normal Forms . 10 10
Learning Outcome
4
Data Base Design : Concept of Normalization , Decomposition i.e Lossless or
Contents Lossy Decomposition, Normal forms, 1 NF, Data anomalies in 1 NF, Partial
dependency, 2 NF, Data anomalies in 2 NF , Transitive Dependency, 3NF, Data
anomalies in 3 NF, Boyce-Codd Normal Form.
Question Paper -External- End Sem Theory Exam
Method of
Assessment
Develop Query Based Data Base Applications.
Course Outcome 3 Hrs Marks

Learning Outcome Build Data Base and Tables with the help of DDL.
9 10
1
Introduction to my SQL language, Structure of my SQL statements & my SQL
writing guidelines, Data Definition commands: Creating a Database, Show,
Contents Creating a Table ,Use, Altering the Database, Altering the Table, RENAME,
DESCRIBE, Dropping the Database, Dropping the Table, TRUNCATE.

Method of Lab Manual -External Practical


Assessment
Learning Outcome
Modify Data Base and Tables with the help of DML. 9 10
2
Data Manipulation Statements: SELECT statement that are described in
Contents (FROM, WHERE, GROUP BY, HAVING, ORDER BY),INSERT, UPDATE,
DELETE, REPLACE.

Method of External Practical


Assessment
Make use of Aggregate Functions and Various
Learning Outcome 9 10
Constraints .
3

Aggregate Function (AVG, COUNT, MAX, MIN, SUM). Defining primary


Contents keys, foreign keys, Unique Keys, CHECK constraints in a table, removing
constraints from table.
External Practical
Method of
Assessment
Conclude Various Joins Operations and View 9 10
Learning Outcome
statements .
4
Joins (INNER, OUTER, SELF ) and SELF Join, View (CREATE VIEW
Contents
Statement, ALTER VIEW Statement , DROP VIEW Statement.

Lab Manual -Internal Practical- lab work


Method of
Assessment
Course Outcome 4 Outline Advance Database Concepts. Hrs Marks
Explain Trigger and Database 10
Learning Outcome 09
1 Connectivity to various languages.

Contents Overview of Trigger with example, Database Connectivity with Various


Languages
Method of Internal Practical- lab work
Assessment
Learning Outcome Define Transaction, co ncurre ncy contro l,
06 10
2 Object and Cloud based Database.
Introduction to transactions (ACID Property and Implicit and Explicit
Transaction) , Overview of concurrency control, Object based database and
Contents their Classification , Basic Concepts of Cloud based database with its
advantages and Disadvantages.

Method of Assignment- Internal(Term Work)


Assessment
Learning Outcome Compare Data mining, Data
05 10
3 Wareho using and Distributes Database.
Explain Data mining & Data Warehousing with it’s advantages and
Disadvantages , Comparison of Data mining & Data Warehousing,
Contents
Architecture of Distributed Database and also it’s Classification with its
advantages and Disadvantages
Method of
Assessment Question Paper -External- End Sem Theory Exam
SCHEME FOR LEARNING Branch Code Course Code CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Understand the Basic concepts and need of Database Management systems including Query Language and Data Model.
LO Description Identify the need of Database Management systems with the help of Architecture of DBMS.
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract. /Tut
Remarks
S. No. Learning Content Method Process Hrs. Hrs. LRs Required
1 DBMS Concepts, Database approach v/s Traditional Lecture Teacher will explain 08 0 Handouts NIL
Traditional file accessing approach, method + the contents and /Videos + ppt /
Advantages of database systems, Database Handout+Videos provide handout to Books / E-
system applications, Three level architecture: students. Contents
Mapping between views, DBMS users, Teacher will
conduct quiz to
Functions of DBA and designer, Schemas and
make students
instances, Data independence.
practice their
knowledge

SCHEME OF ASSESSMENT

Method of Assessment Description of Assessment Maximum Marks Resources Required External /


S. No. Internal
For the given content student will be
asked Need of Database Management Question/Test Paper
1 End Sem Theory Exam systems and their Architecture 10 External
/quiz questions

ADDITIONAL INSRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code
CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Understand the Basic concepts and need of Database Management systems including Query Language and Data Model.
LO Description Elaborate Overall Structure of Database and Query Language
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract. /Tut
S. No. Remarks
Learning Content Method Process Hrs. Hrs. LRs Required
1 Data Base Language: Data Definition Traditional Lecture Teacher will explain 6 Handouts NIL
Language, Data Manipulation Language and method + Handout + the contents and /Videos + ppt /
Data Control Language, Overall Database Videos provide handout to Books / E-
Structure. students. Contents
Teacher will
conduct quiz to
make students
practice their
knowledge
SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal

For the given content student will


Question/Test Paper
1 Internal Progressive Test be asked Data Base Language and 10 Internal
/quiz questions
Database Structure.

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


Course L
SCHEME FOR LEARNING Branch Code Code CO Code O
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403
C
Format No. 4
o
d
COURSE NAME DATABASE MANAGEMENT SYSTEM e

CO Description Understand the Basic concepts and need of Database Management systems including Query Language and Data Model.
LO Description Classify Data Model and give Example of Entity Relation Data Model.
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract. /Tut
S. No. Learning Content LRs Required Remarks
Method Process Hrs. Hrs.
Introduction and Classification of Traditional Lecture Teacher will explain 08 00 Handouts /Videos + NIL
Data Model, Comparison between method + Handout + the contents and ppt / Books / E-
the three types of models, ER data Videos provide handout to Contents
model: Entitles and attributes, students.
Entity types, Relationship among Teacher will conduct
1 quiz to make students
entities, representation of
association & relationship, Defining practice their
the E-R diagram, Concept of knowledge.
Generalization, Aggregation and
Specialization, keys.
SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Resources Required External /


Marks Internal

For the given content student will


Question/Test Paper /quiz
1 End Sem Theory Exam be asked about Data Model and 10 External
questions
features of ER Model

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code
CO Code
LO Code Format No.

RGPV (Diploma Wing ) Bhopal OUTCOME C04 403 4


03
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Understand the Basic concepts and need of Database Management systems including Query Language and Data Model.
LO Description Explain Relational Model and Codd’s Relational database Rules.
SCHEME OF STUDY
Pract.
Teaching - Learning Description of Teach LRs
S. No. Learning Content /Tut Hrs. Remarks
Method T-L Process Hrs. Required
1 Relational Model: Attributes and Domains, tuples, Traditional Lecture Teacher will 08 00 Handouts NIL
relations and their schemas, relation representation, method + Handout + explain the /Videos + ppt
relationship, integrity rules (Primary, Unique, Videos contents and / Books / E-
Candidate, Check, Foreign key), Transforming ER provide handout Contents
diagram into the tables, Codd’s Relational database to students.
rules. Teacher will
conduct quiz to
make students
practice their
knowledge.
SCHEME OF ASSESSMENT

S. No. Method of Assessment Maximum Marks Resources Required External /


Description of Assessment Internal

For the given content


student will be asked about Question/Test Paper
1 End Sem Theory Exam 10 External
Relational Model , Integrity /quiz questions
rules and Codd’s Rules

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


LO
SCHEME FOR LEARNING Branch Code Course Code
CO Code Co
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 de Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Design Data Base with the help of various Relational algebra Operations and Normal Forms.
LO Description Define various Relational algebra Operations.
SCHEME OF STUDY
Teaching -Learning Description of T-L Pract. /Tut
S. No. Learning Content LRs Required Remarks
Method Process Teach Hrs. Hrs.
1 Relational algebra and relational Traditional Lecture Teacher will explain 08 00 Handouts /Videos + NIL
calculus, Relational algebra Basic method + Handout + the contents and ppt / Books / E-
operations like select, Project, Videos provide handout to Contents
Union ,set difference, Cartesian students.
product, rename and additional Teacher will conduct
quiz to make
operations like Set intersection,
students practice
Natural Join, Division ,Join(Left,
their knowledge.
right and Full)

SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Resources Required External /


Marks Internal

For the given content student will


Question/Test Paper /quiz
1 End Sem Theory Exam be asked about Relational algebra 10 External
questions
Operations and relational calculus.

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Design Data Base with the help of various Relational algebra Operations and Normal Forms.
LO Description Compare Relational algebra and relational calculus Query Language
SCHEME OF STUDY
Teaching - Learning Description of Teach Pract. /Tut
S. No. Learning Content LRs Required Remarks
Method T-L Process Hrs. Hrs.
1 Introduction and Comparison ofTraditional Lecture Teacher will 8 00 Handouts /Videos + NIL
relational calculus i.e. Tuple oriented method + Handout + explain the ppt / Books / E-
and domain oriented relational calculus Videos contents and Contents
provide handout
to students.
Teacher will
conduct quiz to
make students
practice their
knowledge

SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal

For the given content student will


be asked Tuple oriented and Question/Test Paper /quiz
1 Internal Progressive Test 10 Internal
domain oriented relational questions
calculus.

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Design Data Base with the help of various Relational algebra Operations and Normal Forms.
LO Description Identify Functional dependency and Referential integrity
SCHEME OF STUDY
Teaching - Learning Description of T- Pract. /Tut
S. No. Remarks
Learning Content Method L Process Teach Hrs. Hrs. LRs Required
1 Functional dependency: Definition, Traditional Lecture Teacher will 08 00 Handouts /Videos NIL
inference axioms for functional method + Handout + explain the + ppt / Books / E-
dependency, closure, cover and Videos contents and Contents
equivalence of FD, Referential integrity provide handout
to students.
Teacher will
conduct quiz to
make students
practice their
SCHEME OF ASSESSMENT
knowledge.

S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal

For the given content student will


Question/Test Paper /quiz
1 End Sem Theory Exam be asked about Functional 10 External
questions
Dependency and it’s rules

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


L
SCHEME FOR LEARNING Branch Code Course Code CO Code O
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403
C
Format No. 4
o
d
COURSE NAME DATABASE MANAGEMENT SYSTEM e
CO Description Design Data Base with the help of various Relational algebra Operations and Normal Forms.
LO Description Build Data Base with the help of Normal Forms.
SCHEME OF STUDY
Teaching - Description of T-L Teach Pract.
S. No. Learning Content LRs Required Remarks
Learning Method Process Hrs. /Tut Hrs.
1 Data Base Design : Concept of Traditional Lecture Teacher will explain the 10 00 Handouts /Videos + NIL
Normalization , Decomposition method + Handout contents and provide ppt / Books / E-
i.e Lossless or Lossy + Videos handout to students. Contents
Decomposition, Normal forms, 1 Teacher will conduct quiz
NF, Data anomalies in 1 NF, to make students practice
Partial dependency, 2 NF, Data their knowledge.
anomalies in 2 NF , Transitive
Dependency, 3NF, Data
anomalies in 3 NF, Boyce-Codd
Normal Form.
SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Resources Required External /


Marks Internal

For the given content student


Question/Test Paper /quiz
1 End Sem Theory Exam will be asked to Design Data 10 External
questions
Base using Normal forms

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR Branch Code Course Code CO Code LO Code
RGPV (Diploma Wing ) Bhopal
LEARNING OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Develop Query Based Data Base Applications.
LO Description Build Data Base and Tables with the help of DDL.
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract. LRs Required
S. No. Remarks
Learning Content Method Process Hrs. /Tut Hrs.
1 Introduction to my SQL language,Traditional Lecture Teacher will explain the 00 09 Handouts NIL
Structure of my SQL statements & my SQL method + Handout + contents and provide /Videos + ppt /
writing guidelines, Data Definition Videos handout to students. Books / E-
commands: Creating a Database, Show, Teacher will conduct Contents
Creating a Table ,Use, Altering the quiz to make students
practice their
Database, Altering the Table, RENAME,
knowledge.
DESCRIBE, Dropping the Database,
Dropping the Table, TRUNCATE.

SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal

For the given content student will


be asked to Create Table , Lab Manual /quiz
1 External Practical 10 External
Database and Dropping the Table question/Vi-Va
, Database

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Develop Query Based Data Base Applications.
LO Description Modify Data Base and Tables with the help of DML.
SCHEME OF STUDY
Teaching - Description of
Pract. /Tut LRs
S. No. Learning Content Learning T-L Process Teach Hrs. Remarks
Hrs. Required
Method
1 Data Manipulation Statements: SELECT statement Traditional Teacher will 00 09 Handouts NIL
that are described in (FROM, WHERE, GROUP BY, Lecture method + explain the /Videos + ppt
HAVING, ORDER BY),INSERT, UPDATE, DELETE, Handout + Videos contents and / Books / E-
REPLACE. provide Contents
handout to
students.
Teacher will
conduct quiz to
make students
practice their
SCHEME OF ASSESSMENT
knowledge.

S. No. Method of Assessment Description of Assessment Maximum Marks External /


Resources Required Internal

For the given content student will


Lab Manual /quiz
1 External Practical be asked to Manipulate Table , 10 External
question/Vi-Va
Database using DML Statements

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


CO
SCHEME FOR LEARNING Branch Code Course Code Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Develop Query Based Data Base Applications.
LO Description Make use of Aggregate Functions and Various Constraints.
SCHEME OF STUDY
Teaching -
Teach Pract. /Tut
S. No. Learning Content Learning Description of T-L Process LRs Required Remarks
Hrs. Hrs.
Method
1 Aggregate Function (AVG, COUNT, Traditional Teacher will explain the 00 09 Handouts NIL
MAX, MIN, SUM). Defining primary keys, Lecture contents and provide handout /Videos + ppt /
foreign keys, Unique Keys, CHECK method + to students. Books / E-
constraints in a table, removingHandout + Teacher will conduct quiz to Contents
Videos make students practice their
constraints from table.
knowledge.

SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal

For the given content student will


Lab Manual /quiz
1 External Practical be asked to about use of Aggregate 10 External
question/Vi-Va
function and Constraint.

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Develop Query Based Data Base Applications.
LO Description Conclude Various Joins Operations and View statements.
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract. /Tut
S. No. Learning Content LRs Required Remarks
Method Process Hrs. Hrs.
1 Joins (INNER, OUTER, SELF) and SELF Join, Traditional Lecture Teacher will explain the 00 09 Handouts /Videos NIL
View (CREATE VIEW Statement, ALTER method + Handout + contents and provide + ppt / Books / E-
VIEW Statement, DROP VIEW Videos handout to students. Contents
Statement. Teacher will conduct quiz
to make students practice
their knowledge.

SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal

For the given content student will


be asked to about use of Various Lab Manual /quiz
1 Internal Practical- lab work 10 Internal
Joins Operation and View question/Vi-Va
Statement.

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code
CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Outline Advance Database Concepts.
LO Description Explain Trigger and Database Connectivity to various languages.
SCHEME OF STUDY
Description of T-L Teach Pract. /Tut LRs
S. No. Remarks
Learning Content Teaching -Learning Method Process Hrs. Hrs. Required
1 Overview of Trigger with example, Traditional Lecture method + Teacher will explain 00 09 Handouts NIL
Database Connectivity with VariousHandout + Videos the contents and /Videos +
Languages provide handout to ppt / Books
students. / E-Contents
Teacher will
conduct quiz to
make students
practice their
knowledge.

SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Marks Resources External /


Required Internal

For the given content student will


Lab Manual /quiz
1 Internal Practical- lab work be asked to about Trigger and 10 Internal
question/Vi-Va
Connectivity of Database

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code
CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Outline Advance Database Concepts.
LO Description Define Transaction, concurrency control, Object and Cloud based Database.
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract. /Tut LRs
S. No. Remarks
Learning Content Method Process Hrs. Hrs. Required
1 Introduction to transactions (ACID Property and Traditional Lecture Teacher will explain 06 00 Handouts NIL
Implicit and Explicit Transaction), Overview of method + Handout + the contents and /Videos + ppt
concurrency control, Object based database and Videos provide handout to / Books / E-
their Classification , Basic Concepts of Cloud students. Contents
Teacher will
based database with its advantages and
conduct quiz to
Disadvantages.
make students
practice their
SCHEME OF ASSESSMENT
knowledge.

S. No. Method of Assessment Description of Assessment Maximum Marks Resources External /


Required Internal

For the given content student will


Assignment/quiz
1 Internal(Term Work) be asked to about Transaction, 10 Internal
question/Vi-Va
Object and Cloud based database.

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


SCHEME FOR LEARNING Branch Code Course Code
CO Code LO Code
RGPV (Diploma Wing ) Bhopal
OUTCOME C04 403 Format No. 4
COURSE NAME DATABASE MANAGEMENT SYSTEM
CO Description Outline Advance Database Concepts.
LO Description Compare Data mining, Data Warehousing and Distributes Database.
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract.
S. No. Remarks
Learning Content Method Process Hrs. /Tut Hrs. LRs Required
1 Explain Data mining & Data Warehousing withTraditional Lecture Teacher will explain the 05 00 Handouts /Videos NIL
its advantages and Disadvantages , method + Handout + contents and provide + ppt / Books / E-
Comparison of Data mining & DataVideos handout to students. Contents
Warehousing, Architecture of Distributed Teacher will conduct
Database and also it’s Classification with its quiz to make students
practice their
advantages and Disadvantages
knowledge.

SCHEME OF ASSESSMENT

S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal

For the given content student will


be asked about Data mining , Data Question/Test Paper
1 End Sem Theory Exam 10 External
Warehousing and Architecture of /quiz questions
Distributed Database.

ADDITIONAL INSTRUCTIONS FOR THE HOD/ FACULTY (IF ANY)


DATABASE MANAGEMENT SYSTEM
COURSE OUTCOME(S) & LEARNING OUTCOME(S)

STUDENT WILL BE ABLE TO-

Course objective Details

CO-1 Understand the Basic concepts and need of Database Management


systems including Query Language and Data Model.

CO-2 Design Data Base with the help of various Relational algebra
Operations and Normal Forms

CO-3 Develop Query Based Data Base Applications.

CO-4 Outline Advance Database Concepts.


Total

Understand the Basic concepts and need of Database


CO-1 Management systems including Query Language and Data
Model.

Identify the need of Database Management systems with the


LO-1
help of Architecture of DBMS.
LO-2 Elaborate Overall Structure of Database and Query Language.

Classify Data Model and give Example of Entity Relation


LO-3
Data Model.

Explain Relational Model and Codd’s Relational database


LO-4
Rules.
CO-2 Design Data Base with the help of various Relational
algebra Operations and Normal Forms.

LO-1 Define various Relational algebra Operations .

LO-2 Compare Relational algebra and relational calculus Query


Language

LO-3 Identify Functional dependency and Referential


integrity.

LO-4 Build Data Base with the help of Normal Forms.

CO-3 Develop Query Based Data Base Applications.

LO-1 Build Data Base and Tables with the help of DDL.

LO-2 Modify Data Base and Tables with the help of DML.

LO-3 Make use of Aggregate Functions and Various Constraints.

LO-4 Conclude Various Joins Operations and View statements.

CO-4 Outline Advance Database Concepts.

LO-1 Explain Trigger and Database Connectivity to various languages.

Define Transaction, concurrency control, Object and Cloud based


LO-2
Database.

LO-3 Compare Data mining, Data Warehousing and Distributes Database.


Course Learning
Assessment Hours Marks Remark
outcome outcome
LO1 End Sem
External(th) 8 10
Theory Exam
CO1 Internal (th) 06 10 Prog Test -I
LO2
(30 HRS)
8 10 End Sem
(40 MARKS) External(th)
LO3 Theory Exam
End Sem
LO4 External(th) 8 10
Theory Exam
LO1 End Sem
External(th) 08 10
Theory Exam
CO2 Internal (th) 08 10 Prog Test -II
LO2
(34 HRS)
End Sem
(40MARKS) External(th) 08 10
LO3 Theory Exam
End Sem
LO4 External(th) 10 10
Theory Exam
External (pr) 09 10 Practical exam
LO1
CO3 External (pr) 09 10 Practical exam
LO2
(36 HRS)
(40 MARKS) External (pr) 09 10 Practical exam
LO3
LO4 Internal (pr) 09 10 Lab Work

Internal (pr) 09 10 Lab Work


LO1
CO4
(20 HRS) Internal(th) 06 10 Term Work
LO2
(30 MARKS)
End Sem
External(th) 05 10
LO3 Theory Exam

End Sem
Term Work Lab Practical
Progressive exam Total
(Internal) work(Internal) (External)
(External)
CO1 10 30 40
CO2 10 30 40
CO3 10 30 40
CO4 10 10 10 30

Total 20 10 20 30 70 150

You might also like