LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

COURSE-FILE
Data Base Management System CS 502

Year / Semester : III/ V

Department :Computer Science & Engineering
Academic Year : 2023-24
Program : B.Tech

COURSE FILE INDEX

COURSE
NAME FILE (THEORY)
OF FACULTY: __________________
CONTENTS
Sr. Description Page
No. No.
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
Page 1
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Time Table (Pasted on the Back side of the File Cover)

1 Attendance Sheet
2 Vision and Mission of the Institute
3 Vision and Mission of the Department
4 Academic Calendar
5 Internal Marks Policy
6 University Scheme of Examination
7 Course Rational & Curriculum
8 Bloom’s Taxonomy
9 Course Outcomes (COs) & Program Outcomes (POs), Program
Specific Outcomes (PSOs) and Program Educational Objectives
(PEOs)
10 CO-PO & CO-PSO Mapping
11 Course Planning and Coverage (CPC)
12 Assessment Rubrics
13 Tutorial Sheets
14 Quiz/Assignments Sheets
15 Question Papers: Old University Examination
16 Question Papers: Mid-Semester Examination
17 Record of Marks: Mid-Sem Examination ( CO wise with 5 nos
of Mid sem copy)
18 Record of Marks: Quiz/Assignment/Tutorials ( CO wise)
19 Sessional Marks
20 Record of Marks: End Sem University Examination
21 Attainment Sheet: CO, PO & PSO
22 Course Handouts

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 2
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Individual Time Table

Lakshmi Narain College of Technology Excellence, Bhopal

Time -Table (B.Tech. V Sem) Session: July-Dec 2023
FM0902-A
Branch: CSE Section: Room No./Building: ___________ Classes w.e.f.: ____________
Day/ I II III IV V VI VII VIII
(Period 10:00-11:20 11:20-12:10 12:10- 01:00 01:00-01:50 01:50-02:40 02:40-03:30 03:30-04:15 04:15-5:00
&Time)
MON
TUE
WED
THU
FRI
SAT
Subjects as per University Scheme Lab. Room No. Name of Contact No.
Faculty

Lab Batch I: Mentor/Library

Lab Batch II:

Issued by:
Prepared by: Approved By:

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 3
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Vision and Mission of the Institute

Vision of the institute

To become a pioneer institute in technical education and innovations to build competent
technocrats and leaders for the nation.

Mission of the institute

1. To enhance the academic environment with innovative teaching learning processes and modern
tools.
2. To Practice and nurture high standards of human values, transparency and accountability.
3. To collaborate with other academic and research institutes as well as industries in order to
strengthen education and research.
4. To uphold skill development for employability and entrepreneurship for interdisciplinary research
and innovations.

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 4
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Vision and Mission of the Department

Vision of the Department

To be a centre of excellence for providing quality technical education to develop future leaders
with the aspects of research & computing, Software product development and entrepreneurship.

Mission of the Department

Mission No. Mission Statements

To offer academic programme with state of art curriculum having flexibility for
M1 accommodating the latest developments in the areas of Computer science
engineering.

To conduct research and development activities in contemporary and emerging

M2
areas of computer science & engineering.

To inculcate moral values & entrepreneurial skills to produce professionals

M3
capable of providing socially relevant and sustainable solutions.

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 5
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Academic Calendar

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 6
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Marks Policy

B.Tech. I - IV YEAR (Common to all Disciplines)

Grading System w.e.f. Session: July-Dec, 2023
Theory Slot (20 Marks)

MST MARKS (Best of two) [OUT OF 20] Total

MIDSEM Marks (MST) 20 20

Theory Slot (10 Marks)

Attendance
Teacher Marks Total
Marks
Quiz Assignment Marks 5 5 10

Practical Slot (20 Marks)

Teacher Assessment
Attendance Marks Total
Marks
Lab Work/sessional Marks 15 5 20
Lab Work/sessional Marks (Language
10 10 20
Lab)

Practical Slot (10 + 10 Marks) for Workshop Practices/ Swachh Bharat Summer Internship Unnat Bharat
Abhiyan / Rural Outreach /Internship-I/II/III
Lab Work ( As-
Teacher Assess-
Attendance Marks signment /Quiz Total
ment Marks
etc.)
Lab Work Marks 5 NIL 5 10
Assignment Quiz /Term work Marks 5 5 NIL 10
Swachh Bharat Summer Internship Unnat 5
5 NIL 10
Bharat Abhiyan / Rural Outreach (MATHEMATICS)
Internship-I/BT107 40 MINIMUM
(as per I year internship 10 RANGE (30 50
training) TO 50 )

