Course
Title: Advanced Database Management
System Course
No. : ICT. Ed 525 Nature of course: Theoretical + Practical Level:
M.Ed.
Credit Hour: 3(2T+1P) Semester:
Second Teaching Hour:
80(32+48)
1.
Course
Description The course,
Advanced Database Management System, is a core course for students studying
towards acquiring the Master of Education in Information and Communication
Technology (M. Ed. ICT). In this course we will study about the Database
Management System as a key role in Information Management. Various principles
of database management system (DBMS) as well as its advanced features are
discussed. This course also considers distributed databases and emerging trends
in database system. The overall aim of this course is to introduce the various
ways of designing and implementing database systems, its features and
distributed databases. The course commences with basic design and
implementation of relational databases.. 2.
General
Objective of the Course: The overall
aims and objectives of this course are to:
3.
Course
Outlines:
Part II: Practical Laboratory Work
with oracle latest version: 1.
Normalization 2.
E- R Diagram 3.
DDL and DML using SQL. 4.
Selection, Projection Operations 5.
Join Strategies 6.
Structure of Query Optimizer 7.
Distributed Transaction Management and Concurrency
Control 8.
Distributed Deadlock and Recovery Management 9.
Distributed Query Processing 10. View
Management and Authorization and Protection 11. XML 3
Instructional Techniques The
instructional techniques for this course are divided into two groups. First group consists of general instructional
techniques applicable to most of the units. The second group consists of
specific instructional techniques applicable to specific units. 4.1
General Techniques ·
Providing
the reading materials to the students to familiarize the units. ·
Lecture,
question-answer, discussion, brainstorming, practical, and buzz session. 4.2
Specific Instructional Techniques
Note: Specific
Instructional Techniques may or may not require for each of the units mentioned
in course outline. 4
Evaluation 4. Evaluation
(Internal Assessment and External Assessment):
Note:
Students must pass separately in internal assessment, external practical exam /
viva and or semester examination. 4.1 Evaluation for Part I ( Theory) a.
Internal Evaluation 40% Internal
evaluation will be conducted by course teacher based on following activities: 1)
Attendance 5
points 2)
Participation
in learning activities 5
points 3)
First assessment
( written assignment) 10
points 4)
Second assessment
( Term examination ) 10 points 5)
Third assessment
( Internal Practical Exam/Case Study) 10 points
Note:
First assignment/assessment might be book
review /article review, quiz, home assignment etc according to nature of
course. Second assignment/assessment might be project work, case study,
seminar, survey/field study and individual/group report writing, term paper
based on secondary data or review of literature and documents etc and third
assignment will be term exam. b. External Evaluation (Final
Examination) 40%
4.2
Evaluation for part II
(practical) 20%
5.2.1.
Practical Examination Evaluation
Scheme a)
External
assessment …………………………100% i)
Record
book ………………………. 20% ii)
Laboratory
work exam/Case………..40% iii)
VIVA………………………………..40% 5
Recommended
books and reading materials (including relevant published articles in national
and international journals) Ramakrishnan,
R., & Gehrke, J. (2003). Database management
systems. Boston: McGraw-Hill. Ray, C. (2009).
Distributed database systems. Delhi: Pearson. Powell, G.
(2007). Oracle 10g database administrator: implementation & administration.
Boston, Mass.: Thomson Course Technology. Reference
materials Abramson, I.
(2004). Oracle Database 10g: a beginner’s guide. Delhi: McGraw-Hill. Connolly, T.
(2008). Business database systems. Harlow, England ; New York:
Addison-Wesley. Rajan,
C. (2007). Oracle 10g database administrator II: backup/recovery & network
administration. Australia ; Boston, Mass: Thomson Course Technology. Silberschatz,
A. (2011). Database system concepts (6th ed.). New York: McGraw-Hill. |