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

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 6 3 + 2 150 English

Instructor Assistant Coordinator
Samed Jukić, Senior Teaching Assistant Samed Jukic Jasmin Azemović, Assoc. Prof. Dr.
[email protected] [email protected] no email

A database management (DBM) 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 DBM 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 DBM.

COURSE OBJECTIVE
Develop an appreciation of the role of data and databases in information systems.
Understand the database development activities during the System Development Cycle (SDLC)
Be able to create databases and pose complex SQL queries of relational databases.
Develop appreciation of several DBMS’s
Be familiar with a broad range of data management issues including data integrity 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

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

TEACHING/ASSESSMENT
Description
  • Interactive Lectures
  • Practical Sessions
  • Presentation
  • Assignments
  • Case Studies
Description (%)
Method Quantity Percentage (%)
Midterm Exam(s)120
Laboratory110
Lab/Practical Exam(s)135
Final Exam135
+
Total: 100
Learning outcomes
  • An understanding and administering of most common DBMSs.
  • Having ability of retrieving useful data from an database by using complicated queries in the standard SQL database query language.
  • Competence in the issues involved in physical database design as well as database security and performance
  • Understand Database System Concepts and and apply Architecture System analysis
  • Manipulate with 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)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 Examination12121
Preparation for Final Examination12525
Assignment / Homework/ Project13030
Seminar / Presentation 0
Total Workload: 150
ECTS Credit (Total workload/25): 6