Attendance Mark Distribution

(For MIDSEM/Quiz Assignment/Lab Work & Sessional Marks etc. )
% Attendance Marks Marks
(Theory + Practical) (Max 5 marks) (Max 10 marks)
75% and above 5 10
60-74% 4 8
50-59% 3 6
40-49% 2 4
Below 40% 1 2

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 7
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Course Scheme (Scheme RGPV)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 8
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Course Content (Syllabus RGPV)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Rationale

UNIT 01: DBMS Concepts and architecture Introduction

 DBMS Introduction: Understanding the foundational principles of the Database and data
model for anyone entering the field of Data Base.
 ER Model: Knowledge of how to draw ER diagram, including its conversion to relational
model, is fundamental for building database.
 Database Structure: Introducing about the basic architecture of DBMS. Database languages

UNIT 02: RDBMS

 Relational Data models: Relational Model is the backbone of DBMS system, and under-
standing its basics, formatting, and structure is essential.
 Keys: Understanding of DBMS keys are essential. It helps in extracting data from relation
also used to represent the relationship between different entities.
 Query languages: Understanding how to work with SQL.

UNIT 03: Data Base Design

 Need of Functional dependency: Introducing the concept of Functional Dependency and its
importance in database.
 Normalization,: introducing about the problem of data redundancy. How to normalize the
relation
 Query Optimization: understanding the steps required for optimizing a query.

UNIT 04: Transaction Processing Concepts

 Transaction: Understanding Transaction System and various test of Serializability.

 Concurrency Control Techniques: Introducing about concurrency problems and various
technique to achieve concurrency in transaction execution.
 Distributed databases: Going beyond basic database, understanding distributed database,
data mining and data warehousing.

UNIT 05: Study of Relational Database Management Systems through Oracle/PL SQL

Oracle/PL SQL
 Oracle/PL SQL: Understanding RDBMS software, memory structures, and background pro-
cess.
 Data dictionary: introducing data dictionary and different indexing methods used in dbms.
 Stored procedures: Practical skills in using tools like MySQL for database management are
crucial for real-world applications.

Blooms Taxonomy

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Program Outcomes as defined by NBA (PO)

Engineering Graduates will be able to:

1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

fundamentals, and an engineering specialization to the solution of complex engin-

eering problems.
2. Problem analysis: Identify, formulate, review research literature, and analyze complex
engineering problems reaching substantiated conclusions using first principles of mathem-
atics, natural sciences, and engineering sciences.
3. Design/development of solutions: Design solutions for complex engineering problems
and design system components or processes that meet the specified needs with appropri-
ate consideration for the public health and safety, and the cultural, societal, and environ-
mental considerations.
4. Conduct investigations of complex problems: Use research-based knowledge and re-
search methods including design of experiments, analysis and interpretation of data, and
synthesis of the 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 modeling to complex engineer-
ing activities with an understanding of the limitations.
6. The engineer and society: Apply reasoning informed by the contextual knowledge to
assess societal, health, safety, legal and cultural issues and the consequent responsibil-
ities relevant to the professional engineering practice.
7. Environment and sustainability: Understand the impact of the professional engineer-
ing solutions in societal and environmental contexts, and demonstrate the knowledge
of, and need for sustainable development.
8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities
and norms of the engineering practice.
9. Individual and team work: Function effectively as an individual, and as a member or
leader in diverse teams, and in multidisciplinary 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 the
engineering and management principles and apply these to one’s 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 en-
gage in independent and life-long learning in the broadest context of technological
change.

Program Specific Outcomes (PSO)

A graduate of computer science and engineering program will develop

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

PSO1: An ability to apply technical knowledge of computer science and engineering

fundamentals to become employable in industry.

PSO2: An ability to develop programming skills using modern software tools and
techniques.

PSO3: An ability to develop real time projects for problem solving of domains such as
Machine Learning, Cyber security, block chain and big data

PSO4: An ability to grab research, higher studies and entrepreneurship opportunities towards
society with moral values and ethics

Program Educational Objectives (PEO):

