LOGISTIC MANAGEMENT | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
SEN2104 | Database Management Systems | Fall | 3 | 2 | 4 | 7 |
This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester. |
Language of instruction: | English |
Type of course: | Non-Departmental Elective |
Course Level: | Bachelor’s Degree (First Cycle) |
Mode of Delivery: | Hybrid |
Course Coordinator : | Dr. Öğr. Üyesi TAMER UÇAR |
Course Lecturer(s): |
Dr. Öğr. Üyesi TAMER UÇAR RA SEVGİ CANPOLAT Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN RA MERVE ARITÜRK Prof. Dr. ADEM KARAHOCA |
Recommended Optional Program Components: | None |
Course Objectives: | The students will have the ability to analyze and design databases using the entity-relationship model. They will have the ability to define database querying techniques such as relational algebra and SQL. Besides these topics, the students will have the ability to identify relational database design approaches, indexing, query processing, and query optimization. Students will be able to define basic data analysis and data mining concepts. |
The students who have succeeded in this course; 1. Define the entity-relationship model. 2. Define the relational data model. 3. Define the relational algebra query language. 4. Define the SQL language. 5. Identify the relational database design approach. 6. Identify indexing, query processing and query optimization. 7. Define basic data analysis and data mining concepts. |
The course content is composed of entity-relationship model, relational data model, relational algebra, SQL, relational database design, indexing, query processing, query optimization, data analysis and data mining related topics. |
Week | Subject | Related Preparation |
1) | Introduction to Database Management Systems | |
2) | Entity-Relationship Model | |
3) | Introduction to Relational Data Model | |
4) | Relational Algebra | |
5) | Relational Algebra | |
6) | Applying Relational Algebra Principles to Database Design and Practice | |
7) | Structured Query Language (SQL) | |
8) | Structured Query Language (SQL) | |
9) | Relational Database Design | |
10) | Relational Database Design | |
11) | Relational Database Design | |
12) | Indexing and Query Processing | |
13) | Query Processing and Query Optimization | |
14) | Data Analysis and Data Mining |
Course Notes / Textbooks: | Database System Concepts (6th Edition), Abraham Silberschatz, Henry Korth and S. Sudarshan, ISBN-13: 978-0073523323 Fundamentals of Database Systems (7th Edition), Ramez Elmasri and Shamkant Navathe, ISBN-13: 978-0133970777 |
References: | - |
Semester Requirements | Number of Activities | Level of Contribution |
Quizzes | 3 | % 20 |
Project | 1 | % 15 |
Midterms | 1 | % 25 |
Final | 1 | % 40 |
Total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 45 | |
PERCENTAGE OF FINAL WORK | % 55 | |
Total | % 100 |
Activities | Number of Activities | Duration (Hours) | Workload |
Total Workload |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution | |
1) | To correctly identify the problems and to be able to ask the correct questions | |
2) | To have the ability for problem solving and to utilize analytical approach in dealing with the problems | |
3) | To be able to identify business processes and use them to increase the productivity in logistics system. | |
4) | To be fully prepared for a graduate study | 2 |
5) | Awareness of the new advancements in Information and Communications Technologies (ICT) and to be able to use them in logistics management effectively. internet and the electronic world | |
6) | To understand the components of logistics as well as the importance of the coordination among these components. | |
7) | To know the necessary ingredients for improving the productivity in business life | |
8) | To think innovatively and creatively in complex situations | 4 |
9) | To act and think both regionally and internationally | |
10) | To understand the demands and particular questions of globalization | |
11) | Aware of the two way interaction between globalization and logistics; as well as to use this interaction for increasing the productivity. | |
12) | To be able to use at least one foreign language both for communication and academic purposes | 2 |
13) | To acquire leadership qualities but also to know how to be a team member | |
14) | To understand the importance of business ethics and to apply business ethics as a principal guide in both business and academic environment |