BBS653 - DATABASE DESIGN and MANAGEMENT
| Course Name | Code | Semester | Theory (hours/week) |
Application (hours/week) |
Credit | ECTS |
|---|---|---|---|---|---|---|
| DATABASE DESIGN and MANAGEMENT | BBS653 | Any Semester/Year | 3 | 0 | 3 | 6 |
| Prequisites | None | |||||
| Course language | Turkish | |||||
| Course type | Elective | |||||
| Mode of Delivery | Face-to-Face | |||||
| Learning and teaching strategies | Lecture Problem Solving Project Design/Management | |||||
| Instructor (s) | Prof. Dr. Hayri Sever, Yrd. Doç. Dr. Nazlı İkizler Cinbiş | |||||
| Course objective | To teach principles of database design and management. | |||||
| Learning outcomes |
| |||||
| Course Content | Design and Definition of Databases, Controlling Database Access:Users, User Rights and Roles, Monitoring Database Systems, Distributed Database Systems, Query Optimization and Processing, Transaction Processing, Concurrency Control. | |||||
| References | ? Database Management Systems, by Raghu Ramakrishnan and Johannes Gehrke, 3rd Edition, 2002 ? Database Systems, The Complete Book, by H. Garcia Molina, J. Ullman, J Widom | |||||
Course outline weekly
| Weeks | Topics |
|---|---|
| Week 1 | Introduction |
| Week 2 | Design and Definition of Databases |
| Week 3 | Design and Definition of Databases |
| Week 4 | Controlling Database Access |
| Week 5 | Users, User Rights and Roles |
| Week 6 | Monitoring Database Systems |
| Week 7 | Monitoring Database Systems |
| Week 8 | Midterm |
| Week 9 | Distributed Database Systems |
| Week 10 | Query Optimization and Processing |
| Week 11 | Query Optimization and Processing |
| Week 12 | Transaction Processing |
| Week 13 | Concurrency Control |
| Week 14 | Concurrency Control |
| Week 15 | Preparation to final exam |
| Week 16 | Final Exam |
Assesment methods
| Course activities | Number | Percentage |
|---|---|---|
| Attendance | 0 | 0 |
| Laboratory | 0 | 0 |
| Application | 0 | 0 |
| Field activities | 0 | 0 |
| Specific practical training | 0 | 0 |
| Assignments | 0 | 0 |
| Presentation | 0 | 0 |
| Project | 1 | 20 |
| Seminar | 0 | 0 |
| Midterms | 1 | 30 |
| Final exam | 1 | 50 |
| Total | 100 | |
| Percentage of semester activities contributing grade succes | 2 | 50 |
| Percentage of final exam contributing grade succes | 1 | 50 |
| Total | 100 | |
WORKLOAD AND ECTS CALCULATION
| Activities | Number | Duration (hour) | Total Work Load |
|---|---|---|---|
| Course Duration (x14) | 14 | 3 | 42 |
| Laboratory | 0 | 0 | 0 |
| Application | 0 | 0 | 0 |
| Specific practical training | 0 | 0 | 0 |
| Field activities | 0 | 0 | 0 |
| Study Hours Out of Class (Preliminary work, reinforcement, ect) | 11 | 3 | 33 |
| Presentation / Seminar Preparation | 0 | 0 | 0 |
| Project | 1 | 50 | 50 |
| Homework assignment | 0 | 0 | 0 |
| Midterms (Study duration) | 1 | 25 | 25 |
| Final Exam (Study duration) | 1 | 30 | 30 |
| Total Workload | 28 | 111 | 180 |
Matrix Of The Course Learning Outcomes Versus Program Outcomes
| D.9. Key Learning Outcomes | Contrubition level* | ||||
|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |
| 1. Has detailed knowledge about Information Systems (IS). | X | ||||
| 2. Understands the interaction of theory and practice and the links between them. | X | ||||
| 3. Has a good understanding of common concepts such as abstraction, complexity, security, concurrency, software lifecycle and applies their expertise to the effective design, development and management of IS. | X | ||||
| 4. Has the ability to think at different levels of abstraction and detail; understands that an IS can be considered in different contexts, going beyond narrowly identifying implementation issues. | X | ||||
| 5. Solves any technical or scientific problem independently and presents the best possible solution; has the communication skills to clearly explain the completeness and assumptions of their solution. | X | ||||
| 6. Completes a project on a larger scale than an ordinary course project in order to acquire the skills necessary to work efficiently in a team. | X | ||||
| 7. Recognises that the field of informatics is rapidly evolving. Follows the latest developments, learns and develops skills throughout their career. | X | ||||
| 8. Recognises the social, legal, ethical and cultural issues related to informatics practice and conduct professional activities in accordance with these issues. | X | ||||
| 9. Can make oral presentations in English and Turkish to different audiences face-to-face, in writing or electronically. | X | ||||
| 10. Recognises that informatics has a wide range of applications and opportunities. | X | ||||
| 11. Is aware that informatics interacts with different fields, can communicate with experts from different fields and can learn necessary field knowledge from them. | X | ||||
| 12. Define a research problem and use scientific methods to solve it. | X | ||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest