| Course Type | Elective Course |
|---|
| Course Level | Bachelor's Degree |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Have the ability to explain basic concepts such as database, data, information .
- Have the ability to create database, tables, forms, and reports.
- Can apply the first three normalization forms to unnormal tables and draw ER diagrams.
- Have the ability to write SQL queries (selecting, updating, deleting and adding).
- Have the ability to write VBA module.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | |
|---|
| Course Description | 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 |
|
| Recommended 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 |
20 |
| Project |
1 |
15 |
| Total(%) |
|
65 |
| Contribution of In-term Studies to Overall Grade(%) |
|
65 |
| Contribution of Final Examination to Overall Grade(%) |
|
35 |
| Total(%) |
|
100 |
|
| ECTS Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| 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 Work Load | 150 |
| Total Work Load / 30 (h) | 5 |
| ECTS Credit of the Course | 5 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
