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 Can use next generation computing-based business analytics techniques and apply these methods to business problems
2 Offers developed solutions with information technologies such as Business Intelligence tools
3 Makes the routine decisions necessary for the execution of operational works with the help of information technologies.
4 Makes medium and long term strategic decisions with the help of information systems.
5 Can transform business processes into electronic form with the help of information systems
6 Contributes to the sustainability of processes with electronic transformation.
7 Makes a basic literature search on the field.
8 Knows about research methodology and applies this knowledge to informatics issues.
9 Leading the working group by communicating within the team in teamwork.
10 Effectively uses group communication technologies in IT projects management.
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