Skip navigation.

CSI2102

No public posts in this group. You must register or login and become a subscriber in order to post messages, and view any private posts.

University of Guyana
Faculty of Natural Sciences
Department of Computer Science

Course Outline

CSI 2102: Database & Information Management Systems
4 Credits
3/1/0
2012-2013

Lecturer:
• Mr. Girendra Persaud (girendra1@gmail.com) (Office: C16)

Assistant Lecturer:
• Ms. Vineeta Persaud (vineeta.persaud@gmail.com) (Office: ....)

Course Summary & Mode of Delivery:
This course aims to establish data management technologies, efficient data design, implementation and management concepts; data security and other issues.
Learning Outcomes:
At the end of the course, students should be able to interpret abstract data requirements, design and implement secure and efficient data management facilities.

Co-requisites and Pre-requisites:
None.

Duration: Thirteen (13) weeks.

Content:
Week 1
- Course Introduction
- Purpose of Database Management Systems (DBMS)
- Database Design Process

Week 2
- Data Models - overview
- Database System Structure – abstract view of the components
- Database Systems

Week 3
- Relational Model
- Entity Relationship Modeling (concepts)
- Entity Relationship Modeling (application)

Week 4
- Relational Database Design
- Normalisation
- Normalisation (application)

Week 5
- Relational Algebra – Primitive Operations
- Relational Model - Joins
- Query Language

Week 6
- Structured Query Language
- Structured Query Language (examples)
- Structured Query Language (application)

Week 7
- Design & Implementation of a Data Management Solution - Worked Example
- General Review
- Test #1

Week 8
- Network Data Model
- Hierarchical Data Model
- Object Oriented Databases

Week 9
- File Organization – Heap,
Ordered Files
- File Organization – Hashing
- Indexing

Week 10
- Query Processing & Access Methods
- Concurrency Control
- Locking (2PL)

Week 11
- Deadlock Handling
- Data Recovery
- Crash Recovery

Week 12
- Security & Integrity
- Database Architecture: Client/Server & Distributed
- Data Mining

Week 13
- Database Current Trends and Web-based Application
- Test #2
- General Revision

Evaluation:
Coursework 40%
- Test 1: 10%
- Test 2: 10%
- Assignment: 5%
- Project: 15%
Final Examination 60%

Grading Scheme:
A – 100-75
B- 74- 65
C- 64-50
D- 49-40
F- less than 40

Recommended Texts:
• Ramez Elmasri, Shamkant B. Navathe. - Fundamentals of database systems 6th ed.
• Ullman, J. -Principles of Database Systems. Maryland: Computer Science Press, 1988
• Pratt, P. & Adamski. -Database Systems Management and Design. Boston: Boys & Fraser Publishing Company, 1998 or Any Introductory book on Database Systems.

Syndicate content