| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | YÖN204B | Database Systems and Applications II | Compulsory | 2 | 4 | 5 |
|
| Level of Course Unit |
| First Cycle |
| Objectives of the Course |
| The course aim to Designing schema of database, able to use SQL as advance level and administrate database, able to create registered method and able to manage users. |
| Name of Lecturer(s) |
| - |
| Learning Outcomes |
| 1 | Able to design database | | 2 | Knowing advance level SQL | | 3 | Able to authorizate and administrate to database | | 4 | Able to use sample database management systems |
|
| Mode of Delivery |
| Normal Education |
| Prerequisites and co-requisities |
| None |
| Recommended Optional Programme Components |
| None |
| Course Contents |
| Database concept, logical level, storage concept, database management(with Oracle), creating table, changing and managing datas. Usage limiters. Managing, changing and creating other Oracle objects(queues, indices, synonyms, images). Managing object by mean of data image, image typies, control user Access. Limitation user access(user, roles, rights). What is the data dictionary, why do we need it, how do we use it. Managing object of Schema: manipulation of big data set(insert, all when first). Data manipulation in different time area. SQL programing on database(variances, markers, decision statement, functions, procedures, trigers) |
| Weekly Detailed Course Contents |
|
| 1 | Management memory on database, transaction | | | | 2 | Create table by usage DDL and administrate to it | | | | 3 | Create Schema object | | | | 4 | Administrate object by data image | | | | 5 | Administrate by creating sort and synonym | | | | 6 | Creat and administrate other schema object | | | | 7 | Advance level DML process | | | | 8 | Mid-term Exam | | | | 9 | Large data set process | | | | 10 | Control to user Access | | | | 11 | Design and advence to procedure and function | | | | 12 | Create to trigger | | | | 13 | Data process related with group and data manipulation in different time area | | | | 14 | End of term assessment and studies about a project | | | | 15 | End of term assessment and studies about a project | | |
|
| Recommended or Required Reading |
| Course notes |
| Planned Learning Activities and Teaching Methods |
|
| Assessment Methods and Criteria | |
| Midterm Examination | 1 | 40 | | Individual Study for Mid term Examination | 15 | 60 | | SUM | 100 | |
| Final Examination | 1 | 60 | | Individual Study for Final Examination | 15 | 40 | | 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 | 4 | 56 |
| Brain Storming | 14 | 1 | 14 |
| Self Study | 14 | 2 | 28 |
| Individual Study for Mid term Examination | 6 | 2 | 12 |
| Individual Study for Final Examination | 6 | 3 | 18 |
| Homework | 6 | 2 | 12 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | 4 | | | | | 5 | | LO2 | | 4 | | | | | | LO3 | | | 5 | | 4 | | | LO4 | | | | 5 | | |
|
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
 |
| |