• HOME
• ABOUT US
  • Name Address
  • General Description
  • Governance
  • Academic Calendar
  • Degree Programmes
  • List of Programmes in English
  • General Admission and Registration Procedures
  • Credit Mobility and Recognition of Prior Learning
  • ECTS Credit Allocation
  • Academic Guidance
  • Contacts
• Degree Programmes
  • Third Cycle Programmes (Doctorate Degree)
  • Second Cycle Programmes (Master's Degree)
  • First Cycle Programmes (Bachelor's Degree)
  • Short Cycle Programmes (Associate's Degree)
• GENERAL INFORMATION FOR STUDENTS
  • Cost of Living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Disabled Students
  • Insurance
  • Financial Supports
  • Student Affairs Office
  • Practical Information for International Students
  • Language Courses
  • Work Placement Possibilities
  • Sports, Social and Cultural Facilities
  • Student Associations and Clubs
  • About İzmir - Turkey
• INTERNATIONAL RELATIONS
  • International Relations Office
  • Registration Procedures
  • Agreements
  • Coordinators
  • Documents
  • List of Programmes in English
  • ECTS / DS Labels

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS BLÖ 3006 DATABASE ADMINISTRATION SYSTEMS COMPULSORY 2 2 0 4

Offered By

Computer and Instructional Technologies Teacher Education

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

INSTRUCTOR FERIT SERKAN AKDOĞAN

Offered to

Computer and Instructional Technologies Teacher Education

Course Objective

To use a program developed for database management for storing, retrieving, grouping and listing information according to some criteria, and updating it and to create SQL expressions.

Learning Outcomes of the Course Unit

1   To be able to state the advantages of database management systems 2   To be able to use ACCESS database management system 3   To be able to know SQL expressions. 4   To be able to use MySql database management system 5   To be able to develop and manage a database management system on the web

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Sample databases, the functions and advantages of database management and systems 2 A global look to ACCESS objects, tables, forms, reports, pages, macros, moduls 3 Creating a database, understanding the logic of using a database, creating tables, defining fields and their features, data types 4 Defining relations between tables, entering data to tables, importing and exporting data 5 Creating forms and questions 6 Creating reports and pages 7 Creating Makro and Modül 8 Mid-term exam 9 Intro to SQL language, CREATE, ALTER TABLE, DROP TABLE, DESCRIBE, INSERT, SELECT, UPDATE, DELETE 10 Operators, ORDER BY and DISTINCT 11 Functions, SUM, AVG, MIN, MAX, COUNT 12 Grouping, GROUP BY , HAVING, Joining, JOIN 13 Setting up MySQL, its interface and usage, creating a database, creating a table, defining fields and their features, data types 14 Creating questions and personalising them, Web based database management applications 15 Creating questions and personalising them, Web based database management applications End-of-term exam

Recomended or Required Reading

Köseoğlu, K. (2001). Veri Tabanı Mantığı

Planned Learning Activities and Teaching Methods

Face to face instruction, discussion, application

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA 1 VZ Arasınav 2 DTK Diğer Etkinlik 3 FN Yarıyılsonu Sınavı 4 BNS BNS VZ * 0.30 + DTK * 0.10 + FN * 0.60 5 BUT Bütünleme Notu 6 BBN Bütünleme Sonu Başarı Notu VZ * 0.30 + DTK * 0.10 + BUT * 0.60

Further Notes About Assessment Methods

None

Assessment Criteria

LO1, LO2, LO3, LO4 will be evaluated by a paper, a midterm and a final exam and LO5 will be evaluated by a project.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

serkan.akdogan@deu.edu.tr

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Theoretical 13 2 26 Application 13 2 26 Pre Class Self Study 5 2 10 Midterm Preparation 5 2 10 Final Preparation 5 2 10 Paper Preparation 5 2 10 Research Presentation 5 2 10 Midterm Exam 1 2 2 Final Exam 1 2 2 TOTAL WORKLOAD (hours) 106

Contribution of Learning Outcomes to Programme Outcomes

PO/LO PO.1 PO.2 PO.3 PO.4 PO.5 PO.6 PO.7 PO.8 PO.9 PO.10 PO.11 PO.12 PO.13 PO.14 PO.15 PO.16 LO.1 4 4 LO.2 4 4 LO.3 4 4 LO.4 4 4 LO.5 5 5 5 5 5 5 5