YZM5507 Data Modelling and Relational DatabasesBahçeşehir UniversityDegree Programs INFORMATION TECHNOLOGIES (TURKISH, NON-THESIS)General Information For StudentsDiploma SupplementErasmus Policy StatementNational QualificationsBologna Commission
INFORMATION TECHNOLOGIES (TURKISH, NON-THESIS)
Master TR-NQF-HE: Level 7 QF-EHEA: Second Cycle EQF-LLL: Level 7

Course Introduction and Application Information

Course Code Course Name Semester Theoretical Practical Credit ECTS
YZM5507 Data Modelling and Relational Databases Fall 3 0 3 8

Basic information

Language of instruction: Turkish
Type of course: Must Course
Course Level:
Mode of Delivery: Face to face
Course Coordinator : Prof. Dr. MEHMET ALPER TUNGA
Recommended Optional Program Components: None.
Course Objectives: Defining entities and relationships, modelling attributes and constraints, normalizing data model, constructing physical database from data models, defining the basics of relational database systems, indexing, developing applications through SQL queries, developing Oracle applications

Learning Outcomes

The students who have succeeded in this course;
1. Define entities and relationships
2. Construct data models
3. Describe relational databases
4. Construct physical databases
5. Design SQL queries
6. Develop Oracle DBMS applications

Course Content

The content of this course is composed of Introduction to relational databases, Relational database management systems, Entity relationship models, Data modelling and normalization, SQL: Data definition language, Built-in functions, SQL queries and Oracle objects.

Weekly Detailed Course Contents

Week Subject Related Preparation
1) Introduction to relational databases
2) Relational database management systems
3) Entity relationship models
4) Data modelling and normalization
5) Data modelling and normalization
6) SQL: Data definition language
7) Basic SQL queries
8) Basic SQL queries
9) Built-in functions
10) Built-in function / Midterm Exam
11) Nested SQL queries
12) Nested SQL queries
13) Oracle objects
14) Oracle objects

Sources

Course Notes / Textbooks: Nilesh Shah, Database Systems using Oracle: A Simplified Guide to SQL and PL/SQL, 2ed, Pearson Prentice Hall, 2005, ISBN 0-13-191180-5
References: Yok - None.

Evaluation System

Semester Requirements Number of Activities Level of Contribution
Project 1 % 30
Midterms 1 % 30
Final 1 % 40
Total % 100
PERCENTAGE OF SEMESTER WORK % 30
PERCENTAGE OF FINAL WORK % 70
Total % 100

ECTS / Workload Table

Activities Number of Activities Duration (Hours) Workload
Course Hours 14 3 42
Application 14 3 42
Study Hours Out of Class 14 3 42
Midterms 1 22 22
Final 1 41 41
Total Workload 189

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Uses basic Software Engineering knowledge and competencies. 3
2) Applies the software development ability that is necessary for software engineering applications. 3
3) Uses data structures and applies information about algorithm development. 2
4) Develops system programs on operating systems. 2
5) Defines computer organization, design and architectures. 2
6) Creates the structure of computer networks and network security. 2
7) Uses business intelligence, data mining and data analysis tools, applies techniques about them. 3
8) Develops database applications and WEB based programs. 4
9) Defines, analyzes, designs and manages information technologies projects. 3
10) Defines, analyzes, designs and manages information technologies projects. 3
11) Detects, identifies and solves information technology needs of the business environment. 3
12) Uses the capabilities of information technologies within the rules of professional responsibility and ethics. 4