Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
DATABASE SYSTEMS AND MANAGEMENT 805100715131 3 + 0 3.0 8.0

Prerequisites None

Language of Instruction Turkish
Course Level Graduate Degree
Course Type Elective
Mode of delivery
Course Coordinator
Instructors Recep ERYİĞİT
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 basic concepts of database and relational database design. Normalization. Sample Database Design and SQL Data Types-Sample Database Design. Download Data Integrity and Constraint. SQL-Structured Query. Query Processing and Query by grouping. Query on Multiple Tables and Old Orders. Arithmetic Operators and Functions Stock
Learning Outcomes 1) Analyze the data model in an existing system.
2) Uses database management systems as a software project component.
3) Effectively uses the SQL programming language.

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week Introduction Lecture
Brainstorming
Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
2. Week Relational Data Model Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
3. Week Basic SQL Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
4. Week Advanced SQL Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
5. Week Relational Algebra Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
6. Week ER Model Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
7. Week Advanced Er Modl Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
8. Week Er Mapping Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
9. Week Normalization Lecture
Brainstorming
Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
10. Week Functionel Dependency Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
11. Week Transacntions Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
12. Week Concurrency Control Techniques Lecture

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
13. Week Database Recovery Techniques Discussion

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
14. Week Subject Repetition Discussion

Project Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.)

Sources Used in This Course
Recommended Sources
Elmasri, R. & Navathe, S. B. (2015). Fundamentals of Database Systems, 7th Edition. Pearson Education: USA
Ramakrishnan, R. & Gehrke, J. (2003). Database Management Systems, 3rd Edition, McGraw-Hill, 2003.

Relations with Education Attainment Program Course Competencies
Program RequirementsContribution LevelDK1DK2DK3
PY115400
PY165040
PY255004

*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 3
Work Hour outside Classroom (Preparation, strengthening) 14 3
Homework 14 3
Midterm Exam 1 1
Time to prepare for Midterm Exam 1 20
Final Exam 1 1
Time to prepare for Final Exam 1 50
14 3
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