Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
DATABASE CONCEPTS AND APPLICATIONS 805101725291 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 Bülent TUĞRUL
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) 51/5000 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

Project Based Learning 		Presentation (Including Preparation Time)
2. Week Relational Data Model Lecture

Project Based Learning 		Presentation (Including Preparation Time)
3. Week Basic SQl Lecture

Project Based Learning 		Presentation (Including Preparation Time)
4. Week Advanced SQL Lecture

Project Based Learning 		Presentation (Including Preparation Time)
5. Week Relational Algebra Lecture

Project Based Learning 		Presentation (Including Preparation Time)
6. Week ER Model Lecture

Project Based Learning 		Presentation (Including Preparation Time)
7. Week Advanced Er Modl Lecture

Project Based Learning 		Presentation (Including Preparation Time)
8. Week Er Mapping Lecture

Project Based Learning 		Presentation (Including Preparation Time)
9. Week Normalization Lecture

Project Based Learning 		Presentation (Including Preparation Time)
10. Week Functionel Dependency Lecture

Project Based Learning 		Presentation (Including Preparation Time)
11. Week Transacntions Lecture
Brainstorming
Project Based Learning 		Presentation (Including Preparation Time)
12. Week Concurrency Control Techniques Lecture

Project Based Learning 		Presentation (Including Preparation Time)
13. Week Database Recovery Techniques Lecture

Project Based Learning 		Presentation (Including Preparation Time)
14. Week Review Lecture

Project Based Learning 		Presentation (Including Preparation Time)
15. Week Project Demonstration

Project Based Learning 		Presentation (Including Preparation Time)
16. Week Final Exam
Brainstorming
Brain Based Learning 		Presentation (Including Preparation Time)

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 LevelDK1DK2DK3
PY15555
PY15555
PY25555
PY25555
PY35555
PY35555
PY45555
PY45555
PY55555
PY55555

*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)
Work Hour outside Classroom (Preparation, strengthening) 14 2
Homework 3 30
Project (Including Preparation and presentation Time) 1 50
Final Exam 1 60
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