| INFORMATION TECHNOLOGIES (TURKISH, THESIS) | |||||
| Master | TR-NQF-HE: Level 7 | QF-EHEA: Second Cycle | EQF-LLL: Level 7 | ||
| Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
| YZM5507 | Data Modelling and Relational Databases | Fall | 3 | 0 | 3 | 8 |
| The course opens with the approval of the Department at the beginning of each semester |
| Language of instruction: | Tr |
| Type of course: | Must Course |
| Course Level: | |
| Mode of Delivery: | Face to face |
| Course Coordinator : | Prof. Dr. MEHMET ALPER TUNGA |
| 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 |
|
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 |
| 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. |
| 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 | ||
| Course Notes: | 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. |
| Semester Requirements | Number of Activities | Level of Contribution |
| Attendance | % 0 | |
| Laboratory | % 0 | |
| Application | % 0 | |
| Field Work | % 0 | |
| Special Course Internship (Work Placement) | % 0 | |
| Quizzes | % 0 | |
| Homework Assignments | % 0 | |
| Presentation | % 0 | |
| Project | 1 | % 30 |
| Seminar | % 0 | |
| Midterms | 1 | % 30 |
| Preliminary Jury | % 0 | |
| Final | 1 | % 40 |
| Paper Submission | % 0 | |
| Jury | % 0 | |
| Bütünleme | % 0 | |
| Total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 30 | |
| PERCENTAGE OF FINAL WORK | % 70 | |
| Total | % 100 | |
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 14 | 3 | 42 |
| Laboratory | 0 | 0 | 0 |
| Application | 14 | 3 | 42 |
| Special Course Internship (Work Placement) | 0 | 0 | 0 |
| Field Work | 0 | 0 | 0 |
| Study Hours Out of Class | 14 | 3 | 42 |
| Presentations / Seminar | 0 | 0 | 0 |
| Project | 0 | 0 | 0 |
| Homework Assignments | 0 | 0 | 0 |
| Quizzes | 0 | 0 | 0 |
| Preliminary Jury | 0 | 0 | 0 |
| Midterms | 1 | 22 | 22 |
| Paper Submission | 0 | 0 | 0 |
| Jury | 0 | 0 | 0 |
| Final | 1 | 41 | 41 |
| Total Workload | 189 | ||
| 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) | Develops system programs on operating systems. | 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) | Uses and develops technology-based environments and tools in education. | 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 |