Understanding the concepts underlying the design and implementation of database systems. Establishing a solid background in data management, with a focus on relational database management systems and practicing actual database design, implementation, and query formulation through a term project.
Course Content
This course contains; Database Management Systems,Relational Data Model ,Entity/Relationship Model,Relational Algebra,Structured Query Language, SQL ,Database Application Development,Relational Database Design,File Organization ,Tree-Structured Indexing ,Hash-Based Indexing,Query Processing,Query Optimization,Concurrency,Overview of Transaction Management.
Dersin Öğrenme Kazanımları
Teaching Methods
Assessment Methods
At the end of this course the student would have a solid background on database management systems and their underlying data structures and algorithms
12, 16, 2, 6, 9
A, E, F
At the end of this course the student would be able to design databases using relational database methods and apply this knowledge to the real life applications.
12, 14, 2, 6, 9
A, E, F
At the end of this course the student would learn the data structures underlying the database management systems and the access methods as well as the query processing that use them.
12, 14, 16, 9
A, E
During this course students are going to learn the SQL language for interacting with the database management systems.
12, 14, 16, 9
A, E, F
Teaching Methods:
12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 2: Project Based Learning Model, 6: Experiential Learning, 9: Lecture Method
Assessment Methods:
A: Traditional Written Exam, E: Homework, F: Project Task
Course Outline
Order
Subjects
Preliminary Work
0
Database Management Systems
1
Relational Data Model
2
Entity/Relationship Model
3
Relational Algebra
4
Structured Query Language, SQL
5
Database Application Development
6
Relational Database Design
7
File Organization
9
Tree-Structured Indexing
9
Hash-Based Indexing
10
Query Processing
11
Query Optimization
12
Concurrency
13
Overview of Transaction Management
Resources
Database Management Systems, 3rd Edition, R. Ramakrishnan, J. Gehrke
McGraw- Hill, 2003
The notes and the presentations will be delivered during the lectures.
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications
No
Program Qualification
Contribution Level
1
2
3
4
5
1
An ability to apply knowledge of mathematics, science, and engineering
2
An ability to identify, formulate, and solve engineering problems
X
3
An ability to design a system, component, or process to meet desired needs within realistic constraints such as economic, environmental, social, political, ethical, health and safety, manufacturability, and sustainability
X
4
An ability to use the techniques, skills, and modern engineering tools necessary for engineering practice
X
5
An ability to design and conduct experiments, as well as to analyze and interpret data
X
6
An ability to function on multidisciplinary teams
7
An ability to communicate effectively
8
A recognition of the need for, and an ability to engage in life-long learning
X
9
An understanding of professional and ethical responsibility
10
A knowledge of contemporary issues
11
The broad education necessary to understand the impact of engineering solutions in a global, economic, environmental, and societal context
Assessment Methods
Contribution Level
Absolute Evaluation
Rate of Midterm Exam to Success
30
Rate of Final Exam to Success
70
Total
100
ECTS / Workload Table
Activities
Number of
Duration(Hour)
Total Workload(Hour)
Course Hours
0
0
0
Guided Problem Solving
0
0
0
Resolution of Homework Problems and Submission as a Report
0
0
0
Term Project
0
0
0
Presentation of Project / Seminar
0
0
0
Quiz
0
0
0
Midterm Exam
0
0
0
General Exam
0
0
0
Performance Task, Maintenance Plan
0
0
0
Total Workload(Hour)
0
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(0/30)
0
ECTS of the course: 30 hours of work is counted as 1 ECTS credit.
Detail Informations of the Course
Course Description
Course
Code
Semester
T+P (Hour)
Credit
ECTS
DATABASES
EEE3249650
Spring Semester
3+2
4
8
Course Program
Salı 18:30-19:15
Salı 19:30-20:15
Salı 20:30-21:15
Çarşamba 09:00-09:45
Çarşamba 10:00-10:45
Prerequisites Courses
Recommended Elective Courses
Language of Course
English
Course Level
First Cycle (Bachelor's Degree)
Course Type
Elective
Course Coordinator
Prof.Dr. Reda ALHAJJ
Name of Lecturer(s)
Prof.Dr. Reda ALHAJJ
Assistant(s)
Aim
Understanding the concepts underlying the design and implementation of database systems. Establishing a solid background in data management, with a focus on relational database management systems and practicing actual database design, implementation, and query formulation through a term project.
Course Content
This course contains; Database Management Systems,Relational Data Model ,Entity/Relationship Model,Relational Algebra,Structured Query Language, SQL ,Database Application Development,Relational Database Design,File Organization ,Tree-Structured Indexing ,Hash-Based Indexing,Query Processing,Query Optimization,Concurrency,Overview of Transaction Management.
Dersin Öğrenme Kazanımları
Teaching Methods
Assessment Methods
At the end of this course the student would have a solid background on database management systems and their underlying data structures and algorithms
12, 16, 2, 6, 9
A, E, F
At the end of this course the student would be able to design databases using relational database methods and apply this knowledge to the real life applications.
12, 14, 2, 6, 9
A, E, F
At the end of this course the student would learn the data structures underlying the database management systems and the access methods as well as the query processing that use them.
12, 14, 16, 9
A, E
During this course students are going to learn the SQL language for interacting with the database management systems.
12, 14, 16, 9
A, E, F
Teaching Methods:
12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 2: Project Based Learning Model, 6: Experiential Learning, 9: Lecture Method
Assessment Methods:
A: Traditional Written Exam, E: Homework, F: Project Task
Course Outline
Order
Subjects
Preliminary Work
0
Database Management Systems
1
Relational Data Model
2
Entity/Relationship Model
3
Relational Algebra
4
Structured Query Language, SQL
5
Database Application Development
6
Relational Database Design
7
File Organization
9
Tree-Structured Indexing
9
Hash-Based Indexing
10
Query Processing
11
Query Optimization
12
Concurrency
13
Overview of Transaction Management
Resources
Database Management Systems, 3rd Edition, R. Ramakrishnan, J. Gehrke
McGraw- Hill, 2003
The notes and the presentations will be delivered during the lectures.
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications
No
Program Qualification
Contribution Level
1
2
3
4
5
1
An ability to apply knowledge of mathematics, science, and engineering
2
An ability to identify, formulate, and solve engineering problems
X
3
An ability to design a system, component, or process to meet desired needs within realistic constraints such as economic, environmental, social, political, ethical, health and safety, manufacturability, and sustainability
X
4
An ability to use the techniques, skills, and modern engineering tools necessary for engineering practice
X
5
An ability to design and conduct experiments, as well as to analyze and interpret data
X
6
An ability to function on multidisciplinary teams
7
An ability to communicate effectively
8
A recognition of the need for, and an ability to engage in life-long learning
X
9
An understanding of professional and ethical responsibility
10
A knowledge of contemporary issues
11
The broad education necessary to understand the impact of engineering solutions in a global, economic, environmental, and societal context
