Course Name Code Semester T+U Hours Credit ECTS
Database Design and Applications BSM 436 8 3 + 0 3 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Optional
Course Coordinator GÖKHAN YILMAZ
Course Lecturers
Course Assistants
Course Category
Course Objective The aim of the course is to teach the usage, design and applications of database management systems with practices.
Course Content Basic concepts of database, database management systems, SQL, Oracle
# Course Learning Outcomes Teaching Methods Assessment Methods
1 Recognize database management systems Lecture, Testing,
2 Use Oracle Lecture, Drilland Practice, Testing, Homework,
3 Use Sql Server Lecture, Drilland Practice, Project Based Learning, Testing, Homework, Project / Design,
4 Use DB2 Lecture, Drilland Practice, Testing, Homework,
Week Course Topics Preliminary Preparation
1 Basics of database (installation, uninstallation)
2 Design, modelling and management systems in databases
3 Oracle database and properties
4 Oracle database and using tools
5 Creating tables and recording procedures in Oracle
6 Functions in Oracle
7 Ordering, getting records, updating and deleting procedures in Oracle
8 Table design examples and query tecnics in Oracle
9 Oracle APEX
10 Oracle APEX
11 Oracle APEX
12 Oracle APEX
13 Oracle APEX
14 Oracle APEX
Resources
Course Notes Lecture Notes
Course Resources orcale docs
Order Program Outcomes Level of Contribution
1 2 3 4 5
1 To have sufficient foundations on engineering subjects such as science and discrete mathematics, probability/statistics; an ability to use theoretical and applied knowledge of these subjects together for engineering solutions, X
2 An ability to determine, describe, formulate and solve engineering problems; for this purpose, an ability to select and apply proper analytic and modeling methods,al background in describing, formulating, modeling and analyzing the engineering problem, with a consideration for appropriate analytical solutions in all necessary situations X
3 An ability to select and use modern techniques and tools for engineering applications; an ability to use information technologies efficiently, X
4 An ability to analyze a system, a component or a process and design a system under real limits to meet desired needs; in this direction, an ability to apply modern design methods, X
5 An ability to design, conduct experiment, collect data, analyze and comment on the results and consciousness of becoming a volunteer on research, X
6 Understanding, awareness of administration, control, development and security/reliability issues about information technologies, X
7 An ability to work efficiently in multidisciplinary teams, self confidence to take responsibility, X
8 An ability to present himself/herself or a problem with oral/written techniques and have efficient communication skills; know at least one extra language, X
9 An awareness about importance of lifelong learning; an ability to update his/her knowledge continuously by means of following advances in science and technology, X
10 Understanding, practicing of professional and ethical responsibilities, an ability to disseminate this responsibility on society, X
11 An understanding of project management, workplace applications, health issues of laborers, environment and job safety; an awareness about legal consequences of engineering applications, X
12 An understanding universal and local effects of engineering solutions; awareness of entrepreneurial and innovation and to have knowledge about contemporary problems. X
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 55
1. Ödev 15
2. Ödev 15
3. Ödev 15
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 15 15
Assignment 3 10 30
Final examination 1 20 20
Total Workload 129
Total Workload / 25 (Hours) 5.16
dersAKTSKredisi 5