Faculty of Engineering and Natural Sciences · Computer Engineering · Undergraduate
Course Objective
This course is aimed at presenting basic information about a student database systems that will be computer or software engineer. Derste, relational data model, and entropy data model as a design tool are extensively discussed. Functional and multi-valued dependencies are processed in detail in the normalization process so that relational database schema design can be done. System components such as SQL database language and SQL query language, such as process management, indexing, constraints, triggers and authorization, are studied in detail with laboratory applications showing different methods of database programming.
Course Content
Definitions and basic concepts, using entity-correlation-model, logical model, SQL
Required Resources
Lecture Notes
Core Area Distribution
Teaching Methods
Assessment & Evaluation
ECTS / Workload
| Activity | Quantity | Duration (h) | Total Workload |
|---|---|---|---|
| Course Duration (Including Exam Week) | 16 | 4 | 64 |
| Out of Class Study Period | 6 | 3 | 18 |
| Midterm | 1 | 2 | 2 |
| Quiz | 2 | 2 | 4 |
| Assignment | 4 | 8 | 32 |
| Practice | 2 | 20 | 40 |
| Final | 1 | 3 | 3 |
Course Schedule
| Week | Subject | Preparation |
|---|---|---|
| 1 | Database Design, Database Normalization | Lecture Notes |
| 2 | What is Entity-Relationship (E-R) Diagram? Entity-Relationship Types and Relationships | Lecture Notes |
| 3 | Constraints | Lecture Notes |
| 4 | Basic SQL Operations: Create, Alter, Drop | Lecture Notes |
| 5 | Basic SQL Operations: Select, Where, Like | Lecture Notes |
| 6 | Basic SQL Transactions: Order By, Having, Group By | Lecture Notes |
| 7 | Temel Sql İşlemleri: Insert, Update, Delete | Lecture Notes |
| 8 | Midterm Exam | * |
| 9 | Basic Sql Operations: Join, Inner Join, Left Join, Right Join | Lecture Notes |
| 10 | Basic SQL Operations: Grant, Access | Lecture Notes |
| 11 | Functions | Lecture Notes |
| 12 | Views | Lecture Notes |
| 13 | Stored Procedure | Lecture Notes |
| 14 | Triggers | Lecture Notes |
| 15 | Transaction - Indexing | Lecture Notes |
| 16 | Final Exam | * |