INTERNATIONAL BURCH UNIVERSITY
Faculty of Engineering and Natural Sciences
Department of Information Technologies
2016-2017

SYLLABUS
Code Name Level Year Semester
CEN 114 Database Design and Implementation Undergraduate 1 Spring
Status Number of ECTS Credits Class Hours Per Week Total Hours Per Semester Language
Compulsory 5 2 + 2 149

Instructor Assistant Coordinator
Amar Sarić, Assist. Prof. Dr. Amar Sarić, Assist. Prof. Dr.
[email protected] no email

A database management system (DBMS) is a computer application program designed for the efficient and effective storage, access and update of large volumes of information. This course will look at such systems from two perspectives: * A user-centered perspective focusing on how a DBMS is used to support a data intensive application. This perspective includes a look at the common data models, query languages and design techniques. * A system implementation perspective focusing on the policies, algorithms and data structures used to design and implement a database.

COURSE OBJECTIVE
After completing this course, students should be able to:

* Develop an appreciation of the role of data and databases in information systems
* Design and create databases
* Understand and apply normalization in databases
* Write complex SQL queries in relational databases
* Explain a range of data management issues including data integrity and security

COURSE CONTENT
Week
Topic
  1. Database System Concepts and Architecture
  2. Database design and implementation / Intro to SQL
  3. Relational modeling
  4. SQL basics
  5. Normal forms
  6. Normal forms
  7. Midterm
  8. Retrieving and Filtering Data
  9. Grouping and Summarizing Data
  10. Querying Multiple Tables
  11. Working with Subqueries
  12. Statements for Modifying Data
  13. Views & stored procedures
  14. Database security
  15. Final exam review

LABORATORY/PRACTICE PLAN
Week
Topic

    TEACHING/ASSESSMENT
    Description
    • Practical Sessions
    • Excersises
    • Presentation
    • Assignments
    Description (%)
    Method Quantity Percentage (%)
    Homework135
    Midterm Exam(s)120
    Lab/Practical Exam(s)110
    Final Exam135
    Total: 100
    Learning outcomes
      TEXTBOOK(S)
      • Pratt and Adamski, Concepts of Database Management 7th Edition, Course Technology Press

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