COURSE UNIT TITLE

: ADVANCED REPORTING AND DATA BASE APPLICATIONS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
YBS 6009 ADVANCED REPORTING AND DATA BASE APPLICATIONS ELECTIVE 3 0 0 8

Offered By

Management Information Systems

Level of Course Unit

Third Cycle Programmes (Doctorate Degree)

Course Coordinator

ASSOCIATE PROFESSOR ÇIĞDEM TARHAN

Offered to

Management Information Systems

Course Objective

The aim of this course is to provide basic information which is taken at the level of undergraduate and graduate level in the field of Management Informatics Systes in order to report the queries in the enterprises and explain the detailed queries and database applications.

Learning Outcomes of the Course Unit

1   1. Having experience in using the correct needs identification techniques in the database reporting process.
2   2. Be able to make the right decisions by discussing different database applications.
3   3. Experience in database installation and management process.
4   4. Identify and manage risks in the database installation and management process.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 1.Database Design Concept (Normalization, Advanced Data Modelling)
2 2. Database Design Concept (Normalization, Advanced Data Modelling)
3 3. Advanced SQL and Database Design
4 4. Advanced Database Concept (Transaction Management and Concurrency Control)
5 5. Advanced Database Concept ( Database Performance Tuning and Query Optimization)
6 6. Advanced Database Concept (Distributed Database Management Systems and Reporting)
7 7. Advanced Database Concept (Big Data and NoSQL)
8 8.Mid-term
9 9. Database and the Internet (Reporting via Database Connectivity and Web Technologies)
10 10. Object Database (Object-Relational Database, Object Query Language)
11 11. Data Security (Role-Based Access Control)
12 12. ETL Processes
13 13. Online Analytical Processing (OLAP)
14 14. Project Applications

Recomended or Required Reading

Ana Kaynak: Advacned Database Management System, ISBN: 978-93-5119-455-2
Yardımcı Kaynak: Database Systems: Design, Implementation, & Management, ISBN: 978-1305627482

Planned Learning Activities and Teaching Methods

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 PRJ PROJECT
3 PRS PRESENTATION
4 FIN FINAL EXAM
5 FCG FINAL COURSE GRADE MTE* 0.20 + PRJ* 0.20 + PRS* 0.20 + FIN* 0.40
6 RST RESIT
7 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.20 + PRJ * 0.20 + PRS * 0.20 + RST* 0.40


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

To be announced.

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Preparations before/after weekly lectures 13 3 39
Preparation for midterm exam 1 15 15
Preparation for final exam 1 25 25
Preparing presentations 1 30 30
Preparing report 1 40 40
Final 1 1 1
Midterm 1 1 1
TOTAL WORKLOAD (hours) 190

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9
LO.155555
LO.255555
LO.355555
LO.455555