Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
DATABASE MANAGEMENT COM2058 0 + 0 0 5.0

Prerequisites None

Language of Instruction English
Course Level Graduate Degree
Course Type Compulsory
Mode of delivery Lecture, Lab Work
Course Coordinator
Instructors
Assistants
Goals The main goal of this course is to enable students to create database applications. Students would be able to create ER or EER diagrams and map this diagrams to relational schemas. This course enables students to learn and use SQL language. Students obtains information about normalization and transactions.
Course Content The Relational Data Model and Relational Database Constraints, SQL, Relational Algebra, ER Model, EER Model, Functional Dependencies and Normalization for Relational Databases, Transaction Processing,Concurrency Control Techniques, Database Recovery Techniques
Learning Outcomes 1) Makes data modeling of relation structures in discrete mathematics.
2) Solves data modeling in an exisiting system.
3) Uses database management systems as a component in software projects.
4) Develops database applications for desktop and for network platforms.
5) Uses SQL language

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week Introduction Lecture
Brainstorming
Homework
2. Week Databases and Database Users, Database System Concepts and Architecture (Partially), The Relational Data Model and Relational Database Constraints Lecture
Brainstorming
Homework
3. Week Basic Structured Query Language (SQL) Lecture
Brainstorming
Homework
4. Week More SQL: Complex Queries, Triggers, Views, and Schema Modification Lecture
Brainstorming
Homework
5. Week The Relational Algebra Lecture
Brainstorming
Homework
6. Week Data Modeling Using the Entity-Relationship (ER) Model Lecture
Brainstorming
Homework
7. Week The Enhanced Entity-Relationship (EER) Model Lecture
Brainstorming
Homework
8. Week Relational Database Design by ER- and EER-to-Relational Mapping Lecture
Brainstorming
Homework
9. Week Functional Dependencies and Normalization for Relational Databases Lecture
Brainstorming
Homework
10. Week Functional Dependencies and Normalization for Relational Databases Lecture
Brainstorming
Homework
11. Week Introduction to Transaction Processing Concepts and Theory Lecture
Brainstorming
Homework
12. Week Concurrency Control Techniques Lecture
Brainstorming
Homework
13. Week Database Recovery Techniques Lecture
Brainstorming
Homework
14. Week Review of the course Lecture
Brainstorming
Homework

Sources Used in This Course
Recommended Sources
Fundamentals of Database Systems, 6th Edition, Ramez Elmasri, Shamkant B. Navathe

ECTS credits and course workload
Event Quantity Duration (Hour) Total Workload (Hour)
Course Duration (Total weeks*Hours per week) 14 5
Work Hour outside Classroom (Preparation, strengthening) 10 6
Homework 1 10
Midterm Exam 1 2
Time to prepare for Midterm Exam 1 25
Final Exam 1 2
Time to prepare for Final Exam 1 30
1 2
1 2
11 2
Total Workload
Total Workload / 30 (s)
ECTS Credit of the Course
Quick Access Hızlı Erişim Genişlet
Course Information