Course Name Code Semester T+U Hours Credit ECTS
Institutional Data and Database Management YBS 501 0 3 + 0 3 6
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level yuksek_lisans
Course Type Optional
Course Coordinator Dr.Öğr.Üyesi ÇAĞLA EDİZ
Course Lecturers
Course Assistants
Course Category Field Proper Education
Course Objective Introducing fundamentals and functions of database management, training students for the skills of implementing the necessary practices.
Course Content
# Course Learning Outcomes Teaching Methods Assessment Methods
1 Is informed of structure and importance of databases Lecture, Discussion, Drilland Practice, Testing, Homework,
2 Can interpret database design in the scope of principles of database design Lecture, Discussion, Drilland Practice, Testing, Homework,
3 Can design relevance diagrams Lecture, Discussion, Drilland Practice, Testing, Homework,
4 Can make design and practices with using system analysis and database management system Lecture, Discussion, Drilland Practice, Testing, Homework,
5 Can use basic functions in a database managenet system Lecture, Discussion, Drilland Practice, Testing, Homework,
6 Can fix and produce solutions to problems faced in business life about database usage Lecture, Discussion, Drilland Practice, Testing, Homework,
Week Course Topics Preliminary Preparation
1 Database: Definition and Concepts, Importance for enterprises and policymakers
2 Database project stages
3 Database Design Stage: ER Modelling
4 ER Modelling and Practices
5 Advanced Issues in ER Modelling and practices
6 Logical database design stage and relationnally model / Normality of design
7 Examples of design normalization
8 MID TERM EXAM
9 Physical design of database and issues of performance/ SQL and Basic SQL Commands
10 Advanced SQL Commands
11 Designing a hospital database system using MS Access
12 Managerial Problems about database management
13 Examples of accounting, finance, production, stock control, HRM and marketing database practices in enterprises
14 Overall Evaluation
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
1 2 3 4 5
1 Be aware of the different types of ınformation technologies and systems using in business, have enough knowledge to design a suitable system
2 Analyse the needs for an information systems and have control over the processes at the analysis, design and implementation stages of the database that belongs to the system
3 Convey information about current trends and their own studies both verbally and visually ways.
4 Be able to follow current developments in modern business techniques and technologies, especially information technologies
5 Understand the interaction between his departmant and other relational departmants, if necessary make a team, take responsibility and do the works with team.
6 Know the information technologies and systems using in different types of business, if necessary take the system responsibility.
7 Be aware of the social transformation especially in their own field and social, legal and moral responsbilities belongs to other work field.
8 Develop their knowledge to the level of expertise which they learn them in license level.
9 Carry out a work which requires an expertness in their field.
10 Construct and perform an academic work.
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 30
1. Kısa Sınav 25
1. Performans Görevi (Laboratuvar) 20
2. Kısa Sınav 25
Total 100
1. Yıl İçinin Başarıya 50
1. Final 50
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 20 20
Quiz 2 6 12
Performance Task (Laboratory) 1 15 15
Final examination 1 15 15
Total Workload 142
Total Workload / 25 (Hours) 5.68
dersAKTSKredisi 6