Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | EM4093 | 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 | 5 | 2 | 10 |
|
Contribution of Learning Outcomes to Programme Outcomes |
LO1 | 2 | 5 | 1 | 1 | 3 | 2 | 5 | 3 | LO2 | 2 | 5 | 3 | 1 | 3 | 3 | 4 | 1 | LO3 | 3 | 5 | 4 | 3 | 3 | 3 | 2 | 4 | LO4 | 3 | 5 | 4 | 2 | 3 | 3 | 3 | 4 | LO5 | 3 | 5 | 4 | 2 | 4 | 3 | 2 | 2 | LO6 | 3 | 5 | 4 | 3 | 4 | 4 | 5 | 4 |
|
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|