TYPE OF COURSE UNIT	Elective Course
LEVEL OF COURSE UNIT	Bachelor's Degree
YEAR OF STUDY	-
SEMESTER	-
NUMBER OF ECTS CREDITS ALLOCATED	5
NAME OF LECTURER(S)	Assistant Professor Muhammet Yorulmaz
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Have the ability to explain basic concepts such as database, data, information . 2) Have the ability to create database, tables, forms, and reports. 3) Can apply the first three normalization forms to unnormal tables and draw ER diagrams. 4) Have the ability to write SQL queries (selecting, updating, deleting and adding). 5) Have the ability to write VBA module.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT
COURSE DEFINITION	In this course, database, basic information and concepts about database management systems, designing tables, queries, forms and reports, normalization, entity relationship diagrams (ER), structured query language (SQL), module programming are covered.
COURSE CONTENTS	WEEK TOPICS 1st Week Data, information, database : understanding. Basic concept and structure of DB. 2nd Week Tables: Data types, create table practices on Access and MySQL 3rd Week Normalization process and draw ER diagrams. 4th Week Queries: Introduction to SQL. SELECT command. 5th Week Queries: SELECT and INSERT command 6th Week Queries: DELETE and UPDATE command 7th Week Reports: Create reports. 8th Week Midterm 9th Week VBA programming : Module, subroutine and variable types 10th Week VBA programming : Standart functions 11th Week VBA programming : Control Structures 12th Week VBA programming : Arrays 13th Week VBA programming : Data Access Objects 14th Week Sample Applications
RECOMENDED OR REQUIRED READING	Access Database Design & Programming, Steven Roman Publisher: O'Reilly Microsoft Office Acces 2007 Steve Lambert, M. Dow Lambert III ve Joan Preppernau
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Lecture,Practice,Project,Presentation,Questions/Answers
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 30 Practice 6 15 Project 1 20 Total(%) 65 Contribution of In-term Studies to Overall Grade(%) 65 Contribution of Final Examination to Overall Grade(%) 35 Total(%) 100
ECTS WORKLOAD	Activities Number Hours Workload Midterm exam 1 2 2 Preparation for Quiz Individual or group work 14 1 14 Preparation for Final exam 1 15 15 Course hours 14 3 42 Preparation for Midterm exam 1 15 15 Laboratory (including preparation) 7 5 35 Final exam 1 2 2 Homework Project 1 25 25 Total Workload 150 Total Workload / 30 5 ECTS Credits of the Course 5
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No