• 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 7302 DATABASE MANAGEMENT SYSTEMS ELECTIVE 3 0 0 5

Offered By

Management Information Systems Non-Thesis (Evening)

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

PROFESSOR DOCTOR VAHAP TECIM

Offered to

Management Information Systems Non-Thesis (Evening)

Course Objective

Types of databases, fundamentals of database concepts and database creation techniques will explained in this lecture. Students will gain logic of relational database and capability to use query lanquage .

Learning Outcomes of the Course Unit

1   To be able to design database by itself 2   To be able to design database procedures 3   To be able to inform about query lanquages 4   To be able to query between database tables with using query lanquages

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Fundamentals of Database Management (Database-Database Management Systems-Advantages and Disadvantages of Database-Sample Databases) 2 Relational Model1: QBE (Relational Databases-Simple Query-Functions-Gruop BY-Order-Table Relations) 3 Relational Model2:SQL (SQL-Table creation-Special Operators (LIKE, IN)-Update Table-Table creation with query) 4 Relational Model3:Advanced (Security-Structurel Changes-Procedurel Functions-MySQL Trigger) 5 Database Design 1: Normalization (Functional Dependencies-First Nominal Form-Second Nominal Form-Third Nominal Form-Decomposition Error-Multi Variable Dependencies) 6 Database Design1: Normalization (Error disposal with multi variable dependencies-Database Design Application) 7 Database Design 2: Design Methods (User Reviews-Information based Design method-Dataabse Design Samples-physical based Design-Top down - Down top DesignApproach-Questionnarie) 8 Database Design 3: Design Methods (User Reviews-Information based Design method-Dataabse Design Samples-physical based Design-Top down - Down top 9 Database Design 2: Design Methods (Information retrieval from current documents-One to One Relationships-Many to Many Relationships-Entity-Relationship data model) 10 Database Management Systems Functions (Data Recovery and Update-Catalog Service Provide-Real time update support-Security Service Support-Individual Data Support) 11 Database Management (Principles of Database-Other Database Management Functions-Technical Functions) 12 Database Management Approach (Distributed Database-Distributed Database Management System-The advantages of Distributed Database-The disadvantages of Distributed Database-Distributed Database Rules) 13 Database Management Approach (Client/Server Systems-Web based database Access-XML-Data Retrieval-Object oriented Database Management Systems) 14 Application

Recomended or Required Reading

Concepts of Database Management (Seventh Edition); Philip J. Pratt and Joseph J. Adamski; 2012

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 FCG FINAL COURSE GRADE 3 FCGR FINAL COURSE GRADE MTE * 0.40 + FCG* 0.60 4 RST RESIT 5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + RST* 0.60

Further Notes About Assessment Methods

None

Assessment Criteria

Students' performances are measured with a midterm exam and a final exam.

Language of Instruction

Turkish

Course Policies and Rules

The rules applied by the department apply.

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 4 56 Preparation for midterm exam 1 10 10 Preparation for final exam 1 15 15 Final 1 1 1 Midterm 1 1 1 TOTAL WORKLOAD (hours) 125

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 LO.1 5 5 5 5 5 5 5 5 5 5 5 LO.2 5 5 5 5 5 5 5 5 5 5 5 LO.3 5 5 5 5 5 5 5 5 5 5 5 LO.4 5 5 5 5 5 5 5 5 5 5 5