Faculty: Faculty of Engineering
Department(s): Computer Engineering
Number of Students:
Course: Implementation of Database Management Systems
Weekly hours: Theory: 2 Exercises: 3
ECTS Credits: 8
Semester: Fall
Lecture Schedules:
Lecturer: Dr. Hiqmet Kamberaj
Room Number:
Phone Number of the lecturer:
E-mail address of the lecturer: km.ude.ubi|jarebmakh#km.ude.ubi|jarebmakh
**Course Objectives: **
The aim of the course is to give a detailed implementation of the database management systems.
| Skill outcomes | Necessary ( + ) Not Necessary ( –) |
|---|---|
| Written communication skills | + |
| Oral communication skills | + |
| Computer skills | + |
| Working in laboratory | + |
| Working team | + |
| Preparing projects | + |
| Knowledge of foreign language | + |
| Scientific and professional literature analysis | + |
| Problem solving skills | + |
| Management skills | + |
| Presentation skills | + |
Course Textbooks:
- H. Kamberaj, Lecture Notes in Implementation of Database Management Systems, International Balkan University, 2022.
Study Plan —- International Balkan University - Academic Calendar
| Weeks | Topics |
|---|---|
| 1 | Introduction. Conceptual data modeling and entity relationships. |
| 2 | Conceptual relationships and logical database design. |
| 3 | Oracle SQL. |
| 4 | Working with Oracle SQL. |
| 5 | Subqueries and Creating Pages & Reports. |
| 6 | Graph databases. |
| 7 | Data modeling and graphs. |
| 8 | Queries with Graph Databases. |
| 9 | Building a Graph Database Application. |
| 10 | Clustering and Performance. |
| 11 | Preparatory week. |
| 12 | Final exam week. |
| 13 | Preparatory week. |
| 14 | Preparatory week. |
| 15 | Make up 1 Exam. |
| In September | Make up 2 Exam. |
Attendance
Students are obliged to attend at least 60% of lectures.
Exams
- Achieved success in a course shall be evaluated through a final exam and seminar work.
- The topic of the seminar work for each course shall be chosen in the first two weeks of the lecture. The seminar work shall be delivered at the last (10th) week of the lecture. It shall consist of 7,500-10,000 words (tables, graphs are excluded).
- The maximum number of credit points (a) for the final exam is 60% (b) for seminar work is 40% of the total number of points.
- The student who has not passed the exam may enter exam 2 (two) more times during the make-up exam sessions.
Student workload:
Please calculate the “Total Student Workload” and then distribute that figure to the different engagements. For calculating the Total Student Work Load we multiply the course ECTS credits with standard figure 30. (ECTS Credit: 8) x 30 = 240 hours.
| Activities | Hours |
|---|---|
| Lecture hours for 10 weeks: | 20 |
| Laboratory and class exercises for 10 weeks: | 30 |
| Student Mentoring for 10 weeks: | 30 |
| Consultation for 10 weeks: | 20 |
| Exam preparations and exam hours (final, Makeup): | 40 |
| Individual reading work for 10 weeks (Reading assignments/expectations for reading and comprehension is 5 pages per hour. Example: If a book 300 pages, total Individual reading work for 10 weeks 300:5 = 60 hours. | 60 |
| Homework and work practice for 10 weeks: | 40 |
| Preparation of diploma work, for 10 weeks: | - |