Course Name Code Semester T+U Hours Credit ECTS
Database Management Systems ISL 463 7 2 + 0 2 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Optional
Course Coordinator ERMAN COŞKUN
Course Lecturers
Course Assistants Res. Asst. Serdar Geçer
Course Category
Course Objective Introducing fundamentals and functions of database management, training students for the skills of implementing the necessary practices.
Course Content Database design, entity relationship diagrams, system analysis and database management systems
# 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
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 Gains the required knowledge in production, marketing, management , accounting and finance. X
2 Can work in teams and share information with team members in tasks of production, marketing, management, accounting and finance. X
3 Identifies and analyzes problems also offers solutions in tasks of production, marketing, management, accounting and finance. X
4 Contributes to projects, takes responsibility and conduct researches in tasks of production, marketing, management, accounting and finance. X
5 Can define goals and objectives of organization in tasks of production, marketing, management, accounting and finance. X
6 Questions the acquired knowledge in tasks of production, marketing, management, accounting and finance. X
7 Believes to adapting new situations and meets the requirements of new tasks of production, marketing, management, accounting and finance. X
8 Can transfer knowledge and recommendations in tasks of production, marketing, management, accounting and finance via using necessery communication tools and a foreign language effectively . X
9 Open to occupational cooperation and sharing in tasks of production, marketing, management, accounting and finance. X
10 Can use necessary information systems in tasks of production, marketing, management, accounting and finance. X
11 Behaves in accordance with social and occupational ethic values in tasks of production, marketing, management, accounting and finance. X
12 Analyses and carries out relations with stake holders in tasks of production, marketing, management, accounting and finance. X
13 Follows the innovations and encourages team members in tasks of production, marketing, management, accounting and finance. X
14 Questions the position of the organization and offers suggestions in tasks of production, marketing, management, accounting and finance. X
16
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 40
1. Kısa Sınav 20
1. Proje / Tasarım 40
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 1 16
Mid-terms 1 10 10
Quiz 1 10 10
Project / Design 1 10 10
Final examination 1 20 20
Total Workload 114
Total Workload / 25 (Hours) 4.56
dersAKTSKredisi 5