| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | EM409.3B | Database Management | Elective | 4 | 7 | 4 |
|
| Level of Course Unit |
| First Cycle |
| Objectives of the Course |
| The purpose of this program, the students ' information systems data model, file management and database systems is to understand the role. |
| Name of Lecturer(s) |
| Öğr. Gör. Ahmet DEVELİ |
| Learning Outcomes |
| 1 | Student information systems, data, files and databases can develop thoughts about the role. | | 2 | Student System Development Life Cycle (SDLC) process can perform database development activities. | | 3 | Student data base that can be used in developing data model concepts (E-R and Class diagrams) can work with. | | 4 | Students can create databases and relational databases can make complex SQL queries. | | 5 | Student Some database management systems (Ms Access, SQL, and ORACLE) thoughts. | | 6 | Student data integrity and security in data management to include a wide range of aspects of the problem. |
|
| Mode of Delivery |
| Normal Education |
| Prerequisites and co-requisities |
| None |
| Recommended Optional Programme Components |
| None |
| Course Contents |
| Database and database management systems, introduction of basic concepts related to/data classification and Data independence and data base architecture/coding/data warehouse structures and physical storage tools/Sequential and direct data organization and processing/classification of data files/Relational database systems/logical database systems/cross high-level languages data structures/Pascalda data structure/Excel data structure/Access data structure/communication technologies and data structures. |
| Weekly Detailed Course Contents |
|
| 1 | Introduction to class, database environments | | | | 2 | File processing, Database Development Process, Being associated with the Model (E-R), E-R Models, Advanced E-R Models | | | | 3 | E-R Models (continued), enhanced E-R Models (continued), Logical database design and the Relational Model | | | | 4 | The Relational Database Model, Normalization | | | | 5 | Relational Database Model (Cont'd), Normalization (Continued), Physical Database Design | | | | 6 | Physical database design (read more), SQL-introduction | | | | 7 | SQL (Read More) | | | | 8 | | | | | 9 | SQL job packages | | | | 10 | Data and database management | | | | 11 | Object-Oriented Models | | | | 12 | Object-oriented Models and Databases | | | | 13 | Client/server and Databases | | | | 14 | Distributed Databases | | | | 15 | Essay Reviews | | |
|
| Recommended or Required Reading |
| Modern Database Management, by Jeffrey a. Hoffer, Mary b. Prescott and Fred r. Mcfadden. Published by Prentice Hall. |
| Planned Learning Activities and Teaching Methods |
|
| Assessment Methods and Criteria | |
| Midterm Examination | 1 | 100 | | SUM | 100 | |
| Final Examination | 1 | 100 | | SUM | 100 | | Term (or Year) Learning Activities | 40 | | End Of Term (or Year) Learning Activities | 60 | | SUM | 100 |
| | Language of Instruction | | Turkish | | Work Placement(s) | | None |
|
| Workload Calculation |
|
| Midterm Examination | 1 | 1 | 1 |
| Final Examination | 1 | 2 | 2 |
| Attending Lectures | 14 | 3 | 42 |
| Self Study | 14 | 2 | 28 |
| Individual Study for Mid term Examination | 1 | 14 | 14 |
| Individual Study for Final Examination | 1 | 18 | 18 |
| Homework | 4 | 4 | 16 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | | | | | | | 5 | 3 | | LO2 | | | | | | | 4 | 1 | | LO3 | | | | | | | 2 | 4 | | LO4 | | | | | | | 3 | 4 | | LO5 | | | | | | | 2 | 2 | | LO6 | | | | | | | 5 | 4 |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
 |
| |