Subject SubjectName L T P S Marks
[Link]
Code
Category
Credits
External
Total
CIA
CC11 Database Management Core 5 - - - 3 4 25
75 100
System
LearningObjectives
LO1 Toenablethestudentstolearnthedesigningofdatabasesystems,foundationon the
relationalmodelofdataandnormalforms.
LO2 Tounderstoodtheconceptsofdatabasemanagementsystem,designsimpleDatabase
models
LO3 TolearnandunderstandtowritequeriesusingSQL,PL/SQL.
LO4 Toenablethestudentstolearnthedesigningofdatabasesystems,foundationon the
relationalmodelofdataandnormalforms.
LO5 Tounderstoodtheconceptsofdatabasemanagementsystem,designsimpleDatabase
models
UNIT Contents [Link]
I Database Concepts:Database Systems - Data vs Information -
Introducing the database -File system - Problems with file system
– Database systems. Data models - Importance - Basic Building 15
Blocks-Businessrules-EvolutionofDatamodels-Degreesof
DataAbstraction
II Design Concepts: Relational database model - logical view of
data-keys -Integrityrules-relationalsetoperators-datadictionary
15
andthesystemcatalog-relationships-dataredundancyrevisited-
indexes-codd'[Link]-ERdiagram
III NormalizationofDatabaseTables:Databasetablesand
Normalization – The Need for Normalization –The Normalization
Process – Higher level Normal Form.
Introduction to SQL: Data Definition Commands – Data 15
Manipulation Commands – SELECT Queries – Additional Data
DefinitionCommands–AdditionalSELECTQueryKeywords–
JoiningDatabaseTables.
IV Advanced SQL:Relational SET Operators: UNION – UNION
ALL – INTERSECT - [Link] Join Operators: Cross Join –
Natural Join – Join USING Clause – JOIN ON Clause – Outer
[Link] Queries and Correlated Queries: WHERE – IN –
15
HAVING – ANY and ALL – FROM. SQL Functions: Date and
Time Function – Numeric Function – String Function –
Conversion Function
V PL/SQL:A Programming Language: History – Fundamentals –
Block Structure – Comments – Data Types – Other Data Types –
Variable Declaration – Assignment operation –Arithmetic
[Link] Structures and Embedded SQL: Control
Structures – Nested Blocks – SQL in PL/SQL – DataManipulation
15
– Transaction Control statements. PL/SQL Cursors and
Exceptions: Cursors – Implicit Cursors, Explicit Cursors and
Attributes – Cursor FOR loops – SELECT…FOR UPDATE –
WHERECURRENTOFclause–CursorwithParameters–
CursorVariables–Exceptions–TypesofExceptions.
Total 75
CourseOutcomes ProgrammeOutcomes
CO Oncompletionofthiscourse,students will
CO1 UnderstandthevariousbasicconceptsofDataBase
[Link] PO1
andcomparevariousdatamodels.
CO2 [Link]
basicconceptsofRelationalDataModel,Entity- PO1, PO2
RelationshipModel.
CO3 Design database schema considering normalization
and relationships within database. Understand and
constructdatabaseusingStructuredQueryLanguage.
PO4, PO6
Attain a good practical skill of managing and
retrievingofdatausingDataManipulation Language
(DML)
CO4 Classify the different functions and various join
operationsandenhancetheknowledgeofhandling PO4,PO5, PO6
multipletables.
CO5 LearntodesignDatabaseoperationsandimplement
PO3, PO5
usingPL/[Link]/SQL
anddevelopprogramsusingCursors,Exceptions
TextBook
1 Coronel,Morris,Rob,"DatabaseSystems,Design,ImplementationandManagement",
NinthEdition
2 NileshShah,"DatabaseSystemsUsingOracle",2ndedition,PearsonEducationIndia,
2016
ReferenceBooks
1. Abraham Silberschatz, Henry [Link] and [Link],“Database System
Concepts”,McGrawHillInternationalPublication,VIEdition
2. ShioKumarSingh,“DatabaseSystems“,Pearsonpublications,IIEdition
3. [Link],RDBMS,MarghamPublications,2016
WebResources
1. WebresourcesfromNDLLibrary,E-contentfromopen-sourcelibraries
MappingwithProgrammeOutcomes:
CO/PSO PSO1 PSO2 PSO3 PSO4 PSO5 PSO6
CO1 3 2 1 2 1 2
CO2 3 3 2 2 3 3
CO3 3 3 2 3 3 2
CO4 3 2 3 2 2 3
CO5 3 2 2 2 3 3
Weightageofcourse
contributed 15 12 10 11 12 13
toeachPSO
S-Strong-3 M-Medium-2L-Low-1
SubjectCode SubjectName L T P S Marks
[Link]
Category
Credits
External
Total
CIA
CC12 Database Core - - 5 - 4 5 25
Management 75 100
System lab
LearningObjectives
LO1 Toenablethestudentstolearnthedesigningofdatabasesystems,foundation
ontherelationalmodelofdataandnormalforms.
LO2 Tounderstoodtheconceptsofdatabasemanagementsystem,designsimple
Databasemodels
LO3 TolearnandunderstandtowritequeriesusingSQL,PL/SQL.
LO4 Toenablethestudentstolearnthedesigningofdatabasesystems,foundation
ontherelationalmodelofdataandnormalforms.
LO5 Tounderstoodtheconceptsofdatabasemanagementsystem,designsimple
Databasemodels
Listof Exercises: [Link] Hours
I. SQL
1. DDLCOMMANDS
2. DMLCOMMANDS
3. TCLCOMMANDS
II. PL/SQL
4. FIBONACCISERIES
5. FACTORIAL 75
6. STRINGREVERSE
7. SUMOFSERIES
8. TRIGGER
[Link]
[Link] USING
CURSOR
[Link]
10. LIBRARY
MANAGEMENTSYSTEM
[Link]
Total 75
CourseOutcomes ProgrammeOutcomes
CO Oncompletionofthiscourse,studentswill
CO1 UnderstandthevariousbasicconceptsofData
Base System. Difference between file system PO1
andDBMSandcomparevariousdatamodels.
CO2 [Link]
the basicconcepts of RelationalData Model, PO1, PO2
Entity-Relationship Model.
CO3 Design database schema considering
normalization and relationships within
[Link]
using Structured Query Language. Attain a PO4, PO6
good practical skill of managing and
retrieving of data using Data Manipulation
Language(DML)
CO4 Classify the different functions and various
joinoperationsandenhancetheknowledgeof PO4,PO5, PO6
handlingmultipletables.
CO5 Learn to design Data base operations and
implementusingPL/[Link]
PO3, PO4
basicsofPL/SQLanddevelopprograms using
Cursors, Exceptions
TextBook
1 Coronel,Morris,Rob,"DatabaseSystems,Design,Implementationand
Management",NinthEdition
2 NileshShah,"DatabaseSystemsUsingOracle",2ndedition,PearsonEducation
India,2016
ReferenceBooks
1. AbrahamSilberschatz,[Link],“DatabaseSystem
Concepts”,McGrawHillInternationalPublication,VIEdition
2. ShioKumarSingh,“DatabaseSystems“,Pearsonpublications,IIEdition
WebResources
1. WebresourcesfromNDLLibrary,E-contentfromopen-sourcelibraries
MappingwithProgrammeOutcomes:
CO/PSO PSO1 PSO2 PSO3 PSO4 PSO5 PSO6
CO1 3 2 3 3 3 2
CO2 3 3 1 2 2 2
CO3 2 2 3 3 3 3
CO4 2 2 3 3 3 1
CO5 2 3 3 3 3 3
Weightageofcourse
contributedto each 12 12 13 14 14 11
PSO
S-Strong-3 M-Medium-2L-Low-1