COURSE UNIT TITLE

: DATABASE MANAGEMENT SYSTEMS I

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
YBS 2019 DATABASE MANAGEMENT SYSTEMS I COMPULSORY 3 0 0 3

Offered By

Management Information Systems

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

PROFESSOR DOCTOR VAHAP TECIM

Offered to

Management Information Systems

Course Objective

To give basic information about databases, database management systems and query languages.

Learning Outcomes of the Course Unit

1   Identify databases and management applications.
2   To be able to determine the database needs.
3   Be able to compare different database products, choose for needs.
4   Be able to design the database.
5   To be able to make connections between software and databases.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Basic concepts
2 Data - Data Types
3 Entity Relationship Diagram
4 Introduction to SQL
5 SQL queries I
6 SQL queries II
7 SQL queries III
8 SQL queries IV
9 Operations performed on tables I
10 Operations performed on tables II
11 Operations performed on tables III
12 Queries I
13 Queries II
14 Queries III

Recomended or Required Reading

https://www.w3schools.com/sql/default.asp

Planned Learning Activities and Teaching Methods

Activities are given in detail in the 'Evaluation Methods' and 'Workload Calculation' sections.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 MTEG MIDTERM GRADE MTEG * 1
3 FIN FINAL EXAM
4 FCGR FINAL COURSE GRADE MTEG * 0.40 + FIN * 0.60
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTEG * 0.40 + RST * 0.60


Further Notes About Assessment Methods

None

Assessment Criteria

Activities are given in detail in the Evaluation Methods and Workload Calculation section.

Language of Instruction

Turkish

Course Policies and Rules

The rules implemented by the department apply.

Contact Details for the Lecturer(s)

cigdem.tarhan@deu.edu.tr

Office Hours

will be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 14 3 42
Preparations before/after weekly lectures 14 1 14
Preparation for midterm exam 1 8 8
Preparation for final exam 1 9 9
Midterm 1 1 1
Final 1 1 1
TOTAL WORKLOAD (hours) 75

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13
LO.15555
LO.25555
LO.35555
LO.45555
LO.55555