ISTANBUL OKAN UNIVERSITY INFORMATION PACKAGE / COURSE CATALOGUE
| Computer Engineering (English) | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
General course introduction information
| Course Code: | CENG371 | ||||||||
| Course Name: | File Organization And Management | ||||||||
| Course Semester: |
Fall |
||||||||
| Course Credits: |
|
||||||||
| Language of instruction: | EN | ||||||||
| Course Requisites: | |||||||||
| Does the Course Require Work Experience?: | No | ||||||||
| Type of course: | Department Elective | ||||||||
| Course Level: |
|
||||||||
| Mode of Delivery: | Face to face | ||||||||
| Course Coordinator : | Prof. Dr. PINAR YILDIRIM | ||||||||
| Course Lecturer(s): | |||||||||
| Course Assistants: |
Course Objective and Content
| Course Objectives: | The aim of this course is to give the students the practical concepts of the design and usage of file structures, to provide them with the secondary memory structure, basic information about the processing of file data, and the secondary memory framework. |
| Course Content: | The content of this course, introduction to file structures, design and determination of file structures, basic file concepts, basic file operations, data definition and types, related data and unrelated data, record definition, storage in file, access methods, physical structure and characteristics of data storage media . second memory structure and processing of file data, files (advantages and disadvantages), file structures and types: first file organization file structures and types: distribution methods, index structures and types in files, memory operations, relationships with data structures, algebra relations, mathematics relationships with logic, sequential and direct file organization, file sorting methods, file organization for performance, quick access to records, indexing, indexed serial file access. Hashing, tree-structured file organization, tree index structures and protection of these structures, computational addressing techniques for static and expandable files, computational addressing techniques for static and expandable files, file conversion and creation of multi-linked list structures and introduction to database management systems covers. |
Learning Outcomes
The students who have succeeded in this course;
|
||||||||||||||||||||||||||||||||
Lesson Plan
| Week | Subject | Related Preparation |
| 1) | Introduction to file structures, design and determination of file structures, basic file concepts, basic file operations. | Read related chapter |
| 2) | Data definition and types, related data and unrelated data, record definition and storage in the file. | Read related chapter |
| 3) | Access Methods, Physical structure and characteristics of data storage media. | Read related chapter |
| 4) | Secondary memory structure and processing of file data. | Read related chapter |
| 5) | Files (advantages and disadvantages), file structures and types: first file organization. | Read related chapter |
| 6) | File structures and types: distribution methods, index structures and types in files. | Read related chapter |
| 7) | Memory operations, relationships with data structures, algebra relations, relations with higher mathematics and math logic. | Read related chapter |
| 8) | Midterm | None |
| 9) | Sequential and direct file organization, file sorting methods. | Read related chapter |
| 10) | Quick access to records, indexing, indexed serial file access, hashing. | Read related chapter |
| 11) | Tree structure file organization. | Read related chapter |
| 12) | Tree index structures and protection of these structures, computational addressing techniques for static and expandable files. | Read related chapter |
| 13) | Computational addressing techniques for static and expandable files. | Read related chapter |
| 14) | Creating and developing file conversion and multi-linked list structures. | Read related chapter |
| 15) | Final Exam | None |
Sources
| Course Notes / Textbooks: | Zoellick, B. & Riccardi, G. Addison , File Structures, Folk, M.J., Wesley, 1998. |
| References: | Tharp, A.L., . File Organization and Processing, John Wiley & Sons, 1988. |
Course-Program Learning Outcome Relationship
| Learning Outcomes | 1 |
|||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Program Outcomes | ||||||||||
| 1) Sufficient knowledge in mathematics, science and engineering related to their branches; the ability to apply theoretical and practical knowledge in these areas to model and solve engineering problems. | ||||||||||
| 2) The ability to identify, formulate, and solve complex engineering problems; selecting and applying appropriate analysis and modeling methods for this purpose. | ||||||||||
| 3) The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose. (Realistic constraints and conditions include such issues as economy, environmental issues, sustainability, manufacturability, ethics, health, safety, social and political issues, according to the nature of design.) | ||||||||||
| 4) Ability to develop, select and use modern techniques and tools necessary for engineering applications; ability to use information technologies effectively. | ||||||||||
| 5) Ability to design experiments, conduct experiments, collect data, analyze and interpret results for examination of engineering problems. | ||||||||||
| 6) The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill. | ||||||||||
| 7) Effective communication skills in oral and written communication; at least one foreign language knowledge. | ||||||||||
| 8) Awareness of the need for lifelong learning; access to knowledge, ability to follow developments in science and technology, and constant self-renewal. | ||||||||||
| 9) Professional and ethical responsibility. | ||||||||||
| 10) Information on project management and practices in business life such as risk management and change management; awareness about entrepreneurship, innovation and sustainable development. | ||||||||||
| 11) Information on the effects of engineering applications on health, environment and safety in the universal and social dimensions and the problems of the times; awareness of the legal consequences of engineering solutions. | ||||||||||
Course - Learning Outcome Relationship
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Sufficient knowledge in mathematics, science and engineering related to their branches; the ability to apply theoretical and practical knowledge in these areas to model and solve engineering problems. | |
| 2) | The ability to identify, formulate, and solve complex engineering problems; selecting and applying appropriate analysis and modeling methods for this purpose. | |
| 3) | The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose. (Realistic constraints and conditions include such issues as economy, environmental issues, sustainability, manufacturability, ethics, health, safety, social and political issues, according to the nature of design.) | |
| 4) | Ability to develop, select and use modern techniques and tools necessary for engineering applications; ability to use information technologies effectively. | |
| 5) | Ability to design experiments, conduct experiments, collect data, analyze and interpret results for examination of engineering problems. | |
| 6) | The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill. | |
| 7) | Effective communication skills in oral and written communication; at least one foreign language knowledge. | |
| 8) | Awareness of the need for lifelong learning; access to knowledge, ability to follow developments in science and technology, and constant self-renewal. | |
| 9) | Professional and ethical responsibility. | |
| 10) | Information on project management and practices in business life such as risk management and change management; awareness about entrepreneurship, innovation and sustainable development. | |
| 11) | Information on the effects of engineering applications on health, environment and safety in the universal and social dimensions and the problems of the times; awareness of the legal consequences of engineering solutions. |
Learning Activity and Teaching Methods
| Expression | |
| Lesson | |
| Reading | |
| Web Based Learning |
Assessment & Grading Methods and Criteria
| Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
| Individual Project |
Assessment & Grading
| Semester Requirements | Number of Activities | Level of Contribution |
| Project | 1 | % 20 |
| Midterms | 1 | % 30 |
| Final | 1 | % 50 |
| total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 50 | |
| PERCENTAGE OF FINAL WORK | % 50 | |
| total | % 100 | |
Workload and ECTS Credit Grading
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 14 | 3 | 42 |
| Project | 1 | 50 | 50 |
| Midterms | 1 | 50 | 50 |
| Final | 1 | 60 | 60 |
| Total Workload | 202 | ||