Engineering Notes
Engineering Notes
COURSE PACK
for
Lecture Hours/Week :5
Ma x Marks :
100
:4
To learn the fundamentals of data models and to conceptualize and depict a database system using ER diagram. To make a study of
SQL and relational database design. To understand the internal storage structures using different file and indexing techniques which
will help in physical DB design. To know the fundamental concepts of transaction processing- concurrency control techniques and
recovery procedure. To have an introductory knowledge about the emerging trends in the area of distributed DBOO DB- Data mining
and Data Warehousing and XML. To implement the design of the tables in DBMS. To write queries to get optimized outputs. To
store, retrieve and view the contents. To generate report based on customized need
Course Outcomes
1.C01 - Apply the Conepts of Entity-Relationship (E-R) model for the given application.
4.CO4 - Examine different file organization concepts for data storage in Relational databases
Unit-
1
Hours :9
y
S llabus Unit Mapping
[Link] Needs:Local,
[Link] Focused:Employability,
Introduction to File and Database systems- Database system structure – Data Models – Introduction to Network and
Hierarchical Models – ER model – Relational Model – Relational Algebra.
Unit-
2
Hours :9
y
S llabus Unit Mapping
[Link] Needs:Local,
[Link] Focused:Employability,
RELATIONAL MODEL
SQL – Data definition- Queries in SQL- Updates- Views – Integrity and Security – Relational Database design – Functional
dependencies and Normalization for Relational Databases (up to BCNF).
Unit-
3
Hours :9
y
S llabus Unit Mapping
[Link] Needs:Local,
[Link] Focused:Employability,
Introduction to NOSQL Systems ,The CAP Theorem, Document-Based NOSQL Systems and MongoDB, NOSQL Key-Value
Stores, Column-Based or Wide Column NOSQL Systems, NOSQL Graph Databases and Neo4j
Unit-
4
Hours :9
y
S llabus Unit Mapping
[Link] Needs:Local,
[Link] Focused:Employability,
Record storage and Primary file organization- Secondary storage Devices- Operations on FilesHeap File- Sorted Files-
Hashing Techniques – Index Structure for files –Different types of Indexes- B-Tree - B+ Tree – Query Processing.
Unit-
5
Hours :9
y
S llabus Unit Mapping
[Link] Needs:Local,
[Link] Focused:Employability,
TRANSACTION MANAGEMENT
Transaction management -Transaction Processing – Introduction- Need for Concurrency control- Desirable properties of
Transaction- Schedule and Recoverability- Serializability and Schedules – Concurrency Control – Types of Locks- Two
Phases locking- Deadlock- Time stamp based concurrency control – Recovery Techniques – Concepts- Immediate Update-
Deferred Update - Shadow Paging.
Essential References :
Abraham Silberschatz, Henry F. Korth and S. Sudarshan- “Database System Concepts”, Seventh Edition, McGraw-Hill, 2021
Recommended References :
Andreas Meier · Michael Kaufmann "SQL & NoSQL Databases", Springer -2019
Raghu Ramakrishnan, “Database Management System”, Tata McGraw-Hill Publishing Company, 2003
Additional Information
List of Experiments
3. Data Manipulation Language (DML) and Data Control Language (DCL) commands in RDBMS.
4. Implementation of Joins
5. Implementation of Views
Evaluation Pattern
CIA:70/100
ESE:30/100
PROGRAMME: BTech CSE, BTech IT, BTech CSE (AIML), BTech CSE(DS), BTech CSE (IoT)
If any student missed classes of this course, they may discuss with the course instructor during all working days after 4.00pm with prior
permission.
3
Data Manipulation Language (DML) and Data Control Language (DCL) commands in
2
RDBMS.
4 Implementation of Joins 2
5 Implementation of Views 2
6 High-level language extension with Cursors. 2
7 High level language extension with Triggers 2
8 Procedures and Functions 2
9 No Sql using monogoDB 3
10 Mini Project 5
TEXT BOOKS
Abraham Silberschatz, Henry F. Korth and S. Sudarshan- Database System Concepts, Seventh Edition, McGraw-Hill,
2021
REFERENCE BOOKS
Andreas Meier Michael Kaufmann "SQL & NoSQL Databases", Springer -2019
Raghu Ramakrishnan, Database Management System, Tata McGraw-Hill Publishing Company, 2003
OTHER RESOURCES
[Link]
COURSE PREREQUISITES
COURSE CODE COURSE NAME DESCRIPTION SEMESTER
CS134P/CSE234P Computer Programming Variables, Data types, Functions I/II
COURSE OBJECTIVES
To learn the fundamentals of data models and to conceptualize and depict a database system using ER diagram.
To make a study of SQL and relational database design. To understand the internal storage structures using
different file and indexing techniques which will help in physical DB design.
To know the fundamental concepts of transaction processing- concurrency control techniques and recovery
procedure.
To have an introductory knowledge about the emerging trends in the area of distributed DB-OO DB- Data mining
and Data Warehousing and XML.
To implement the design of the tables in DBMS. To write queries to get optimized outputs.
To store, retrieve and view the contents. To generate report based on customized need
COURSE OUTCOMES
REVISED BLOOMS TAXONOMY
Sl NO DESCRIPTION
(RBT)LEVEL
1.
Apply the Concepts of Entity-Relationship (E-R) model for the given L3
application
Apply Normalization principles to create and manipulate relational
2. L3
databases
3. Apply the concepts of Non-Relational Models L3
4.
Examine different file organization concepts for data storage in L4
Relational databases
5. Apply the transaction management principles on relational databases L3
CONTENT BEYOND THE SYLLABUS - TO MEET INDUSTRY / PROFESSIONAL REQUIREMENTS
Sl NO DESCRIPTION PROPOSED ACTIONS *
1. Django in day-to-day industry applications Guest Lecture
*Proposed Actions: Industry Visit/Guest Lectures/Technical Talks/Workshops/NPTEL etc
DELIVERY / INSTRUCTIONAL METHODOLOGIES
(Tick the Relevant Methodologies)
Chalk & Talk PPT Student seminars Guest Lecture Industry Visit
Web resources
MOOC / NPTEL Group Activity Field Study
Introduction to databased
Introduction to File and Database
3+1 I and traditional file storage. C&T/PPT T1
systems
Query practice
ER terminologies and
ER models, Relational Algebra relationship. Procedural
3+1 I C&T/PPT T1
query language processing
examples, Query practice
3
Storage or collection of
documents, rather than a
3+1 III Document-Based NOSQL Systems storage or collection of C&T/PPT T1, R2
structured data. Query
8
practice
Rollback, Recoverable
Schedule and Recoverability,
3+1 V Schedules, Ensures conflict C&T/PPT T1/R2
Concurrency Control Types of Locks,
serializable schedules
14
Project
Requirement % % % 100% % % 100%
Examination
Debugging and
% % 100% % % % 100%
Execution
CIA I Component 1
MCQ
Description
Multiple Choice Question (MCQ) is a form of assessment in which the candidates are asked to select the best possible answer out of the
choices from a list of several possible answers, of which only one is correct. The consolidated marks will be converted to 10 marks.
Instructions :
Time Limit: 30 Mins
Marks: 30 Marks ( Reduced to 10 Marks)
Tentative Date: Last Week of July
Venue: Respective classrooms(LMS/Gform).
Clear explanation of issue, Appropriate Analysis, Proper organization and logical flow
Technology Tools used along with their Purpose:
Manual
Evaluation Rubrics
Criteria (Sample )
Area of Evaluation Mark
Correct Answer 1
Wrong Answer 0
Post Assessment:
CIA I Component 2
ER MODEL DESIGN
Description
To enable students in understanding well the data modeling concepts and to relate in a practical scenario
To test the presentation skills in communication, writing, drawing
Evaluation Rubrics:
A Complete response
Good response with Explanation not well Poor Explanation/
Problem statement with detailed
clear information defined Problem identification
explanation
Clear diagram with Clear diagram with
Use of Visuals In-appropriate diagram No diagram
details incomplete details
Shows complete
Shows substantial Weak implementation of
Knowledge process of ER
process of ER Diagram ER Diagram to Schema Lack of understanding
Demonstration Diagram to Schema
to Schema mapping mapping
mapping
Proper citations
Usage of Library Citations are partially Citations are not much Citations are not
mentioned in the
resources relevant relevant available.
poster
CIA 2
MSE- Mid Semester Examinations
CIA 3
CIA Details:
RDBMS Mini Project
Marks: 20
Duration: 30 Minutes(Demonstration)
Date: 03-10-2023
Venue: Offline
Technology Tools used along with their Purpose: PPT and Databases
Evaluation Rubrics
CRITERIA
Detailed and
Average Moderate
Identification n of extensive Good explanation of Minimal explanation
explanation of the explanation of the
Problem Domain and explanation of the the purpose and of the purpose and
purpose and need purpose and need of
Detailed Analysis purpose and need of need of the project need of the project
of the project; the project
the project
Explanation
Minimal
of the
Collects a Moderate explanation of the
Study of the Detailed and specifications
great deal of study of the specifications
Existing extensive and the
information existing and the
Systems and explanation of the limitations of the
and good systems; limitations of
Feasibility of specifications and existing systems not
study of the collects the existing
Project the limitations of the very
existing some basic systems;
Proposal existing systems satisfactory;
systems; information incomplete
limited
information
information
Incomplete Only Some
All objectives of the Objectives of the
Good justification to justification to the objectives of the
proposed work are proposed work are
Objectives the objectives; objectives proposed work are
well defined; Steps either not identified
and Methodology to be proposed; Steps well defined; Steps
to be followed to or not well defined;
Methodology followed is specified are mentioned but to be followed to
solve the defined Incomplete and
Used but detailing is not unclear; without solve the defined
problem are clearly improper
done justification to problem are not
specified specification
objectives specified properly
Completely Good amount of Fair amount of Average amount of
Implementation and implemented and work done with work done with work done with Not completed
Presentation well presented good presented good presented good presented
OBSERVATION EVALUATION
DETAILS : Observation
DESCRIPTION : Student has to write the algorithm OR to draw ER diagram to solve the given problem.
ASSIGNMENT DETAILS:
Question set will be uploaded in LMS.
Each student has to understand the given problem and has to Design/develop the ER diagram /write Queries in the observation notebook.
After implementation and executing the queries for the problems given,, the result has to be recorded in the observation.
Students have to complete their observations and get it evaluated by their respective faculty members during the same lab. In case a student is
absent due to a genuine reason, he/she will complete the experiment, and show it to the respective teachers before the next lab.
MARKS : 20
EVALUATION RUBRICS:
Average
Excellent Good
Needs Improvement
Skills (40-69%)
(<40%)
(90-100%) (70-89%)
Efficient design and
Efficient design but lacking Lacking in both Design and No efficient design and
Algorithm implemented based on
in implementation Implementation poor implementation
scenario
No logical results
Appropriate Results with Appropriate Results without
Output Mistakes in the output
formatting. formatting
RECORD EVALUATION
DETAILS : Record
ASSIGNMENT DETAILS:
Each student has to record the aim, algorithm, program what they executed in the lab with output and result.
Record will be corrected in the Lab itself.
Viva questions will be asked and marks will be awarded for that.
Lab record needs to be completed when the student comes for the next lab. In case it is not completed, it will be evaluated for 80% of the marks.
MARKS : 10
MSE EVALUATION
DETAILS : MSE
ASSIGNMENT DETAILS:
Question to create table and manipulate the values will be given to students. Students are expected to write the query and execute it.
According to the implementation, Marks will be awarded.
MARKS : 50
Venue : Lab
EVALUATION RUBRICS:
At Least 70% questions At Least 50% questions Less than 50% questions
Viva (10) All questions answered
answered answered answered
ESE EVALUATION
DETAILS : ESE
ASSIGNMENT DETAILS:
Questions will be given to students. Students have to design the solution and implement it in Oracle DB.
According to the implementation, Marks will be awarded.
MARKS : 50
Venue : Lab
EVALUATION RUBRICS:
At least 70% questions At least 50% questions Less than 50% questions
Viva (10) All questions answered
answered answered answered
EVALUATION RUBRICS:
Average
Excellent Good
Skills (40-69%) Needs Improvement (<40%)
(90-100%) (70-89%)
Correctness of algorithm, 10 -20% mistake in the 21-40% mistake in the Above 40% mistake in the
Appropriate format
code and output format format format.
CO-PO MAPPING
PO PO PSO
CO 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
CO1 2 1 - - 2 - - - - - - - - 3 -
CO2 3 2 1 1 1 - - - - - - - - 2 -
CO3 3 3 2 2 1 - - - - - - - - 1 -
CO4 3 2 1 1 1 - - - - - - - - 2 -
CO5 2 1 - - 2 - - - - - - - - - -
Average 2.6 1.8 1.3 1 1.4 - - - - - - - - 2 -
Mention 3 for HIGH, 2 for MODERATE, 1 for LOW and - for Nil
COURSE OUTCOME ATTAINMENT TARGET
CO Proficiency Level Attainment Level Remarks
CO1 75% 60%
CO2 75% 60%
CO3 75% 60%
CO4 75% 60%
CO5 75% 60%
Dr Naveen J
Prof. Santhrupth B C
Dr Samisha Shukla
Dr Sathish
Prof. T. Vigneshwaran
Prof. Manjunath Swamy CProf. Chaitra P C
Prepared byReviewed by Approved by (Faculty in-charge) HoD
Page | PAGE15