Computer Programming | |||||
Associate | TR-NQF-HE: Level 5 | QF-EHEA: Short Cycle | EQF-LLL: Level 5 |
Course Code: | BIL213 | ||||
Course Name: | Introduction to Database Systems | ||||
Semester: | Fall | ||||
Course Credits: |
|
||||
Language of instruction: | Turkish | ||||
Course Condition: | |||||
Does the Course Require Work Experience?: | No | ||||
Type of course: | Compulsory Courses | ||||
Course Level: |
|
||||
Mode of Delivery: | Face to face | ||||
Course Coordinator: | Öğr. Gör. AHMET SELİM ÖVER | ||||
Course Lecturer(s): | Öğr. Gör. Ahmet Selim Över | ||||
Course Assistants: |
Course Objectives: | This course aims to gain the competencies to write complex SQL queries, to design a database with the Entity Relationship diagrams, to create, manage and authorize database user privileges, to create and authorize advanced database objects such as View, Stored Procedure and Trigger for advanced database management, to provide data integrity with constraints, to manage concurrency with transactions and to reinforce all the topics and these competencies with hands-on applications. |
Course Content: | Complex SQL Queries, Logical Database Design, Entity Relationship Diagrams, Views, Functions and Stored Procedures, Triggers, Indexes, Transactions, Concurrency and Recovery, Constraints and Data Integrity, Authorization, User Roles and Privileges, Database Design and Development Practices |
The students who have succeeded in this course;
1) To write advanced queries with SQL 2) To design a database in logical view with ER(Entity-Relation) model 3) To create and manage a View 4) To create and manage a Stored Procedure 5) To create and manage a Trigger 6) To comprehend Transactions and to manage concurrency 7) To define roles, privileges and authorize users for different database objects 8) To ensure data integrity with Constraints 9) To enhance the performance of applications by using indexes and additional data objects suitable for the properties of the applications 10) To practice database design and development |
Week | Subject | Related Preparation |
1) | Introduction to Course, Overview of Database Management Systems and SQL | No prior preparation is required. |
2) | Advanced SQL Queries, Database Modification Operations | No prior preparation is required. |
3) | Logical Database Design, Entity Relationship Model and Diagrams | No prior preparation is required. |
4) | SQL Join Expressions, Views, Creating, Deleting, Altering Views | No prior preparation is required. |
5) | Transaction Management, Concurrency, Recovery | No prior preparation is required. |
6) | Veri Bütünlüğü ve Kısıtlamalar | No prior preparation is required. |
7) | Data Types and Schemas, Index Definition | No prior preparation is required. |
8) | Midterm | 1-7. Week Repeat |
9) | Creating a Function and a Stored Procedure, Calling a Stored Procedure with and without Parameters | No prior preparation is required. |
10) | Advanced Examples with Stored Procedure | No prior preparation is required. |
11) | Triggers, Advanced Aggregation Features | No prior preparation is required. |
12) | Authorization, Users, Roles, Privileges, View Authorization, Schema Authorization | No prior preparation is required. |
13) | Database Administration, Server and User Management Functions, Backup and Recovery Operations | No prior preparation is required. |
14) | Database Design and Application Development | No prior preparation is required. |
15) | Final | 1-14. Week Repeat |
Course Notes / Textbooks: | Lecture presentations and notes “Database System Concepts”, A. Silberschatz, H.F. Korth, S. Sudarshan, Mc Graw Hill |
References: | Lecture presentations and notes “Database System Concepts”, A. Silberschatz, H.F. Korth, S. Sudarshan, Mc Graw Hill |
Course Learning Outcomes | 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Program Outcomes | |||||||||||||
1) He gains the ability of problem solving and analytical thinking skills. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
2) He learns the fundamentals of computer programming, hardware and software and the basic computer concepts. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
3) He develops algorithms according to the problems, gains the ability to distinguish the appropriate ones from the fundamental algorithms for the problem. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
4) He understands object-oriented programming concept and web programming. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
5) He learns radix systems, fundamental electronics and computer hardware knowledge. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
6) He gains mobile programming skills and develops applications for mobile platforms. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
7) He designs and codes databases. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
8) He learns to program and use computer networks, open source operating systems. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
9) He uses the English language effectively. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
10) He learns to use appropriate data structures according to programming requirements. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
11) He develops software individually or as a team. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
12) He follows developments in the field, high technology tools / applications. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||
13) He gains awareness of professional and ethical responsibility and has an awareness of professional ethics. | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
No Effect | 1 Lowest | 2 Average | 3 Highest |
Program Outcomes | Level of Contribution | |
1) | He gains the ability of problem solving and analytical thinking skills. | 3 |
2) | He learns the fundamentals of computer programming, hardware and software and the basic computer concepts. | 3 |
3) | He develops algorithms according to the problems, gains the ability to distinguish the appropriate ones from the fundamental algorithms for the problem. | 3 |
4) | He understands object-oriented programming concept and web programming. | 3 |
5) | He learns radix systems, fundamental electronics and computer hardware knowledge. | 3 |
6) | He gains mobile programming skills and develops applications for mobile platforms. | 3 |
7) | He designs and codes databases. | 3 |
8) | He learns to program and use computer networks, open source operating systems. | 3 |
9) | He uses the English language effectively. | 3 |
10) | He learns to use appropriate data structures according to programming requirements. | 3 |
11) | He develops software individually or as a team. | 3 |
12) | He follows developments in the field, high technology tools / applications. | 3 |
13) | He gains awareness of professional and ethical responsibility and has an awareness of professional ethics. | 3 |
Semester Requirements | Number of Activities | Level of Contribution |
Homework Assignments | 1 | % 15 |
Midterms | 1 | % 35 |
Final | 1 | % 50 |
total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 50 | |
PERCENTAGE OF FINAL WORK | % 50 | |
total | % 100 |
Activities | Number of Activities | Preparation for the Activity | Spent for the Activity Itself | Completing the Activity Requirements | Workload | ||
Course Hours | 3 | 12 | 1 | 39 | |||
Homework Assignments | 1 | 25 | 1 | 26 | |||
Midterms | 1 | 30 | 1 | 31 | |||
Final | 1 | 35 | 1 | 36 | |||
Total Workload | 132 |