COURSE INFORMATION Course Title: DATABASE MANAGEMENT SYSTEMS

Code	Course Type	Regular Semester	Theory	Practice	Lab	Credits	ECTS
BINF 251	B	3	2	0	2	3	5

Academic staff member responsible for the design of the course syllabus (name, surname, academic title/scientific degree, email address and signature)	NA
Main Course Lecturer (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	Dr. Aida Bitri abitri@epoka.edu.al , Dr. Aida Bitri: E-203, Monday: 12:00-14:30, Tuesday 12:30-14:00, Wednesday 10:30-11:30//MSc. Ardita Dorti:Office Hours: E-301, Friday 13:15 - 16:15
Second Course Lecturer(s) (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	M.Sc. Ardita Dorti adorti@epoka.edu.al
Teaching Assistant(s) and Office Hours:	NA
Language:	English
Compulsory/Elective:	Compulsory
Study program: (the study for which this course is offered)	Bachelor in Business Informatics (3 years)
Classroom and Meeting Time:	BINF2B ( E214/14:40-16:30); BINF2A (E212/ 13:40-15:30); BINF2C ( E214/11:40-13:30);
Code of Ethics:	Code of Ethics of EPOKA University Regulation of EPOKA University "On Student Discipline"
Attendance Requirement:	75% Mandatory
Course Description:	Database design using entity-relationship model and relational data model, SQL (data definition and data manipulation languages), data integrity and integrity constraints, triggers, stored procedures, indexing and application development.
Course Objectives:	This course presents undergraduate business-informatics students with a wide field of data management, particularly database management systems. It covers a comprehensive coverage of database topics and prepares students to have a significant level of database expertise. This course equips students with the necessary knowledge on how to design, develop, implement, and maintain a database management system.

BASIC CONCEPTS OF THE COURSE

1	Database
2	Database Management System
3	Structured Query Language
4	Entity-Relationaship Diagram
5	Relational Schema
6	Star Schema
7	Operational Databases
8	Analytical Databases
9	Data Warehouse
10	NoSql Databases

COURSE OUTLINE

Week	Topics
1	Commencement of Course and Syllabus Overview, Group Project Kickoff, Initial Exploration of Key Database Concepts, Terminology, and Components, including discussions on data and information, management systems, and the development process of Database Management Systems (DBMS)
2	Gaining Insight into Entity-Relationship Modeling as a Conceptual Approach to Formalize User Database Needs. Emphasizing the Significance of ER Modeling in Gathering and Visualizing Requirements.
3	This chapter offers an extensive exploration of the relational database model, encompassing relational principles and relational schema
4	This chapter delivers an in-depth examination of the relational database model, encompassing relational concepts, integrity constraints, and user-defined constraints.
5	This chapter explains update operations and offers an in-depth discussion of normalization and update anomalies
6	In this chapter, we delve into the concepts of 2NF (Second Normal Form) and 3NF (Third Normal Form), also known as Normalization 2FN and Normalization 3FN, respectively.
7	This chapter offers an extensive exploration of Structured Query Language (SQL), encompassing SQL statements for creating, updating, and querying relational databases. It includes a list of commands such as SELECT, SUM, COUNT, AVG, MIN, MAX, GROUP BY, and more.
8	Mid-Term exam
9	This chapter offers a thorough examination of Structured Query Language (SQL), covering SQL statements for creating, updating, and querying relational databases. It also explores UNION and INTERSECT operations, the use of IN and EXISTS, and various types of joins
10	This chapter addresses data quality concerns, including accuracy, completeness, consistency, uniqueness, timeliness, data conformity, referential integrity, and the design and utilization of database front-end interfaces
11	This chapter provides an introduction to key terms and fundamental concepts related to data warehousing components
12	This chapter explores dimensional modeling, including topics such as dimension tables, star schema, snowflake schema, constellations, and its utility as a technique for modeling operational databases.
13	This chapter presents an introduction to NoSQL databases, defining and elucidating basic concepts
14	Project presentations

Prerequisite(s):	N/A
Textbook(s):	PPT Lecture Notes
Additional Literature:	1. Database Systems: Design, Implementation, and Management, Carlos Coronel, Steven Morris, 2023 2. Database Systems: Introduction to Databases and Data Warehouses by Nenad Jukic, Susan Vrbsky, and Svetlozar Nestorov; ISBN: 978-1-943153-18-3 3. The Creation and Management of Database Systems, Adele Kuzmiakova, 2023.
Laboratory Work:	Yes
Computer Usage:	Yes
Others:	No

COURSE LEARNING OUTCOMES

1	Students should be able to: Prepare e ER diagram for a specific organization.
2	Students should be able to translate any ER diagram to the relational schema
3	Students should be able to implement a DB using SQL codes
4	Students should be able to design and perpare star schema for analytical databases

COURSE CONTRIBUTION TO... PROGRAM COMPETENCIES (Blank : no contribution, 1: least contribution ... 5: highest contribution)

No	Program Competencies	Cont.
Bachelor in Business Informatics (3 years) Program
1	Identify activities, tasks, and skills in management, marketing, accounting, finance, and economics.	5
2	Apply key theories to practical problems within the global business context.	5
3	Demonstrate ethical, social, and legal responsibilities in organizations.	3
4	Develop an open minded-attitude through continuous learning and team-work.	5
5	Integrate different skills and approaches to be used in decision making and data management.	5
6	Combine computer skills with managerial skills, in the analysis of large amounts of data.	5
7	Provide solutions to complex information technology problems.	2
8	Recognize, analyze, and suggest various types of information-communication systems/services that are encountered in everyday life and in the business world.	4

COURSE EVALUATION METHOD

Method	Quantity	Percentage
Midterm Exam(s)	1	40
Final Exam	1	30
Other	1	30
	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	2.5	40
Mid-terms	1	3	3
Assignments	5	3	15
Final examination	1	3	3
Other			0
Total Work Load:			125
Total Work Load/25(h):			5
ECTS Credit of the Course:			5

CONCLUDING REMARKS BY THE COURSE LECTURER

Students should uphold the code of ethics in all academic endeavors. Cheating in any form is strictly prohibited. Please be aware that any misbehavior report will result in an automatic evaluation of zero points for the respective exam.