EPOKA UNIVERSITY
FACULTY OF ARCHITECTURE AND ENGINEERING
DEPARTMENT OF COMPUTER ENGINEERING
COURSE SYLLABUS
2024-2025 ACADEMIC YEAR
COURSE INFORMATIONCourse Title: DATABASE MANAGEMENT SYSTEMS |
Code | Course Type | Regular Semester | Theory | Practice | Lab | Credits | ECTS |
---|---|---|---|---|---|---|---|
CEN 203 | B | 3 | 3 | 1 | 1 | 4 | 7 |
Academic staff member responsible for the design of the course syllabus (name, surname, academic title/scientific degree, email address and signature) | Dr. Florenc Skuka fskuka@epoka.edu.al |
Main Course Lecturer (name, surname, academic title/scientific degree, email address and signature) and Office Hours: | M.Sc. Ari Gjerazi agjerazi@epoka.edu.al , Thursday 11:00-13:00 |
Second Course Lecturer(s) (name, surname, academic title/scientific degree, email address and signature) and Office Hours: | M.Sc. Andia Tafa atafa@epoka.edu.al |
Language: | English |
Compulsory/Elective: | Compulsory |
Study program: (the study for which this course is offered) | Bachelor in Software Engineering (3 years) |
Classroom and Meeting Time: | - |
Teaching Assistant(s) and Office Hours: | NA |
Code of Ethics: |
Code of Ethics of EPOKA University Regulation of EPOKA University "On Student Discipline" |
Attendance Requirement: | |
Course Description: | This course aims to provide an introduction to the design and use of database systems. It includes a knowledge over the ER modeling and their use to create proper database tables in relational form, SQL coding techniques for DDL and DML, relational algebra, normalization techniques, as well as the key issues in building database management systems, and working with multiple database systems. |
Course Objectives: | The objective of this course is to provide an introduction to the design and use of database systems. It includes a knowledge over the ER modeling and their use to create proper database tables in relational form, SQL coding techniques for DDL and DML, relational algebra, normalization techniques, as well as the key issues in building database management systems, and working with multiple database systems. |
BASIC CONCEPTS OF THE COURSE
|
1 | Understanding the Relational DB model |
2 | Understanding Entity-Relationship Diagrams and Relational Schemas |
3 | Mapping out an ER model out of a prompt. |
4 | Mastery of SQL. |
5 | Understanding of analytical databases (data warehouses) and building of the star schema. |
COURSE OUTLINE
|
Week | Topics |
1 | Introduction to DB concept |
2 | Data models and ER Model |
3 | ER Model |
4 | Relational Schema |
5 | Normalization |
6 | SQL Basics |
7 | Midterm |
8 | SQL Topics |
9 | SQL Topics 2 |
10 | Integrity Constraints |
11 | Integrity Constraints 2 |
12 | Data Warehousing |
13 | Star Schema |
14 | Other Topics in DB |
Prerequisite(s): | CEN 109 - Introduction to Algorithms and Programming |
Textbook(s): | Database Systems: Introduction to Databases and Data Warehouses Edition 2.0 By Nenad Jukić, Susan Vrbsky, Svetlozar Nestorov, and Abhishek Sharma |
Additional Literature: | |
Laboratory Work: | Yes |
Computer Usage: | Yes |
Others: | No |
COURSE LEARNING OUTCOMES
|
1 | Learn the concepts of Relational Database Systems |
2 | Analyze database requirements and develop logically the design of database |
3 | Model a database through ER Modeling |
4 | Implement a database through DDL instruction (sql) |
5 | Interact with the database through DML instruction (queries) |
6 | Evaluate and normalize a database |
7 | Make use of assertions, views, procedures and functions |
COURSE CONTRIBUTION TO... PROGRAM COMPETENCIES
(Blank : no contribution, 1: least contribution ... 5: highest contribution) |
No | Program Competencies | Cont. |
Bachelor in Software Engineering (3 years) Program | ||
1 | Engineering graduates with sufficient theoretical and practical background for a successful profession and with application skills of fundamental scientific knowledge in the engineering practice. | 5 |
2 | Engineering graduates with skills and professional background in describing, formulating, modeling and analyzing the engineering problem, with a consideration for appropriate analytical solutions in all necessary situations | 5 |
3 | Engineering graduates with the necessary technical, academic and practical knowledge and application confidence in the design and assessment of machines or mechanical systems or industrial processes with considerations of productivity, feasibility and environmental and social aspects. | 3 |
4 | Engineering graduates with the practice of selecting and using appropriate technical and engineering tools in engineering problems, and ability of effective usage of information science technologies. | 4 |
5 | Ability of designing and conducting experiments, conduction data acquisition and analysis and making conclusions. | 3 |
6 | Ability of identifying the potential resources for information or knowledge regarding a given engineering issue. | 4 |
7 | The abilities and performance to participate multi-disciplinary groups together with the effective oral and official communication skills and personal confidence. | 4 |
8 | Ability for effective oral and official communication skills in foreign language. | 4 |
9 | Engineering graduates with motivation to life-long learning and having known significance of continuous education beyond undergraduate studies for science and technology. | 4 |
10 | Engineering graduates with well-structured responsibilities in profession and ethics. | 5 |
11 | Engineering graduates who are aware of the importance of safety and healthiness in the project management, workshop environment as well as related legal issues. | 3 |
12 | Consciousness for the results and effects of engineering solutions on the society and universe, awareness for the developmental considerations with contemporary problems of humanity. | 5 |
COURSE EVALUATION METHOD
|
Method | Quantity | Percentage |
Project |
1
|
35
|
Final Exam |
1
|
55
|
Attendance |
10
|
|
Total Percent: | 100% |
ECTS (ALLOCATED BASED ON STUDENT WORKLOAD)
|
Activities | Quantity | Duration(Hours) | Total Workload(Hours) |
Course Duration (Including the exam week: 16x Total course hours) | 16 | 4 | 64 |
Hours for off-the-classroom study (Pre-study, practice) | 16 | 3 | 48 |
Mid-terms | 0 | 0 | 0 |
Assignments | 5 | 5 | 25 |
Final examination | 1 | 14 | 14 |
Other | 1 | 24 | 24 |
Total Work Load:
|
175 | ||
Total Work Load/25(h):
|
7 | ||
ECTS Credit of the Course:
|
7 |
CONCLUDING REMARKS BY THE COURSE LECTURER
|
N/A |