CEIT390 DATABASE MANAGEMENT SYSTEMS
| Course Code: | 4300390 |
| METU Credit (Theoretical-Laboratory hours/week): | 3 (2.00 - 2.00) |
| ECTS Credit: | 5.0 |
| Department: | Computer Education and Instructional Technology |
| Language of Instruction: | English |
| Level of Study: | Undergraduate |
| Course Coordinator: | Lecturer ALİ CAN |
| Offered Semester: | Spring Semesters. |
Course Objectives
This introductory course provides a general framework for prospective teacher about practices of Database Management Systems . Learning activities including readings, classroom discussions and other assignments will be related to steps in all Database Systems. The main focus of this course is Database Management Systems
.
Course Content
Foundations of database systems, data and data models, design of relational database, SQL, Basic SQL commands, SQL functions, using multi-tables with SQL, SQL programming and function, transaction and errors in SQL, DBMS installation and administrative operations, doing SQL queries in a DBMS.
Course Learning Outcomes
To understand the hierarchy of database system and database management systems To know the conceptual differences among relational, hierarchical, network, and object oriented database system models, To understand and utilize relational model to solve problems relate to database system, To use Structure Query Language (SQL) to retrieve data from a database, update existing data in a database and create and modify database objects, To understand the importance and means to maintain database integrity, database security, resolve concurrency issues, and transaction control as well as the query optimization process, and To design and create basic relational database objects using Oracle DBMS
Program Outcomes Matrix
| Level of Contribution | |||||
| # | Program Outcomes | 0 | 1 | 2 | 3 |
| 1 | They have the skill and knowledge to use information technologies. | ✔ | |||
| 2 | They use information technology to access information, and they analyze, synthesize, and evaluate knowledge by adapting to new situations. | ✔ | |||
| 3 | They use strategies and techniques based on learning theories and apply them to solve instructional problems in a systemic and systematic way | ✔ | |||
| 4 | They have skill and knowledge in analysis, design, development, implementation and evaluation in instructional design process. | ✔ | |||
| 5 | They implement learning-teaching methods and techniques in computer education. | ✔ | |||
| 6 | They have knowledge, skill and competency about computer hardware, operating systems, computer networks and programming languages. | ✔ | |||
| 7 | They determine measurement and evaluation methods and techniques used in computer education. | ✔ | |||
| 8 | They have the ability to conduct and present results of intra-disciplinary and inter-disciplinary researches in the field of instructional technology. | ✔ | |||
| 9 | They comprehend project management processes and implement and present projects electronically. | ✔ | |||
| 10 | They have critical thinking and problem solving skills. | ✔ | |||
| 11 | They have social communication and cultural exchange skills. | ✔ | |||
| 12 | They have legal knowledge, skills and attitudes required for teaching profession and apply them in the learning environment. | ✔ | |||
0: No Contribution 1: Little Contribution 2: Partial Contribution 3: Full Contribution