MEDICINE
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Course Introduction and Application Information

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.

Basic information

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.

Learning Outcomes

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.

Course Content

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.

Weekly Detailed Course Contents

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

Sources

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: -

Evaluation System

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

ECTS / Workload Table

Activities Number of Activities Duration (Hours) Workload
Total Workload

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Integrates the knowledge, skills and attitudes acquired from basic and clinical medical sciences, behavioral sciences and social sciences, and uses them in health service delivery.
2) In patient management, shows a biopsychosocial approach that takes into account the socio-demographic and sociocultural background of the individual, regardless of language, religion, race and gender.
3) In the provision of health services, prioritizes the protection and development of the health of individuals and society.
4) Taking into account the individual, societal, social and environmental factors affecting health; does the necessary work to maintain and improve the state of health.
5) By recognizing the characteristics, needs and expectations of the target audience, provides health education to healthy/sick individuals and their relatives and other healthcare professionals.
6) Shows a safe, rational and effective approach in health service delivery, prevention, diagnosis, treatment, follow-up and rehabilitation processes.
7) Performs invasive and/or non-invasive procedures in diagnosis, treatment, follow-up and rehabilitation processes in a safe and effective way for the patient.
8) Provides health services by considering patient and employee health and safety.
9) In the provision of health services, takes into account the changes in the physical and socioeconomic environment on a regional and global scale, as well as the changes in the individual characteristics and behaviors of the people who apply to it.
10) Takes good medical practice into account while carrying out his/her profession.
11) Fulfills its duties and obligations within the framework of ethical principles, rights and legal responsibilities required by its profession.
12) Demonstrates decisive behavior in providing high-quality health care, taking into account the integrity of the patient.
13) Evaluates his/her performance in his/her professional practice by considering his/her emotions and cognitive characteristics.
14) Advocates improving the provision of health services by considering the concepts of social reliability and social responsibility for the protection and development of public health.
15) Can plan and carry out service delivery, training and consultancy processes related to individual and community health in cooperation with all components for the protection and development of health.
16) Evaluates the impact of health policies and practices on individual and community health indicators and advocates increasing the quality of health services.
17) The physician attaches importance to the protection of his/her own physical, mental and social health, and does what is necessary for this
18) Shows exemplary behavior and leads the healthcare team during service delivery.
19) Uses resources cost-effectively, for the benefit of society and in accordance with the legislation, in the planning, implementation and evaluation processes of health services in the health institution he/she is the manager of.
20) Establishes positive communication within the health team it serves and assumes different team roles when necessary.
21) Is aware of the duties and responsibilities of the health workers in the health team and acts accordingly.
22) In the professional practices, works in harmony and effectively with the colleagues and other professional groups.
23) Communicates effectively with patients, their relatives, healthcare professionals, other professional groups, institutions and organizations.
24) Communicates effectively with individuals and groups that require a special approach and have different socio-cultural characteristics.
25) In the diagnosis, treatment, follow-up and rehabilitation processes, shows a patient-centered approach that associates the patient with the decision-making mechanisms.
26) Plans and implements scientific research, when necessary, for the population it serves, and uses the results and/or the results of other research for the benefit of the society.
27) Reaches and critically evaluates current literature knowledge about his/her profession.
28) Applies the principles of evidence-based medicine in clinical decision making.
29) Uses information technologies to increase the effectiveness of its work on health care, research and education.
30) Effectively manages individual work processes and career development.
31) Demonstrates skills in acquiring and evaluating new knowledge, integrating it with existing knowledge, applying it to professional situations and adapting to changing conditions throughout professional life.
32) Selects the right learning resources to improve the quality of the health service it offers, organizes its own learning process