PEO 1: Evolve as globally competent computer professionals, researchers and entrepren-
eurs possessing collaborative and leadership skills, for developing innovative
solutions in multidisciplinary domains.
PEO 2: Excel as socially committed computer engineers having mutual respect, effective
communication skills, high ethical values and empathy for the needs of society.
PEO 3: Involve in lifelong learning to foster the sustainable development in the emerging
areas of technology.

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

CO-PO Mapping and CO-PSO Mapping

COURSE OUTCOMES for CS-502: Database Management System
Students should be able to

CO502.1 Explain various data models with their merits and demerits.
CO502.2 Construct sql queries using various data manipulation statements.
CO502.3 Apply normalization up to 3nf on given relations.
CO502.4 Summarize concurrency control mechanism for database transactions.
CO502.5 Utilize triggers and cursors in pl/sql programming.

CO-PO: Mapping for CS-502: Database Management System

PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO1 PO11 PO12
CO 0
CO502.1 3 2 - - - - - - 1 1 2 2
CO502.2 3 - 3 - - - - - 1 - - 2
CO502.3 3 2 2 - - - - - 1 - 2 2
CO502.4 3 2 - 3 3 3 - - 1 1 - 2
CO502.5 3 - 3 3 - - - - 1 - - 2
3 2 3 2 3 3 - - 1 1 2 2

CO-PSO Mapping for CS-502: Database Management System

PSO PSO1 PSO2 PSO3 PSO4
CO
CO502.1 3 - 2 1
CO502.2 3 3 2 -
CO502.3 3 3 2 2
CO502.4 3 - 3 -
CO502.5 3 3 3 -
3 3 3 2

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Course Completion Unit Plan with Delivery Methods

Lakshmi Narain College of Technology Excellence, Bhopal

Course Planning and Coverage (CPC)

Subject Name of Subject Academic Branch Sem./Sec. w.e.f. Classes

Code Session
CS-502 Database Management System 2023 CSE V/B,C
Lect. No. Topics to be Covered (Planning) Topics Actually Taught (Covered)
Title Date Target Instructional Title Date Covered
CO No. Method Aid References CO No.
10-08-2023
1 DBMS Concepts And Architecture Introduction CO1 Lecture White-Board Book(1)
11-08-2023
2 Database Approach V/S Traditional File CO1 Lecture White-Board Book(2)
12-08-2023
3 Accessing Approach CO1 Lecture White-Board Book(3)
13-08-2023
4 Advantages Of Database Systems CO1 Lecture White-Board Book(3)
14-08-2023
5 Data Models CO1 Lecture White-Board Book(1)
14-08-2023 Book(3)
6 Schemas And Instances CO1 Lecture White-Board
16-08-2023 Book(3)
7 Data Independence CO1 Lecture White-Board
17-08-2023 Book(3)
8 Data Base Language And Interfaces CO1 Lecture White-Board
18-08-2023 Book(1)
9 Overall Database Structure CO1 Lecture White-Board
19-08-2023 Book(1)
10 Functions Of DBA And Designer CO1 Lecture White-Board
19-08-2023 Book(3)
11 ER Data Model: Entitles And Attributes CO1 Lecture White-Board
21-08-2023 Book(3)
12 Entity Types CO1 Lecture White-Board

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 16
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

22-08-2023 Book(3)
13 Defining The E-R Diagram CO1 Lecture White-Board
23-08-2023 Book(3)
14 Concept Of Generalization CO1 Lecture White-Board
24-08-2023
15 Aggregation And Specialization CO1 Lecture White-Board Book(1)
25-08-2023 Book(3)
16 Transforming ER Diagram Into The Tables CO1 Lecture White-Board
26-08-2023
17 Various Other Data Models CO1 Lecture White-Board Book(3)
18 Object Oriented Data Model 26-08-2023 CO1 Lecture White-Board Book(3)

19 Network Data Model 28-08-2023 CO1 Lecture White-Board Book(3)

20 Relational Data Model 29-08-2023 CO1 Lecture White-Board Book(3)

21 Comparison Between The Three Types Of Models 30-08-2023 CO1 Lecture White-Board Book(3)

31-08-2023 Book(1)
22 TUTORIAL CO1
23 Relational Data Models: Domains 01-09-2023 CO2 Lecture White-Board Book(1)

24 Tuples, Attributes 02-09-2023 CO2 Lecture White-Board Book(1)

Relations, Characteristics Of Relations 02-09-2023 CO2 Lecture White-Board Book(1)

