Course Language:
İngilizce
Course Objectives:
Instruction to relational database management systems. Students, while they’re programming in relational database management systems, they can complete execution, design and analyses phases.
Course Content:
Instruction to the basics of database management systems and E-R diagrams, logical and physical database designin, modelling restrictions, database arhitecture and relational database management SQL; questioning, DML, DCL, DDL operations, stored routines, triggers and the basics of application development.
Course Methodology:
1: Lecture, 2: Question-Answer, 3: Discussion, 4: Self-study, 5: Demonstration
Course Evaluation Methods:
A: Exam, B: Experiment C: Homework
Vertical Tabs
Course Learning Outcomes
| Learning Outcomes | Teaching Methods | Assessment Methods |
| To understand the concepts, components of the database management system. | 1, 2, 3 | A, B |
| Ability to make an ER diagram. | 1, 2, 3 | A, B, C |
| Converting conceptual database design into logical table design. | 1, 2, 4 | A, B, C |
| Execution of logical table design in database environment (by using SQL) | 1, 2, 4 | A, B, C |
| Making necessary queries and other processes by using SQL | 1, 2, 4 | A, B |
| Coding routines, functions and triggers by using SQL. | 1, 2, 4 | A, B, C |
| Building, operating database and using necessary tools to access. | 1, 2, 4 | A, B, C |
| Establishing database desing and development as a team for a certaing work. | 1, 2, 4 | A, B, C |
| Preparing necessary documantation and presentation for database projext and presenting. | A, B, C |
Course Flow
| Week | Topics | Study Materials |
| 1 | Database examples, advantages of database management systems | |
| 2 | General look to Access tools.(forms, reports, pages ) | |
| 3 | Creating a database, understanding the logic of using a database, creating a table, data types, descriptions and properties of the fields. | |
| 4 | Descriptions of the relations between tables.processes of import and export | |
| 5 | Creating query and form. | |
| 6 | Creating report and page. | |
| 7 | Creating macro and module. | |
| 8 | SQL; CREATE, ALTER TABLE, DROP TABLE | |
| 9 | Introduction to the data related operators; DESCRIBE, INSERT, SELECT, UPDATE, DELETE | |
| 10 | Operators; ORDER BY, DISTINCT | |
| 11 | Functions; SUM, AVG, MIN, MAX, COUNT | |
| 12 | Grouping GROUP BY, HAVING, JOIN | |
| 13 | Installing MySQL, using its interface, creating database, table, datatypes, descriptions and properties of the fields. | |
| 14 | Creating query and customizing queries, web based database applications. |
Recommended Sources
| Textbook | |
| Additional Resources | Database Systems: Design, Implementation, & Management - Carlos Coronel & Steven Morris |
Assessment
| IN-TERM STUDIES | NUMBER | PERCENTAGE |
| Mid-terms | 1 | 40 |
| Quizzes | 1 | 10 |
| Quizzes | 2 | 10 |
| Assignment | 1 | 20 |
| Oral Exam | 1 | 20 |
| Total | 100 | |
| CONTRIBUTION OF FINAL EXAMINATION TO OVERALL GRADE | 50 | |
| CONTRIBUTION OF IN-TERM STUDIES TO OVERALL GRADE | 50 | |
| Total | 100 |
| COURSE CATEGORY | Expertise/Field Courses |
Course’s Contribution to Program
| No | Program Learning Outcomes | Contribution | |||||
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | Know instructional technologies and materials and how to implement these in courses; take role in applications such as educational software, e-learning, distance education and support other people around in need. | X | |||||
| 2 | Use process of design, planning, implementation and managing educational technologies efficient; design and prepare needed products, changes and updates examining these processes. | X | |||||
| 3 | Organize suitable technology supported education environments taking individual, social, cultural differences of students into consideration and special interest and needs. | X | |||||
| 4 | Have efficient usage skill for information and communication technologies within and out instruction process. | X | |||||
| 5 | Design and develop technology supported instructional materials to fulfill instruction needs. | X | |||||
| 6 | Define needed software and input-output devices for set up optimum computer system. | X | |||||
| 7 | Plan, implement and manage learning-teaching process | X | |||||
| 8 | Develop and implement projects with knowing the processes of project development. | X | |||||
| 9 | Have information about computer software and hardware in level of teaching computer and information and communication technologies courses and supporting other teachers; use informatics and communication technologies (European Computer Driving License, Advanced Level). | X | |||||
| 10 | Have enough knowledge, skill and competence about teaching profession. | X | |||||
| 11 | Use current information communication technologies (software-hardware) and integrate them to learning-teaching processes. | X | |||||
| 12 | Have high level knowledge and can put in force learning teaching approaches, theories, strategies, methods and technics. | X | |||||
ECTS
| Activities | Quantity |
Duration (Hour) |
Total Workload (Hour) |
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 4 | 64 |
| Hours for off-the-classroom study (Pre-study, practice) | 24 | 3 | 72 |
| Mid-terms | 1 | 3 | 3 |
| Quizes | 2 | 2 | 4 |
| Homeworks | 1 | 5 | 5 |
| Oral Exam | 1 | 3 | 3 |
| Final examination | 1 | 3 | 3 |
| Total Work Load | 154 | ||
| Total Work Load / 25 (h) | 6,16 | ||
| ECTS Credit of the Course | 6 |