Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
DATABASE MANAGEMENT AETY302 6. Semester 0 + 0 0 6.0

Prerequisites None

Language of Instruction Turkish
Course Level Bachelor's Degree
Course Type Compulsory
Mode of delivery
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

Relations with Education Attainment Program Course Competencies
Program RequirementsContribution LevelDK1DK2DK3DK4DK5
PY1555555
PY2555555
PY3555555
PY4555555
PY5555555

*DK = Course's Contrubution.
0 1 2 3 4 5
Level of contribution None Very Low Low Fair High Very High
.

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 4
Homework 4 2
Activity (Web Search, Library Work, Trip, Observation, Interview etc.) 10 2
Quiz 1 2
Time to prepare for Quiz 1 10
Midterm Exam 1 2
Time to prepare for Midterm Exam 1 20
Final Exam 1 2
Time to prepare for Final Exam 1 30
Total Workload
Total Workload / 30 (s)
ECTS Credit of the Course
Quick Access Hızlı Erişim Genişlet
Course Information
  • Course Information
  • Weekly Topics (Content)
  • Sources Used in This Course
  • Relations with Education Attainment Program Course Competencies
  • ECTS credits and course workload