25
Keys, Key Attributes Of Relation 04-09-2023 CO2 Lecture White-Board Book(1)
26
Relational Database 05-09-2023 CO2 Lecture White-Board Book(1)
27
Schemas, Integrity Constraints 06-09-2023 CO2 Lecture White-Board Book(3)
28
Referential Integrity 07-09-2023 CO2 Lecture White-Board Book(3)
29
Intension And Extension 08-09-2023 CO2 Lecture White-Board Book(3)
30
Relational Query Languages: SQL-DDL, DML 09-09-2023 CO2 Lecture White-Board Book(3)
31
Integrity Constraints 09-09-2023 CO2 Lecture White-Board Book(3)
32

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 17
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Complex Queries, 11-09-2023 CO2 Lecture White-Board Book(1)

33
Various Joins 12-09-2023 CO2 Lecture White-Board Book(1)
34
Various Joins 13-09-2023 CO2 Lecture White-Board Book(1)
35
Indexing 14-09-2023 CO2 Lecture White-Board Book(1)
36
Triggers 15-09-2023 CO2 Lecture White-Board Book(1)
37
Assertions 16-09-2023 CO2 Lecture White-Board Book(1)
38
Relational 16-09-2023 CO2 Lecture White-Board Book(1)
39
Algebra Calculus 18-09-2023 CO2 Lecture White-Board Book(1)
40
Algebra Calculus 19-09-2023 CO2 Lecture White-Board Book (1)
41
Relational Calculus 20-09-2023 CO2 Lecture White-Board Book(1)
42
Relational Calculus 21-09-2023 CO2 Lecture White-Board Book(1)
43
Relational Algebra Operations Like Select, Project, Join 22-09-2023 CO2 Lecture White-Board
44 Book (2)
Relational Algebra Operations Like Select, Project, Join 23-09-2023 CO2 Lecture White-Board Book (2)
45
Division, Outer Union. 23-09-2023 CO2 Lecture White-Board Book (2)
46
Types Of Relational Calculus 25-09-2023 CO2 Lecture White-Board Book (2)
47
Tuple Oriented And Domain Oriented 26-09-2023 CO2 Lecture White-Board Book (2)
48
Relational Calculus And Its Operations. 27-09-2023 CO2 Lecture White-Board Book (2)
49
28-09-2023
50 TUTORIAL CO2
49 Data Base Design 29-09-2023 CO3 Lecture White-Board Book(1)

50 Introduction To Normalization 12-09-2023 CO3 Lecture White-Board Book(1)

51 Normal Forms 13-09-2023 CO3 Lecture White-Board Book(1)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
Page 18
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

52 Functional Dependency 30-09-2023 CO3 Lecture White-Board Book(1)

Decomposition,Dependency Preservation And Losless

53 CO3 Lecture White-Board Book(1)
Join 30-09-2023

54 Problems With Null Valued And Dangling Tuples 30-09-2023 CO3 Lecture White-Board Book(1)

55 Multivalued Dependencies 03-10-2023 CO3 Lecture White-Board Book(1)

56 Query Optimization: Introduction 04-10-2023 CO3 Lecture White-Board Book(1)

Steps Of Optimization, Various Algorithms To Implement

57 CO3 Lecture White-Board Book(1)
Select 05-10-2023

58 Project And Join Operations Of Relational Algebra 06-10-2023 CO3 Lecture White-Board Book(1)

Optimization Methods: Heuristic Based, Cost Estimation

59 CO3 Lecture White-Board Book(1)
Based 07-10-2023

60 07-10-2023 Book(1)
TUTORIAL CO3
61 Transaction Processing Concepts: Transaction System 09-10-2023 CO4 Lecture White-Board Book(1)

62 Testing Of Serilizability 10-10-2023 CO4 Lecture White-Board Book(1)

63 Serializability Of Schedules 11-10-2023 CO4 Lecture White-Board Book(1)

64 Conflict & View Serializable Schedule 12-10-2023 CO4 Lecture White-Board Book(1)

65 Recoverability,Recovery From Transaction Failures 13-10-2023 CO4 Lecture White-Board Book(1)

66 Log Based Recovery. Checkpoints Deadlock Handling 14-10-2023 CO4 Lecture White-Board Book(1)

67 Concurrency Control Techniques 14-10-2023 CO4 Lecture White-Board Book(1)

Concurrency Control Locking Techniques For

68 CO4 Lecture White-Board Book(1)
Concurrency Control 16-10-2023

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 19
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

