ANTALYA BİLİM
UNIVERSITY
Course Information Package
| Code | Description |
|---|---|
| LO1 | Review the Relational Database Management Systems |
| LO2 | Apply relational database technology to a specific application domain |
| LO3 | Obtain a hands-on experience on the standard and non-standard features of a relational database management system |
| LO4 | Learn and experience with active/behavioral components of a relational database management system including triggers, functions, stored procedures |
| Week | Content |
|---|---|
| 1 | Review of Database Management Systems |
| 2 | Review of Database Management Systems |
| 3 | Preparation, Installation and Configuration of an RDBMS. Creation, deletion of a database |
| 4 | Creation/deletion/modification of relations, tuples within relations. |
| 5 | Specification of Constraints |
| 6 | Querying – SQL SELECT |
| 7 | Querying – SQL SELECT |
| 8 | Querying – JOINs, Subqueries, Set Operators |
| 9 | Querying – JOINs, Subqueries, Set Operators |
| 10 | Functions |
| 11 | Stored Procedures |
| 12 | Indexes and Views |
| 13 | Triggers |
| 14 | Transactions, Cursors |
| Activity | Count | Duration (Hours) | Total |
|---|---|---|---|
| Attendance | 14 | 2.00 | 28.00 |
| Practice | 10 | 1.00 | 10.00 |
| Pre-Class Individual Study | 14 | 2.00 | 28.00 |
| Midterm Exam/Preparation | 1 | 8.00 | 8.00 |
| Final Exam/Preparation | 1 | 8.00 | 8.00 |
| Homework | 10 | 4.00 | 40.00 |
| Other | 14 | 0.50 | 7.00 |
| Total Workload (Hours) | 129 | ||
| ECTS Credit (Workload / 25) | 5 | ||
| # | Assessment Type | Contribution (%) |
|---|---|---|
| 1 | Practice | %15 |
| 2 | Project | %15 |
| 3 | Midterm Exam | %25 |
| 4 | Final Exam | %45 |
| TOTAL | %100 | |
| PO \ LO |
LO1
|
LO2
|
LO3
|
LO4
|
|---|---|---|---|---|
| PO-1 | ||||
| PO-2 | ||||
| PO-3 | ||||
| PO-4 | ||||
| PO-5 | ||||
| PO-6 | ||||
| PO-7 | ||||
| PO-8 | ||||
| PO-9 | ||||
| PO-10 | ||||
| PO-11 |
| # | Method Name | Description | Tools |
|---|---|---|---|
| 1 | Lecture (expository teaching), interactive discussion | Listening and taking notes. | Standard classroom technologies, multimedia tools (projector, computer, digital presentations) |
| 2 | Laboratory | Listening, note-taking, conceptual analysis, critical thinking, questioning, and participation in discussions. | Special equipment |
| 3 | Homework | Solving and analyzing homework questions using a computer and Excel. | Computer |
