Information Package / Course Catalogue
Institutional Data and Database Management
Course Code: MIS505
Course Type: Area Elective
Couse Group: Second Cycle (Master's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 3
Prt.: 0
Credit: 3
Lab: 0
ECTS: 7
Objectives of the Course

In today's business and business life, databases are a requirement for companies to gain competitive advantage and, at least, to meet their competitors. A well-designed and built-in database system integrated with other management information systems will provide the data and information needed to make hundreds of structured, semi-structured and unstructured decisions that middle and senior executives in the business have to take every day. A wide variety of databases are used in each department of the business. However, in order to maximize the benefit of a database, it should be carefully planned in the most effective manner in line with business needs. This requires knowledge of both management and technology. This course aims to introduce students to these systems and technologies and to work on examples without applying them.

Course Content

Database design, unit relationship diagrams, system analysis and database management systems

Name of Lecturer(s)
Learning Outcomes
1.Is informed of structure and importance of databases
2.Can interpret database design in the scope of principles of database design
3.Can design relevance diagrams
4. Can make design and practices with using system analysis and database management system
5.Can use basic functions in a database managenet system
6.Can fix and produce solutions to problems faced in business life about database usage
Recommended or Required Reading
Weekly Detailed Course Contents
Week 1 - Theoretical
Database: Definition and Concepts, Importance for enterprises and policymakers
Week 2 - Theoretical
Veritabanı Proje Safhaları
Week 3 - Theoretical
Database Design Stage: ER Modelling
Week 4 - Theoretical
ER Modelling and Practices
Week 5 - Theoretical
Advanced Issues in ER Modelling and practices
Week 6 - Theoretical
Logical database design stage and relationnally model / Normality of design
Week 7 - Theoretical
Examples of design normalization
Week 8 - Theoretical
Physical design of database and issues of performance/ SQL and Basic SQL Commands
Week 9 - Intermediate Exam
Ara Sınav
Week 10 - Intermediate Exam
Midterm Exam
Week 11 - Theoretical
Advanced SQL Commands
Week 12 - Theoretical
Designing a hospital database system using MS Access
Week 13 - Theoretical
Managerial Problems about database management
Week 14 - Theoretical
Database management system of large scale institutions
Week 15 - Final Exam
Final Exam
Week 16 - Final Exam
Final Exam
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory160348
Assignment102020
Individual Work260378
Quiz20510
Midterm Examination101010
Final Examination101515
TOTAL WORKLOAD (hours)181
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
PÇ-10
OÇ-1
2
4
4
5
5
5
4
4
4
OÇ-2
4
4
5
4
5
4
4
4
5
4
OÇ-3
4
5
5
5
5
5
5
5
4
5
OÇ-4
3
4
4
4
4
5
5
5
5
5
OÇ-5
3
4
4
4
5
5
5
5
5
5
OÇ-6
4
5
5
5
4
4
4
4
4
4
Adnan Menderes University - Information Package / Course Catalogue