69 Time Stamping Protocols For Concurrency Control 17-10-2023 CO4 Lecture White-Board Book(1)

70 Validation Based Protocol, Multiple Granularity 18-10-2023 CO4 Lecture White-Board Book(1)

Multi Version Schemes, Recovery With Concurrent

71 CO4 Lecture White-Board Book(1)
Transaction. 19-10-2023

72 Introduction To Distributed Databases, Datamining, 20-10-2023 CO4 Lecture White-Board Book(1)

73 Datawarehousing, Object Technology And DBMS, 21-10-2023 CO4 Lecture White-Board Book(1)

74 Comparative Study Of OODBMS Vs DBMS . 21-10-2023 CO4 Lecture White-Board Book(1)

Temporal, Deductive, Multimedia, Web & Mobile

75 CO4 Lecture White-Board Book(1)
Database. 23-10-2023

76 24-10-2023
TUTORIAL CO4
77 Study Of Relational Database Management Systems - 25-10-2023 CO5 Lecture White-Board Book(1)

78 Oracle/Postgres SQL/Mysql: 26-10-2023 CO5 Lecture White-Board Book(1)

79 Architecture, Physical Files, Memory Structures, 27-10-2023 CO5 Lecture White-Board Book(1)

Background Process. Concept Of Table Spaces, Segments,

80 CO5 Lecture White-Board Book(1)
Extents And Block. 28-10-2023

81 Dedicated Server, Multi Threaded Server. Distributed 28-10-2023 CO5 Lecture White-Board Book(1)

82 Database, Database Links 30-10-2023 CO5 Lecture White-Board Book(1)

83 Snapshot, Data Dictionary 31-10-2023 CO5 Lecture White-Board Book(1)

84 Dynamic Performance View.Security 01-11-2023 CO5 Lecture White-Board Book(1)

Role Management, Privilege Management, Profiles,

85 CO5 Lecture White-Board Book(1)
Invoker Defined Security Model. 02-11-2023

86 SQL Queries, Data Extraction From Single 03-11-2023 CO5 Lecture White-Board Book(1)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 20
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Multiple Tables Equi-Join, Non Equi-Join, Usage Of Like,

87 CO5 Lecture White-Board Book(1)
Any, All, Exists, In Special Operators 04-11-2023

88 Usage Of Like, Any, All, Exists, In Special Operators. 04-11-2023 CO5 Lecture White-Board Book(1)

Hierarchical Queries, Inline Queries, Flashback Queries,

89 CO5 Lecture White-Board Book(1)
Introduction Of ANSI SQL 06-11-2023

90 Anonymous Block, Nested Anonymous Block 07-11-2023 CO5 Lecture White-Board Book(1)

91 Branching And Looping Constructs In ANSI SQL 08-11-2023 CO5 Lecture White-Board Book(1)

92 Cursor Management: Nested And Parameterized Cursors 09-11-2023 CO5 Lecture White-Board Book(1)

93 Cursor Management: Nested And Parameterized Cursors 10-11-2023 CO5 Lecture White-Board Book(1)

94 Out, In Out Type Parameters 11-11-2023 CO5 Lecture White-Board Book(1)

95 Oracle Exception Handling Mechanism 11-11-2023 CO5 Lecture White-Board Book(1)

96 Stored Procedures 13-11-2023 CO5 Lecture White-Board Book(1)

97 Usage Of Parameters In Procedures 14-11-2023 CO5 Lecture White-Board Book(1)

98 User Defined Functions Their Limitations 14-11-2023 CO5 Lecture White-Board Book(1)

99 Triggers 16-11-2023 CO5 Lecture White-Board Book(1)

100 Mutating Errors 17-11-2023 CO5 Lecture White-Board Book(1)

101 Instead Of Triggers 18-11-2023 CO5 Lecture White-Board Book(1)

102 TUTORIAL CO5

Name Designation Signature with Date

Start of Session End of Session
Faculty Ashish Chaturvedi Assistant Professor 10-Aug-23 20-Nov-2023
Checked By Dr. Megha Kamble HOD
Approved By Dr Anil Saxena Principal

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 21
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

