Skip to main content

Course Detail

Course Description

CourseCodeSemesterT+P (Hour)CreditECTS
DATABASES-Spring Semester3+248
Course Program
Prerequisites Courses
Recommended Elective Courses
Language of CourseEnglish
Course LevelFirst Cycle (Bachelor's Degree)
Course TypeElective
Course CoordinatorProf.Dr. Reda ALHAJJ
Name of Lecturer(s)Prof.Dr. Reda ALHAJJ
Assistant(s)
AimUnderstanding 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 ContentThis 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 MethodsAssessment Methods
At the end of this course the student would have a solid background on database management systems and their underlying data structures and algorithms12, 16, 2, 6, 9A, 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, 9A, 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, 9A, E
During this course students are going to learn the SQL language for interacting with the database management systems.12, 14, 16, 9A, 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

OrderSubjectsPreliminary Work
0Database Management Systems
1Relational Data Model
2Entity/Relationship Model
3Relational Algebra
4Structured Query Language, SQL
5Database Application Development
6Relational Database Design
7File Organization
9Tree-Structured Indexing
9Hash-Based Indexing
10Query Processing
11Query Optimization
12Concurrency
13Overview 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
NoProgram QualificationContribution Level
12345
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 LevelAbsolute Evaluation
Rate of Midterm Exam to Success 30
Rate of Final Exam to Success 70
Total 100
ECTS / Workload Table
ActivitiesNumber ofDuration(Hour)Total Workload(Hour)
Course Hours000
Guided Problem Solving000
Resolution of Homework Problems and Submission as a Report000
Term Project000
Presentation of Project / Seminar000
Quiz000
Midterm Exam000
General Exam000
Performance Task, Maintenance Plan000
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

CourseCodeSemesterT+P (Hour)CreditECTS
DATABASES-Spring Semester3+248
Course Program
Prerequisites Courses
Recommended Elective Courses
Language of CourseEnglish
Course LevelFirst Cycle (Bachelor's Degree)
Course TypeElective
Course CoordinatorProf.Dr. Reda ALHAJJ
Name of Lecturer(s)Prof.Dr. Reda ALHAJJ
Assistant(s)
AimUnderstanding 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 ContentThis 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 MethodsAssessment Methods
At the end of this course the student would have a solid background on database management systems and their underlying data structures and algorithms12, 16, 2, 6, 9A, 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, 9A, 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, 9A, E
During this course students are going to learn the SQL language for interacting with the database management systems.12, 14, 16, 9A, 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

OrderSubjectsPreliminary Work
0Database Management Systems
1Relational Data Model
2Entity/Relationship Model
3Relational Algebra
4Structured Query Language, SQL
5Database Application Development
6Relational Database Design
7File Organization
9Tree-Structured Indexing
9Hash-Based Indexing
10Query Processing
11Query Optimization
12Concurrency
13Overview 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
NoProgram QualificationContribution Level
12345
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 LevelAbsolute Evaluation
Rate of Midterm Exam to Success 30
Rate of Final Exam to Success 70
Total 100

Numerical Data

Student Success

Ekleme Tarihi: 09/10/2023 - 10:37Son Güncelleme Tarihi: 09/10/2023 - 10:37