| MOLECULAR BIOLOGY AND GENETICS | |||||
| 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: | Face to face |
| Course Coordinator : | Assist. Prof. TAMER UÇAR |
| Course Lecturer(s): |
Assist. Prof. TAMER UÇAR RA SEVGİ CANPOLAT Assist. Prof. Ö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. Teaching Methods and Techniques Used in the Course: Lecture, reading, implementation, individual study, problem solving |
|
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) | Structured Query Language (SQL) | |
| 7) | Structured Query Language (SQL) | |
| 8) | Midterm Exam | |
| 9) | Relational Database Design | |
| 10) | Relational Database Design | |
| 11) | Relational Database Design | |
| 12) | Indexing and Query Processing | |
| 13) | Query Processing and Query Optimization | |
| 14) | Introduction to Data Analysis and Data Mining Concepts |
| Course Notes / Textbooks: | A. Silberschatz, H. F. Korth, S. Sudarshan, “Database System Concepts”, 6th edition, McGraw Hill R. Elmasri, S. Navathe, “Fundamentals of Database Systems”, 7th edition, Pearson |
| References: | - |
| Semester Requirements | Number of Activities | Level of Contribution |
| Quizzes | 3 | % 25 |
| Midterms | 1 | % 35 |
| Final | 1 | % 40 |
| Total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 60 | |
| PERCENTAGE OF FINAL WORK | % 40 | |
| 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) | Acquire an ability to compile and analyze biological information, clearly present and discuss the conclusions, the inferred knowledge and the arguments behind them both in oral and written format. | 3 |
| 2) | Utilize the wealth of information stored in computer databases to answer basic biological questions and solve problems such as diagnosis and treatment of diseases. | 4 |
| 3) | Develop critical, creative and analytical thinking skills. | 5 |
| 4) | Develop effective communication skills and have competence in scientific speaking, reading and writing abilities in English and Turkish. | 3 |
| 5) | Gain knowledge of different techniques and methods used in genetics and acquire the relevant laboratory skills. | 4 |
| 6) | Detect biological problems, learn to make hypothesis and solve the hypothesis by using variety of experimental and observational methods. | 4 |
| 7) | Gain knowledge of methods for collecting quantitative and qualitative data and obtain the related skills. | 3 |
| 8) | Conduct research through paying attention to ethics, human values and rights. Pay special attention to confidentiality of information while working with human subjects. | 5 |
| 9) | Obtain basic concepts used in theory and practices of molecular biology and genetics and establish associations between them. | 4 |
| 10) | Search and use literature to improve himself/herself and follow recent developments in science and technology. | 5 |
| 11) | Be aware of the national and international problems in the field and search for solutions. | 4 |