Code |
Name of the Course Unit |
Semester |
In-Class Hours (T+P) |
Credit |
ECTS Credit |
VTK102 |
DATABASE BASICS |
2 |
3 |
3 |
6 |
GENERAL INFORMATION |
Language of Instruction : |
Turkish |
Level of the Course Unit : |
ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle |
Type of the Course : |
Compulsory |
Mode of Delivery of the Course Unit |
- |
Coordinator of the Course Unit |
Lecturer ÇİSEM YAŞAR |
Instructor(s) of the Course Unit |
Lecturer AYSUN YILMAZ KIZILBOĞA |
Course Prerequisite |
No |
OBJECTIVES AND CONTENTS |
Objectives of the Course Unit: |
It is aimed to gain the ability to organize data in computer environment, to design structural database models, to accept, process and report data safely and effectively. |
Contents of the Course Unit: |
- Data and its organization
- Recognize existing database technologies
- Designing a data model
- Database normalization
- Data entry, modification, destruction and reporting operations
- It includes batch processing topics. |
KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to) |
Designing a Database |
Creating the Database |
Querying a Database |
WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY |
Week |
Preparatory |
Topics(Subjects) |
Method |
1 |
- |
Filing Systems, Data, Information, Information and Database Concepts |
Lecture, Application |
2 |
Doing research on the internet about the subject |
Database Management Systems, Database Models, Models, Database Architectures |
Lecture, Application |
3 |
Doing research on the internet about the subject |
Data Modeling Stages, Entity Relationship Diagram |
Lecture, Application |
4 |
Doing research on the internet about the subject |
Normalization |
Lecture, Application |
5 |
Doing research on the internet about the subject |
Installing Database Tools, Creating Tables and Determining Their Properties |
Lecture, Application |
6 |
Doing research on the internet about the subject |
Creating Tables, Determining Properties and Entering Data to Tables |
Lecture, Application |
7 |
Doing research on the internet about the subject |
Using DDL Queries |
Lecture, Application |
8 |
- |
MID-TERM EXAM |
- |
9 |
Doing research on the internet about the subject |
Using DDL Queries |
Lecture, Application |
10 |
Doing research on the internet about the subject |
Using DML Queries |
Lecture, Application |
11 |
Doing research on the internet about the subject |
Using DML Queries |
Lecture, Application |
12 |
Doing research on the internet about the subject |
Using DCL Queries |
Lecture, Application |
13 |
Doing research on the internet about the subject |
Using DCL Queries |
Lecture, Application |
14 |
Doing research on the internet about the subject |
Subprogram Queries, Transaction Operations |
Lecture, Application |
15 |
Doing research on the internet about the subject |
Database Backup and Export |
Lecture, Application |
16 |
- |
FINAL EXAM |
- |
17 |
- |
FINAL EXAM |
- |
SOURCE MATERIALS & RECOMMENDED READING |
SQL Server 2012 and Database Programming for Software Developers, Yaşar Gözüdeli, Seçkin Publishing |
ASSESSMENT |
Assessment & Grading of In-Term Activities |
Number of Activities |
Degree of Contribution (%) |
Description |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
CONTRIBUTION OF THE COURSE UNIT TO THE PROGRAMME LEARNING OUTCOMES
KNOWLEDGE |
Theoretical |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Bilgisayarın temel kavram ve yazılımlarına hâkim olur.
|
|
|
|
|
|
|
KNOWLEDGE |
Factual |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Have a command of the concepts commonly used in web design.
|
|
|
|
|
|
|
SKILLS |
Cognitive |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Planning the code part of a website by having knowledge of algorithms It does.
|
|
|
|
|
|
|
SKILLS |
Practical |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Visualization of the visual part of Web sites using visual design principles makes the planning.
|
|
|
|
|
|
|
OCCUPATIONAL |
Autonomy & Responsibility |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Observes ethical, health and safety measures related to the profession.
|
|
|
|
|
|
|
OCCUPATIONAL |
Learning to Learn |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Knows different methods of preparing a website.
|
|
|
|
|
|
|
OCCUPATIONAL |
Communication & Social |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Can run web sites integrated with database management systems.
|
|
|
|
|
|
|
OCCUPATIONAL |
Occupational and/or Vocational |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
It may collect information about user experiences. Target with the information it collects can manage a website suitable for the audience.
Can ensure basic security of websites.
|
|
|
|
|
|
|
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 |
0 |
0 |
0 |
Preliminary & Further Study |
0 |
0 |
0 |
Land Surveying |
0 |
0 |
0 |
Group Work |
0 |
0 |
0 |
Laboratory |
0 |
0 |
0 |
Reading |
0 |
0 |
0 |
Assignment (Homework) |
0 |
0 |
0 |
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 |
0 |
0 |
0 |
Preparation for the Final Exam |
0 |
0 |
0 |
Mid-Term Exam |
0 |
0 |
0 |
Preparation for the Mid-Term Exam |
0 |
0 |
0 |
Short Exam |
0 |
0 |
0 |
Preparation for the Short Exam |
0 |
0 |
0 |
TOTAL |
0 |
0 |
0 |
|
Total Workload of the Course Unit |
0 |
|
|
Workload (h) / 25.5 |
0 |
|
|
ECTS Credits allocated for the Course Unit |
0,0 |
|