Code | Name of the Course Unit | Semester | In-Class Hours (T+P) | Credit | ECTS Credit |
---|---|---|---|---|---|
YBS205 | INTRODUCTION TO DATABASE | 3 | 3 | 3 | 6 |
GENERAL INFORMATION |
|
---|---|
Language of Instruction : | Turkish |
Level of the Course Unit : | BACHELOR'S DEGREE, TYY: + 6.Level, EQF-LLL: 6.Level, QF-EHEA: First Cycle |
Type of the Course : | Compulsory |
Mode of Delivery of the Course Unit | - |
Coordinator of the Course Unit | Assist.Prof. DİDEM TETİK KÜÇÜKELÇİ |
Instructor(s) of the Course Unit | Res.Asisst. MERVE VURAL ALLAHAM |
Course Prerequisite | No |
OBJECTIVES AND CONTENTS |
|
---|---|
Objectives of the Course Unit: | This course aims to understand the concept of data, to model different structures, to list the functions of databases, to create the necessary infrastructure to develop queries by using relational databases. |
Contents of the Course Unit: | Contents of the course include the subjects such as data concept, data structures, data models, access to databases, database components, relational databases, table creation, indexing, sorting and querying. |
KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to) |
---|
Describe concepts of data and database. |
Discover the relational data model. |
Experiment the relational structure of a business's information system. |
Act data transfer from external environments. |
Practice various queries on tables. |
Design data entry forms. |
Prepare reports from data. |
WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY |
|||
---|---|---|---|
Week | Preparatory | Topics(Subjects) | Method |
1 | - | Introduction to databases, database concepts | Lecture & Discussion & Practice |
2 | Literature Review | What is database? database management system (VTYS), components of database management system | Lecture & Discussion & Practice |
3 | Literature Review | Data Models, relational models, relation types | Lecture & Discussion & Practice |
4 | Literature Review | Microsoft Office Access, table creation, Microsoft Access data types and functions | Lecture & Discussion & Practice |
5 | Literature Review | External data transfer, select query (sorting, and, or like) | Lecture & Discussion & Practice |
6 | Literature Review | Table creation querying, updating querying, text functions, conditional functions | Lecture & Discussion & Practice |
7 | Literature Review | Record append query, delete query, crosstab query, replicable finding query, mismatch finding query | Lecture & Discussion & Practice |
8 | - | MID-TERM EXAM | - |
9 | Literature Review | Form Design | Lecture & Discussion & Practice |
10 | Literature Review | Form Design | Lecture & Discussion & Practice |
11 | Literature Review | Form Design | Lecture & Discussion & Practice |
12 | Literature Review | Rapor Design | Lecture & Discussion & Practice |
13 | Literature Review | Rapor Design | Lecture & Discussion & Practice |
14 | Literature Review | Macro and Modules | Lecture & Discussion & Practice |
15 | Literature Review | Macro and Modules | Lecture & Discussion & Practice |
16 | - | FINAL EXAM | - |
17 | - | FINAL EXAM | - |
SOURCE MATERIALS & RECOMMENDED READING |
---|
Ozturk, T. H. (2015). Veritabanı Yonetimine Giris Oracle Database 11g R2. Abakus Books |
Ozkan, Y., & Tuzel, A. D. (2009). Veri tabanı sistemleri. Alfa Press. |
Ozseven, T. (2013). Veritabanı Yonetim Sistemleri I. Ekin Press |
ASSESSMENT |
|||
---|---|---|---|
Assessment & Grading of In-Term Activities | Number of Activities | Degree of Contribution (%) | Description |
Level of Contribution | |||||
---|---|---|---|---|---|
0 | 1 | 2 | 3 | 4 | 5 |
KNOWLEDGE |
|||||||
---|---|---|---|---|---|---|---|
Theoretical |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Define concepts such as management, manager and leader.
|
3 | |||||
2 |
Analyze the accuracy, reliability and validity of the new information obtained from the data.
|
4 |
KNOWLEDGE |
|||||||
---|---|---|---|---|---|---|---|
Factual |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Report the obtained data.
|
5 | |||||
2 |
Prepare software and projects related with the field.
|
5 |
SKILLS |
|||||||
---|---|---|---|---|---|---|---|
Cognitive |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Use the appropriate resources for data analysis related with the field.
|
5 | |||||
2 |
Analyze the work processes.
|
5 |
SKILLS |
|||||||
---|---|---|---|---|---|---|---|
Practical |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Manage projects as part of a team.
|
5 | |||||
2 |
Apply the material, techniques and analyzes in relation with the subject for project and work flows.
|
5 |
OCCUPATIONAL |
|||||||
---|---|---|---|---|---|---|---|
Autonomy & Responsibility |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Fulfill responsibility with a focus on result in individual and team studies.
|
5 |
OCCUPATIONAL |
|||||||
---|---|---|---|---|---|---|---|
Learning to Learn |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Recognizes what he/she knows about his/her field or not.
|
5 | |||||
2 |
Act the theoretical knowledge in real life with learning to learn approach.
|
5 | |||||
3 |
Apply different methods and techniques with an innovative approach in his/her research.
|
5 |
OCCUPATIONAL |
|||||||
---|---|---|---|---|---|---|---|
Communication & Social |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Apply the results obtained in accordance with voluntarism and social responsibility projects.
|
5 | |||||
2 |
Establish a healthy contact with colleagues
|
5 | |||||
3 |
Share the analyzes and obtained results with colleagues.
|
5 | |||||
4 |
Cooperate with colleagues at international level with the help of foreign language competency.
|
4 |
OCCUPATIONAL |
|||||||
---|---|---|---|---|---|---|---|
Occupational and/or Vocational |
|||||||
Programme Learning Outcomes | Level of Contribution | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
1 |
Behave in accordance with ethical values regarding the collection, analysis and reporting of data.
|
4 | |||||
2 |
Participate the design of work processes and systems with full quality.
|
5 | |||||
3 |
Cooperate with other employees for the continuation of sustainability in the profession.
|
4 |
WORKLOAD & ECTS CREDITS OF THE COURSE UNIT |
|||
---|---|---|---|
Workload for Learning & Teaching Activities |
|||
Type of the Learning Activites | Learning Activities (# of week) | Duration (hours, h) | Workload (h) |
Lecture & In-Class Activities | 14 | 3 | 42 |
Preliminary & Further Study | 13 | 2 | 26 |
Land Surveying | 0 | 0 | 0 |
Group Work | 0 | 0 | 0 |
Laboratory | 0 | 0 | 0 |
Reading | 0 | 0 | 0 |
Assignment (Homework) | 12 | 1 | 12 |
Project Work | 0 | 0 | 0 |
Seminar | 0 | 0 | 0 |
Internship | 0 | 0 | 0 |
Technical Visit | 0 | 0 | 0 |
Web Based Learning | 0 | 0 | 0 |
Implementation/Application/Practice | 0 | 0 | 0 |
Practice at a workplace | 0 | 0 | 0 |
Occupational Activity | 0 | 0 | 0 |
Social Activity | 0 | 0 | 0 |
Thesis Work | 0 | 0 | 0 |
Field Study | 0 | 0 | 0 |
Report Writing | 0 | 0 | 0 |
Final Exam | 1 | 1 | 1 |
Preparation for the Final Exam | 7 | 5 | 35 |
Mid-Term Exam | 1 | 1 | 1 |
Preparation for the Mid-Term Exam | 6 | 6 | 36 |
Short Exam | 0 | 0 | 0 |
Preparation for the Short Exam | 0 | 0 | 0 |
TOTAL | 54 | 0 | 153 |
Total Workload of the Course Unit | 153 | ||
Workload (h) / 25.5 | 6 | ||
ECTS Credits allocated for the Course Unit | 6,0 |