• HOME
• ABOUT US
  • Name Address
  • General Description
  • Governance
  • Academic Calendar
  • Degree Programmes
  • List of Programmes in English
  • General Admission and Registration Procedures
  • Credit Mobility and Recognition of Prior Learning
  • ECTS Credit Allocation
  • Academic Guidance
  • Contacts
• Degree Programmes
  • Third Cycle Programmes (Doctorate Degree)
  • Second Cycle Programmes (Master's Degree)
  • First Cycle Programmes (Bachelor's Degree)
  • Short Cycle Programmes (Associate's Degree)
• GENERAL INFORMATION FOR STUDENTS
  • Cost of Living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Disabled Students
  • Insurance
  • Financial Supports
  • Student Affairs Office
  • Practical Information for International Students
  • Language Courses
  • Work Placement Possibilities
  • Sports, Social and Cultural Facilities
  • Student Associations and Clubs
  • About İzmir - Turkey
• INTERNATIONAL RELATIONS
  • International Relations Office
  • Registration Procedures
  • Agreements
  • Coordinators
  • Documents
  • List of Programmes in English
  • ECTS / DS Labels

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS YBS 2024 DATABASE MANAGEMENT SYSTEMS II 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 information about database management systems and advanced querying and operation

Learning Outcomes of the Course Unit

1   To recognize advanced level operations in database management systems. 2   To be able to understand advanced queries. 3   To be able to conduct nested queries 4   Grouping and querying multiple related tables 5   To be able to integrate databases with other software

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

YBS 2019 - DATABASE MANAGEMENT SYSTEMS I

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Queries- Arithmetic Operations 2 Functions-I 3 Functions-II 4 Normalization 5 Grouping-I 6 Grouping-II 7 Querying multiple related tables I 8 Querying multiple related tables II 9 Nested Queries-I 10 Nested Queries-II 11 Procedures-I 12 Procedures-II 13 Trigger I 14 Trigger II

Recomended or Required Reading

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

Planned Learning Activities and Teaching Methods

Events are in 'Assessment Methods' and 'Workload Calculation' section detaily.

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

Events are in 'Assessment Methods' and 'Workload Calculation' section detaily.

Language of Instruction

Turkish

Course Policies and Rules

The rules applied by the university is valid.

Contact Details for the Lecturer(s)

Dokuz Eylül Üniversitesi - I.I.B.F. Yönetim Bilişim Sistemleri Bölümü - Dokuzçeşmeler Kampüsü - Buca - IZMIR 35160 Tel: 0 232 301 07 62 e-mail: cigdem.tarhan@deu.edu.tr

Office Hours

It 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 Final 1 1 1 Midterm 1 1 1 TOTAL WORKLOAD (hours) 75

Contribution of Learning Outcomes to Programme Outcomes

PO/LO PO.1 PO.2 PO.3 PO.4 PO.5 PO.6 PO.7 PO.8 PO.9 PO.10 PO.11 PO.12 PO.13 LO.1 5 5 5 LO.2 5 5 5 LO.3 5 5 LO.4 5 5 5 LO.5 5 5 5