Fundamentals of Database Systems | BES YR1 SEM1

TEAM UNIVERSITY
FACULTY OF APPLIED SCIENCES
DEPARTMENT OF INFORMATION TECHNOLOGY

TEACHING PORTFOLIO
Lecturer: Muwanguzi Benard
Contact: +256708646603
Email: info@ictconnect.org    Email 2: muwanguzibenard2017@gmail.com

Course Unit: Fundamentals of Database Systems (DICT 5222)

Course Description

This course introduces learners to the fundamentals of database systems, with emphasis on relational database models, design techniques, and implementation using Microsoft Access.

Course Objectives

• To introduce concepts and importance of database systems.
• To develop skills in database design and implementation.
• To train learners in SQL and relational database management.
• To provide hands-on experience using Microsoft Access.

Learning Outcomes

By the end of this course, learners will be able to:

1. Explain key concepts of database systems.
2. Design relational databases using ER diagrams.
3. Normalize database structures.
4. Write SQL queries for data manipulation and retrieval.
5. Implement a functional database using MS Access.

Course Content

Unit 1: Introduction to Databases (3 hrs)

• Data, information, and databases
• File vs database systems

Unit 2: Database Models (6 hrs)

• Hierarchical, network, and relational models
• Advantages of relational model

Unit 3: Database Design & ER Modeling (6 hrs)

• Entity-Relationship diagrams
• Attributes, keys, and relationships

Unit 4: Normalization (6 hrs)

• 1NF, 2NF, 3NF
• Case study on normalization

Unit 5: SQL Basics (6 hrs)

• DDL: Create, Alter, Drop
• DML: Insert, Update, Delete, Select

Unit 6: Advanced SQL Queries (6 hrs)

• Joins, subqueries, aggregate functions
• Views and indexing

Unit 7: Practical with Microsoft Access (9 hrs)

• Creating tables, forms, queries, reports
• Building a small database project

Unit 8: Database Security & Backup (3 hrs)

• User roles and permissions
• Backup and recovery methods

Teaching Methodology

• Lectures & demonstrations
• Hands-on lab sessions with MS Access
• Group assignments and projects
• Case studies and problem-solving exercises

Assessment Methods

• Assignments and lab work (20%)
• Group project in MS Access (30%)
• Final exam (50%)

References

• Elmasri, R. & Navathe, S. (2016). Fundamentals of Database Systems.
• Coronel, C. & Morris, S. (2019). Database Systems: Design, Implementation, and Management.
• Microsoft Office Tutorials on Access.

Contact Hours: 45Hrs

 Grade Scale
80–100: A
75–79: B+
70–74: B-
65–69: C+
60–64: C-
55–59: D+
50–54: D-
0–49: F