INTERNATIONAL BURCH UNIVERSITY
Faculty of Engineering and Natural Sciences
Department of Information Technologies
2014-2015

SYLLABUS
Code Name Level Year Semester
CEN 251 Database Systems Undergraduate 2 Fall
Status Number of ECTS Credits Class Hours Per Week Total Hours Per Semester Language
Compulsory 5 3 + 2 0 English

Instructor Assistant Coordinator
Samed Jukić, Senior Teaching Assistant Samed Jukic Samed Jukić, Senior Teaching Assistant
[email protected] [email protected] no email

COURSE OBJECTIVE
• Database System Concepts and Architecture
• System analysis
• Relational modeling and implementation
• SQL language for data and schema manipulation
• Administration and Security

COURSE CONTENT
Week
Topic
  1. Database System Concepts and Architecture
  2. System analysis
  3. Relational modeling
  4. Database design and implementation
  5. Case study implementation
  6. Case study implementation
  7. Case study implementation
  8. Case study implementation
  9. Mid-term
  10. SQL introduction
  11. DML
  12. DML part II
  13. DDL
  14. Administration
  15. Security

LABORATORY/PRACTICE PLAN
Week
Topic
  1. Database System Concepts and Architecture
  2. System analysis
  3. Relational modeling
  4. Database design and implementation
  5. Case study implementation
  6. Case study implementation
  7. Case study implementation
  8. Case study implementation

  1. Mid-term
  2. SQL introduction
  3. DML
  4. DML part II
  5. DDL
  6. Administration
  7. Security

TEACHING/ASSESSMENT
Description
  • Lectures
  • Practical Sessions
  • Project
  • Case Studies
Description (%)
Method Quantity Percentage (%)
Project120
Midterm Exam(s)120
Final Exam150
+Participation110
Total: 100
Learning outcomes
  • Database System Concepts and Architecture
  • System analysis
  • Relational modeling and implementation
  • SQL language for data and schema manipulation
  • Administration and Security
TEXTBOOK(S)
  • 1. Silberschatz, Korth, Database system concepts, McGrawHill

ECTS (Allocated based on student) WORKLOAD
Activities Quantity Duration (Hour) Total Work Load
Lecture (14 weeks x Lecture hours per week) 0
Laboratory / Practice (14 weeks x Laboratory/Practice hours per week) 0
Midterm Examination (1 week) 0
Final Examination(1 week) 0
Preparation for Midterm Examination 0
Preparation for Final Examination 0
Assignment / Homework/ Project 0
Seminar / Presentation 0
Total Workload: 0
ECTS Credit (Total workload/25): 0