COURSE INFORMATION Course 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)	NA
Main Course Lecturer (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	M.Sc. Xhoena Duro xpolisi@epoka.edu.al , TBA
Second Course Lecturer(s) (name, surname, academic title/scientific degree, email address and signature) and Office Hours:	NA
Teaching Assistant(s) and Office Hours:	NA
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:	TBA
Code of Ethics:	Code of Ethics of EPOKA University Regulation of EPOKA University "On Student Discipline"
Attendance Requirement:	YES
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:	• CG1-Explain the role of databases and their impact in the organization • CG2-Design and use operational databases • CG3-Write queries using SQL • CG4-Design and use analytical databases

BASIC CONCEPTS OF THE COURSE

1	This course introduces the core principles and techniques required in the design and implementation of database systems.
2	This introductory application-oriented course covers the relational database systems RDBMS - the predominant system for business, scientific and engineering applications at present. I
3	It includes Entity-Relational model, Normalization, Relational model, Relational algebra, and data access queries as well as an introduction to SQL
4	It also provides students with theoretical knowledge and practical skills in the use of databases and database management systems in information technology applications.

COURSE OUTLINE

Week	Topics
1	Introduction, Syllabus, Course Schedule
2	Introduction to Databases and Data Warehouses. Introduction and applications of DBMS, Purpose of data base, Data, Independence, Database System architecture- Levels, Mappings, Database, users and DBA . CHAPTER 1
3	Conceptual Design : Database Design Process, ER Diagrams - Entities, Attributes, Relationships, Constraints, keys, extended ER features, Generalization, Specialization, Aggregation, Conceptual design with the E-Rmodel. CHAPTER 2
4	Conceptual Design: Database Design Process, ER Diagrams - Entities, Attributes, Relationships, Constraints, keys, extended ER features, Generalization, Specialization, Aggregation, Conceptual design with the E-Rmodel. CHAPTER 3
5	Logical Design: Introduction to the relational model, Integrity constraints over relations, Enforcing integrity constraints, Querying relational data, Logical database design: E-R to relational, Introduction to views, Destroying/altering tables and views. CHAPTER 3
6	Normalization: Introduction to schema refinement, functional dependencies, reasoning about FDs. Normal forms: 1NF, 2NF, 3NF, BCNF, properties of decompositions, normalization, schema refinement in database design, case studies. CHAPTER 4
7	Normalization: Introduction to schema refinement, functional dependencies, reasoning about FDs. Normal forms: 1NF, 2NF, 3NF, BCNF, properties of decompositions, normalization, schema refinement in database design, case studies. CHAPTER 4
8	SQL : Basics of SQL. All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW and all the statements end with a semicolon (;). CHAPTER 5
9	Midterm
10	Referential Integrity: Referential Integrity is a constraint in the database that enforces the relationship between two tables. The Referential Integrity constraint requires that values in a foreign key column must either be present in the primary key that is referenced by the foreign key or they must be null. CHAPTER 6
11	Introduction to Data Warehousing: A data warehouse is a database designed to enable business intelligence activities: it exists to help users understand and enhance their organization's performance. It is designed for query and analysis rather than for transaction processing, and usually contains historical data derived from transaction data, but can include data from other sources. Data warehouses separate analysis workload from transaction workload and enable an organization to consolidate data from several sources. CHAPTER 7
12	Introduction to Data Warehousing: A data warehouse is a database designed to enable business intelligence activities: it exists to help users understand and enhance their organization's performance. It is designed for query and analysis rather than for transaction processing, and usually contains historical data derived from transaction data, but can include data from other sources. Data warehouses separate analysis workload from transaction workload and enable an organization to consolidate data from several sources. CHAPTER 8
13	Introduction NoSQL Databases:NoSQL databases (aka "not only SQL") are non-tabular databases and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. The main types are document, key-value, wide-column, and graph. They provide flexible schemas and scale easily with large amounts of data and high user loads. APPENDIX 10
14	Review

Prerequisite(s):	none
Textbook(s):	Database Systems: Introduction to Databases and Data Warehouses by Nenad Jukic, Susan Vrbsky, and Svetlozar Nestorov; 2nd Edition, ISBN 978-1-943153-68-8
Additional Literature:
Laboratory Work:	2 Hours
Computer Usage:	web, MySQL
Others:	No

COURSE LEARNING OUTCOMES

1	• CG1-Explain the role of databases and their impact in the organization
2	• CG2-Design and use operational databases
3	• CG3-Write queries using SQL
4	• CG4-Design and use analytical databases

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.	4
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.	5
5	Ability of designing and conducting experiments, conduction data acquisition and analysis and making conclusions.	5
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.	3
8	Ability for effective oral and official communication skills in foreign language.	1
9	Engineering graduates with motivation to life-long learning and having known significance of continuous education beyond undergraduate studies for science and technology.	5
10	Engineering graduates with well-structured responsibilities in profession and ethics.	4
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.	3

COURSE EVALUATION METHOD

Method	Quantity	Percentage
Homework	1	5
Midterm Exam(s)	1	30
Project	1	20
Final Exam	1	40
Other	1	5
	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)	17	5.55	94.35
Mid-terms	1	2	2
Assignments	2	4	8
Final examination	1	2	2
Other	1	4.65	4.65
Total Work Load:			175
Total Work Load/25(h):			7
ECTS Credit of the Course:			7

CONCLUDING REMARKS BY THE COURSE LECTURER

TBA