Course Detail
Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|
DATABASES | BME3249650 | Spring Semester | 3+2 | 4 | 8 |
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 | | | | X | |
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 use the techniques, skills, and modern engineering tools necessary for engineering practice | | X | | | |
6 | An ability to function on multidisciplinary teams | | | X | | |
7 | An ability to communicate effectively | | | X | | |
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 | | X | | | |
10 | A knowledge of contemporary issues | X | | | | |
11 | The broad education necessary to understand the impact of engineering solutions in a global, economic, environmental, and societal context | | | | | |
12 | Capability to apply and decide on engineering principals while understanding and rehabilitating the human body | | | | | |
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 | BME3249650 | Spring Semester | 3+2 | 4 | 8 |
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 | | | | X | |
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 use the techniques, skills, and modern engineering tools necessary for engineering practice | | X | | | |
6 | An ability to function on multidisciplinary teams | | | X | | |
7 | An ability to communicate effectively | | | X | | |
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 | | X | | | |
10 | A knowledge of contemporary issues | X | | | | |
11 | The broad education necessary to understand the impact of engineering solutions in a global, economic, environmental, and societal context | | | | | |
12 | Capability to apply and decide on engineering principals while understanding and rehabilitating the human body | | | | | |
Assessment Methods
Contribution Level | Absolute Evaluation |
Rate of Midterm Exam to Success | | 30 |
Rate of Final Exam to Success | | 70 |
Total | | 100 |
Numerical Data
Ekleme Tarihi: 09/10/2023 - 10:40Son Güncelleme Tarihi: 09/10/2023 - 10:41
×- A-Z Programs
- Undergraduate
- Graduate
- Academic Calendar
- Double Major & Minor Programs
- Erasmus
- Prospective Students
- Registration
- Re-Enrolment
- Fees
- Directorate of Registrar’s Office
- FAQ
- Accommodation
- Scholarships
- Lateral and Vertical Transfer
- Summer School
- Preparation
- Transportation