Course Name Code Semester T+U Hours Credit ECTS
Introduction To Databases and Database Management YBS 301 5 4 + 0 4 7
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Compulsory
Course Coordinator Dr.Öğr.Üyesi ALPASLAN KİBAR
Course Lecturers Dr.Öğr.Üyesi ALPASLAN KİBAR,
Course Assistants
Course Category Available Basic Education in the Field
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 follow new and current technologies and evaluate them X
2 Can understand the operation of Corporate Information Systems and use these systems at a basic level
3 Constructs numerical models of basic business problems. X
4 Solves modeled business problems with the help of information technologies and interprets the solutions
5 Contributes to informatics oriented projects as a member of the team
6 Effectively uses information technology tools that support teamwork in project management. X
7 Master basic business functions and information technologies and establishes the link between them
8 Contributes to the design, development and implementation processes of corporate information systems.
9 Can produce and present quality documentation for all kinds of projects, including entrepreneurship projects.
10 Prepares informative, effective and interesting presentations and presents these presentations. X
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 40
1. Ödev 20
2. Ödev 20
3. Ödev 20
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 4 64
Hours for off-the-classroom study (Pre-study, practice) 16 3 48
Mid-terms 1 10 10
Final examination 1 25 25
Total Workload 147
Total Workload / 25 (Hours) 5.88
dersAKTSKredisi 7