CS306 Database Management
CS306 Database Management
Syllabus | International University of Sarajevo - Last Update on Apr 04, 2026
Syllabus Quick Jump
Search and navigate to any syllabus instantly
Computer Sciences and Engineering
Babatunde Kazeem Oladejo
Course Lecturer
Course Objectives
- Understand the fundamental concepts of databases and their importance in modern applications.
- Explore the database environment and its components.
- Examine various database architectures and their integration with web technologies.
- Learn the principles of the relational model and its application in database design.
- Apply relational algebra and relational calculus to query databases.
- Understand the database system development lifecycle and its phases.
- Develop skills in entity-relationship modeling for database design.
- Explore enhanced entity-relationship modeling techniques.
- Understand the process of normalization and its importance in database design.
- Apply advanced normalization techniques to optimize database structures.
- Learn the methodology for conceptual database design.
- Understand the principles of database security and administration.
- Explore the concepts and challenges of distributed database management systems (DBMSs).
- Examine the integration of web technology with DBMSs.
Learning Outcomes
After successful completion of the course, the student will be able to:
Course Materials
Required Textbook
Database Principles: Fundamentals of Design, Implementation, and Management, 11e, 2014. Carlos Coronel, Steven Morris, ISBN-13 978-1285196145
Additional Literature
T. Connolly and C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 6th ed. Pearson, 2015.Teaching Methods
Class discussions with examples
Active lab sessions for engaged learning and continuous feedback on progress
Lab exercises and practical assignments
Weekly Topics
| Week | Topic | Readings / References |
|---|---|---|
| 1 | Course Introduction; Data and Information | Coronel_Morris Chp 1 |
| 2 | File Systems; Database Systems; Relational Algebra | Coronel_Morris Chps 1, 3 |
| 3 | Database System Development Lifecycle; Planning and Requirements | Connolly_Begg Chps 10, 11 |
| 4 | Data Modelling; Keys 1; Business Rules; Entity-Relationship; NO LAB (BiH holiday) | Connolly_Begg Chp 12; Coronel_Morris Chp 3 |
| 5 | Normalization - 1NF - 3NF; SQL Definition and Manipulation | Connolly_Begg Chp 14; Coronel_Morris Chp 6 |
| 6 | Structured Query Language (SQL 1); IN-TERM QUIZ | Coronel_Morris Chps 7 & 8 |
| 7 | SQL 2, Boolean Logical Operators; | Coronel_Morris Chps 7 & 8 |
| 8 | MID-TERM EXAM | N/A |
| 9 | Joins 1, SQL Aggregates; Reports | Coronel_Morris Chps 7 & 8 |
| 10 | Joins 2; Subqueries; Functions, PL/SQL; NO LAB (BiH holiday) | Coronel_Morris Chps 7 & 8; Connolly_Begg Chp 8 |
| 11 | Advanced ERD; GRADED LAB | Connolly_Begg Chp 15 |
| 12 | Keys 2; Advanced Normalization; PROJECT DEFENCE | Connolly_Begg Chps 13 and 15 |
| 13 | Security and Administration; PROJECT DEFENCE | Connolly_Begg Chp 20 |
| 14 | Distributed DBMSs and Web Technology; NO LAB (BiH holiday) | Connolly_Begg Chps 24, 29 |
| 15 | Final Review | N/A |
Course Schedule (All Sections)
| Section | Type | Day 1 | Venue 1 | Day 2 | Venue 2 |
|---|---|---|---|---|---|
| CS306.1 | Course | Tuesday 12:00 - 14:50 | A F1.24 - Amphitheater I | - | - |
| CS306.1 | Tutorial | Thursday 12:00 - 13:50 | B F1.25 Computer Lab | - | - |
| CS306.2 | Tutorial | Thursday 14:00 - 15:50 | A F1.11 | - | - |
| CS306.3 | Tutorial | Friday 16:00 - 17:50 | A F1.4 - Class/Laboratory | - | - |
Office Hours & Room
| Day | Time | Office | Notes |
|---|---|---|---|
| Wednesday | 14:00 - 17:00 | A F1.16 | |
| Thursday | 11:00 - 13:00 | A F1.16 |
Assessment Methods and Criteria
Assessment Components
Final Exam
AI: Not AllowedAlignment with Learning Outcomes : 1 2 3 4
Midterm exam
AI: Not AllowedAlignment with Learning Outcomes : 1 2 3
Quizzes
AI: Not AllowedAlignment with Learning Outcomes : 1 2 3
Project
AI: Consult InstructorAlignment with Learning Outcomes : 1 2 3 4
Graded Labs
AI: Not AllowedAlignment with Learning Outcomes : 1 2 3 4
IUS Grading System
| Grading Scale | IUS Grading System | IUS Coeff. | Letter (B&H) | Numerical (B&H) |
|---|---|---|---|---|
| 0 - 44 | F | 0 | F | 5 |
| 45 - 54 | E | 1 | ||
| 55 - 64 | C | 2 | E | 6 |
| 65 - 69 | C+ | 2.3 | D | 7 |
| 70 -74 | B- | 2.7 | ||
| 75 - 79 | B | 3 | C | 8 |
| 80 - 84 | B+ | 3.3 | ||
| 85 - 94 | A- | 3.7 | B | 9 |
| 95 - 100 | A | 4 | A | 10 |
Late Work Policy
Information about late submission policies will be shared during class and posted in this section. Please check back for official guidelines.
ECTS Credit Calculation
📚 Student Workload
This 6 ECTS credit course corresponds to 150 hours of total student workload, distributed as follows:
Lecture Hours
45 hours ⏳ (15 week × 3 h)
Quizzes
14 hours ⏳ (2 week × 7 h)
Projects
30 hours ⏳ (2 week × 15 h)
Home Study
15 hours ⏳ (15 week × 1 h)
Midterm Exam Study
13 hours ⏳ (1 week × 13 h)
Final Exam Study
15 hours ⏳ (1 week × 15 h)
Labs
18 hours ⏳ (6 week × 3 h)
150 Total Workload Hours
6 ECTS Credits
Course Policies
Academic Integrity
All work submitted must be your own. Plagiarism, cheating, or any form of academic dishonesty will result in disciplinary action according to university policies. When in doubt about citation practices, consult the instructor.
Attendance Policy
Students are expected to adhere to the attendance requirements as outlined in the International University of Sarajevo Study Rules and Regulations. Excessive absences, whether excused or unexcused, may impact academic performance and eligibility for assessment. Mandatory sessions (e.g., labs, workshops) require attendance unless formally exempted. For detailed policies on absences, documentation, and penalties, please refer to the official university regulations.
Technology & AI Policy
Laptops/tablets may be used for note-taking only during lectures. Phones should be silenced and put away during all class sessions. Audio/video recording requires prior permission from the instructor.
Artificial Intelligence (AI) Usage: The use of AI tools (e.g., ChatGPT, Copilot, Gemini) varies by assessment component. Please refer to the AI usage indicator next to each assessment item in the Assessment Methods and Criteria section above. Submitting AI-generated content as your own work, where AI is not explicitly allowed, constitutes an academic integrity violation.
Communication Policy
All course-related communication should occur through official university channels (institutional email or SIS). Emails should include [CS306] in the subject line.
Academic Quality Assurance Policy
Course Academic Quality Assurance is achieved through Semester Student Survey. At the end of each academic year, the institution of higher education is obliged to evaluate work of the academic staff, or the success of realization of the curricula.
Learning Tips
Be prepared to contribute thoughtfully during class discussions, labs, or collaborative work. Active participation deepens understanding and encourages critical thinking.
Complete assigned readings or prep materials before class. Take notes, highlight key ideas, and jot down questions. Aim to grasp core concepts and their applications—not just facts.
Use course frameworks or methodologies to analyze problems, case studies, or projects. Begin early to allow time for reflection and refinement. Seek feedback to improve your work.
Don’t hesitate to reach out when something is unclear. Use office hours, discussion boards, or peer networks to clarify concepts and stay on track.
Syllabus Last Updated on Apr 04, 2026 | International University of Sarajevo
Print Syllabus
Referencing Curricula Print this page
| Course Code | Course Title | Weekly Hours* | ECTS | Weekly Class Schedule | ||||||
| T | P | |||||||||
| CS306 | Database Management | 3 | 2 | 6 | ||||||
| Prerequisite | CS105 | It is a prerequisite to | CS308, CS421 | |||||||
| Lecturer | Babatunde Kazeem Oladejo | Office Hours / Room / Phone | Wednesday: 14:00-17:00 Thursday: 11:00-13:00 |
|||||||
| koladejo@ius.edu.ba | ||||||||||
| Assistant | Nesibe Merve Demir | Assistant E-mail | ndemir@ius.edu.ba | |||||||
| Course Objectives | Understand the fundamental concepts of databases and their importance in modern applications. Explore the database environment and its components. Examine various database architectures and their integration with web technologies. Learn the principles of the relational model and its application in database design. Apply relational algebra and relational calculus to query databases. Understand the database system development lifecycle and its phases. Develop skills in entity-relationship modeling for database design. Explore enhanced entity-relationship modeling techniques. Understand the process of normalization and its importance in database design. Apply advanced normalization techniques to optimize database structures. Learn the methodology for conceptual database design. Understand the principles of database security and administration. Explore the concepts and challenges of distributed database management systems (DBMSs). Examine the integration of web technology with DBMSs. |
|||||||||
| Textbook | Database Principles: Fundamentals of Design, Implementation, and Management, 11e, 2014. Carlos Coronel, Steven Morris, ISBN-13 978-1285196145 | |||||||||
| Additional Literature |
|
|||||||||
| Learning Outcomes | After successful completion of the course, the student will be able to: | |||||||||
|
||||||||||
| Teaching Methods | Class discussions with examples. Active lab sessions for engaged learning and continuous feedback on progress. Lab exercises and practical assignments. | |||||||||
| Teaching Method Delivery | Face-to-face | Teaching Method Delivery Notes | ||||||||
| WEEK | TOPIC | REFERENCE | ||||||||
| Week 1 | Course Introduction; Data and Information | Coronel_Morris Chp 1 | ||||||||
| Week 2 | File Systems; Database Systems; Relational Algebra | Coronel_Morris Chps 1, 3 | ||||||||
| Week 3 | Database System Development Lifecycle; Planning and Requirements | Connolly_Begg Chps 10, 11 | ||||||||
| Week 4 | Data Modelling; Keys 1; Business Rules; Entity-Relationship; NO LAB (BiH holiday) | Connolly_Begg Chp 12; Coronel_Morris Chp 3 | ||||||||
| Week 5 | Normalization - 1NF - 3NF; SQL Definition and Manipulation | Connolly_Begg Chp 14; Coronel_Morris Chp 6 | ||||||||
| Week 6 | Structured Query Language (SQL 1); IN-TERM QUIZ | Coronel_Morris Chps 7 & 8 | ||||||||
| Week 7 | SQL 2, Boolean Logical Operators; | Coronel_Morris Chps 7 & 8 | ||||||||
| Week 8 | MID-TERM EXAM | N/A | ||||||||
| Week 9 | Joins 1, SQL Aggregates; Reports | Coronel_Morris Chps 7 & 8 | ||||||||
| Week 10 | Joins 2; Subqueries; Functions, PL/SQL; NO LAB (BiH holiday) | Coronel_Morris Chps 7 & 8; Connolly_Begg Chp 8 | ||||||||
| Week 11 | Advanced ERD; GRADED LAB | Connolly_Begg Chp 15 | ||||||||
| Week 12 | Keys 2; Advanced Normalization; PROJECT DEFENCE | Connolly_Begg Chps 13 and 15 | ||||||||
| Week 13 | Security and Administration; PROJECT DEFENCE | Connolly_Begg Chp 20 | ||||||||
| Week 14 | Distributed DBMSs and Web Technology; NO LAB (BiH holiday) | Connolly_Begg Chps 24, 29 | ||||||||
| Week 15 | Final Review | N/A | ||||||||
| Assessment Methods and Criteria | Evaluation Tool | Quantity | Weight | Alignment with LOs | AI Usage |
| Final Exam | 1 | 40 | 1,2,3,4 | Not Allowed | |
| Semester Evaluation Components | |||||
| Midterm exam | 1 | 30 | 1,2,3 | Not Allowed | |
| Quizzes | 1 | 10 | 1,2,3 | Not Allowed | |
| Project | 1 | 10 | 1,2,3,4 | Consult Instructor | |
| Graded Labs | 2 | 10 | 1,2,3,4 | Not Allowed | |
| *** ECTS Credit Calculation *** | |||||
| Activity | Hours | Weeks | Student Workload Hours | Activity | Hours | Weeks | Student Workload Hours | |||
| Lecture Hours | 3 | 15 | 45 | Quizzes | 7 | 2 | 14 | |||
| Projects | 15 | 2 | 30 | Home Study | 1 | 15 | 15 | |||
| Midterm Exam Study | 13 | 1 | 13 | Final Exam Study | 15 | 1 | 15 | |||
| Labs | 3 | 6 | 18 | |||||||
| Total Workload Hours = | 150 | |||||||||
| *T= Teaching, P= Practice | ECTS Credit = | 6 | ||||||||
| Course Academic Quality Assurance: Semester Student Survey | Last Update Date: 27/04/2026 | |||||||||