Scribd
Upload
12 views4 pages

Sit 200 Dbms

The SIT 200 course at Murang’a University of Technology focuses on Database Management Systems, aiming to provide students with knowledge in database design, data storage, and manipulation. The course includes various teaching methodologies and assessments, with a structure covering topics such as database models, design, normalization, and SQL. Recommended textbooks and reference journals are provided to support learning throughout the academic year 2024/2025.

Uploaded by

maxwellwachira100
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views4 pages

Sit 200 Dbms

The SIT 200 course at Murang’a University of Technology focuses on Database Management Systems, aiming to provide students with knowledge in database design, data storage, and manipulation. The course includes various teaching methodologies and assessments, with a structure covering topics such as database models, design, normalization, and SQL. Recommended textbooks and reference journals are provided to support learning throughout the academic year 2024/2025.

Uploaded by

maxwellwachira100
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Murang’a University of Technology

School of Computing and Information Technology


Department of Information Technology
SIT 200 COURSE OUTLINE
Unit Name: Database Management Systems

Credit hours: 3 hours

Pre-requisite: None

Academic Year: 2024/2025

Year of Study: Year 2 Semester 1

Page 1 of 4
Course Purpose

To equip the learner with sufficient knowledge on database design, data storage and
manipulation.

Learning Outcomes

By the end of the course unit, the learner should be able to:

i) Explain the principles underlying database systems.


ii) Distinguish the database approach from traditional file processing applications.
iii) Define relational database models
iv) Define a database and basic storage structure
v) Use the data definition and manipulation languages.

Teaching Methodology
Lecture method, Group activities, Class discussions, Demonstrations and illustrations,
Audio/Tele/video conferencing, and E-learning activities.
Instructional Materials
The recommended instructional materials for this course include the following:
Overhead projector, Handouts, Charts, Text books, Chalk/white board marker, supervised
laboratory exercises, Networking toolkit, Network and internetworking devices, video,
multimedia, Computers-Desktop/Laptops/ tablets and e-journals
Course Assessment

30% Continuous Assessment (CATS 20%, Assignment 10%) 70% End of Semester
Examination.

CONTENT
WEEK TOPIC SUB-TOPICS

Page 2 of 4
1 Introduction Essentials of DBMS

2 Database Models Relational, Network, File, Object oriented


model.
3 CAT 1

4 Database Design Data Schema, Conceptual, Logical and


Physical designing
5 Entity Relationship Modeling Chen model and Craw’s foot model

6 CAT 2

7 Data Normalization 1NF, 2NF, 3NF

8 Database Implementation DBMS tools

9 SQL Creating database, creating tables,


modifying tables. Modifying records,
deleting records.
10 CAT 3

11 SQL Various methods of retrieving records


and manipulating data during retrieval,
SQL Joins
12 NoSQL NoSQL databases

13 Trends in DBMS and DBMS Trends and presentations


project presentations
14 & 15 End of Semester Examinations

Course Text Books

1. Coronel, C. Morris, S. & Rob, P. (2012), Database Systems: Design, Implementation,


and Management, Cengage Learning
2. Coronel C. & Morris, S. (2014) Database Systems: Design, Implementation, &
Management, Cengage Learning; 11th Edition, ISBN-10: 1285196147 | ISBN-13: 978-
1285196145
3. Connolly, T. &Begg, C. (2005), Database Systems: A Practical Approach to Design,

Page 3 of 4
Implementation, and Management, Addison Wesley.

Reference Journals

1. Association for Information Technology Trust, Journal of Information Technology,


ISSN: 0268-3962 EISSN: 1466-4437
2. Database Journal – Daily Database Management, ISSN 2069 - 3230
3. International Journal of Intelligent Information and Database Systems, ISSN online:
1751-5866 ISSN print: 1751-5858

Page 4 of 4

You might also like