References books
1. Date C J, “An Introduction To DatabaseSystem”, Pearson Educations
2. Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
3. Rob, “ Data Base System:Design Implementation & Management”, Cengage Learninig
4. Elmasri, Navathe, “Fundamentals Of Database Systems”, Pearson Educations
5 . Atul Kahate , “ Introduction to Database Management System”, Pearson Educations
6. Oracle 9i Database Administration Fundamental-I, Volume I, Oracle Press,TMH.
7. Paneerselvam,”DataBase Management System”, PHI Learning

Examples of Instructional Methods: Lecture, Case Study, Group Discussion etc.

Examples Instructional Aid: White Booard, PC, Web, Projector,
Models etc.

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 22
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Assessment Rubrics

Rubrics for Assessment of Theory Marks

Area of Direct Fair Good Excellent

Assessment

Theory Quiz Content shows very basic Content is accurate, thorough and Meets and exceeds
(10) understanding and includes shows clear understanding through “Good” criteria
several inaccuracies.(0-2) appropriate explanation. (3-7) with rich
explanation,
examples and
application of
content Idea.(8-
10)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 23
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Tutorial Sheets (CO-Based)

Open Elective CS- 502 Database Management System
TUTORIAL-1 (CO1)
1. What do you understand by database management system?
2. What is logical data independence and why is it important?
3. Explain the concept of ER Diagram
4. what are data models?
5. Write the advantages and disadvantages of DBMS?

TUTORIAL-2 (CO2)
1. Give a brief description of data definition language ,data manipulation language. Give
few commands of both the languages?
2. Explain the distinctions among the terms primary key, candidate keys and super keys?
3. Define the following terms :
(a) relational schema
(b) relational database schema
(c) domain
(d) relation instance
(e) relation cardinality
(f) relation degree
4. Explain the distinction between disjoint and overlapping constraints ?
5. Explain the database constraints?

TUTORIAL-3 (CO3)
1. Determine the closer of the following set of functional dependencies for a relation
scheme R(A,B,C,D,E,F,G,H), F={ AB→C, BD→EF, AD→G, A→H} List the candidate
keys of R.
2. What is normalization? What are the conditions are required for a relation to be in 2NF,
3NF and BCNF explain with examples.
3. Define Armstrong axioms for FD’s?
4. Explain about Loss less-join dependency?

TUTORIAL-4 (CO4)
1. Explain ACID property in detail.
2. Write short note on serializability.
3. Why we need to do recovery in DBMS.
4. Write short note on concurrency control.

TUTORIAL-5 (CO5)
1. What do you understand by RDBMS?
2. Explain the dedicated servers and multi-threaded server.
3. What is data dictionary? What it stores? How can this information be useful in
DBMS.
4. Write short note on branching and looping constructs in ANSI SQL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 24
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

.
Quiz/Assignments Sheets (CO-Based)

Unit – I
1 What refers to the copies of the same data (or information) occupying the mem-
ory space at multiple places -( CO1)
2 Which level of data abstraction refers to, that describes exactly how the data ac-
tually stored?-( CO1)
3 To which of the term "DBA" referred-(CO1)

4 What is the use of ER model in DBMS -(CO1)

5 What do you understand by Generalization-(C01)

Unit – II
1 Explain the components of relational model.-( CO2)

2 Write a short note on primary key-(CO2)

3 Define selection operator in relation algebra. (CO2)

4 Define set difference operator in relation algebra - (CO2)

5 List the types of join-(CO2)

Unit – III
1 Explain about functional dependency.-(CO3)

2 What is prime and non-prime attribute? -( CO3)

3 Explain 3NF and BCNF -( CO3)

4 Write a short note decomposition.-( CO3)

5 What is use of normalization?-(,CO3)

Unit – IV
1 What is transection? -( CO4)

2 Write about ACID properties of transaction.-( CO4)

3 Write about concurrency problems.-(CO4)

4 Explain the term schedule. -(CO4)

5 What is serial and non-serial schedule? -(CO4)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
Page 25
 LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Unit – V
1 Explain the concept of memory structure. (CO5)

2 What do you mean by distributed database? (CO5)

3 What is Data dictionary? (CO5)

4 What is the concept of privilege management (CO5)

5 What is the role of Triggers? (CO5)

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 26
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

RGPV Old Question Papers

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 27
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 28
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 29
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 30
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 31
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 32
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 33
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 34
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 35
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Mid-Semester-I Question Papers

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 36
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Mid-Semester-II Question Papers

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 37
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

Notes

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 38
LAKSHMI NARAIN COLLEGE OF TECHNOLOGY EXCELLENCE, BHOPAL

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Page 39