DATABASES

Course Code: CSE 201 • Study year: II • Academic Year: 2024-2025
Domain: Computer Science • Field of study: Computer Science (in English)
Type of course: Compulsory
Language of instruction: English
Erasmus Language of instruction: English
Name of lecturer: Maria Viorela Muntean
Seminar tutor: Maria Viorela Muntean
Form of education Full-time
Form of instruction: Class
Number of teaching hours per semester: 56
Number of teaching hours per week: 2
Semester: Autumn
Form of receiving a credit for a course: Grade
Number of ECTS credits allocated 5

Course aims:

The identification of base concept for organizing data in databases.
The identification and explanation of base models for the organizing and management of data in databases.
The use of methodologies and database design environments for specific problems.
The evaluation of quality for various database management systems regarding structure, functionality and extensibility.
The development of various database related projects.

Course Entry Requirements:

-

Course contents:

1. Database architecture 2. Data models 3. Relational databases 4. Relational algebra 5. Relational keys 6. Database normalization. First Normal Form 7. Database normalization. Second Normal Form 8. Database normalization. Third Normal Form 9. Select SQL 10. Relational database schemes 11. Conceptual design of databases 12. Logical database design

Teaching methods:

Lecture, conversation, exemplification

Learning outcomes:

Minimum performance standard: minimum 5 at each evaluation criteria

Learning outcomes verification and assessment criteria:

Written paper 50% Laboratory activities portfolio 50%

Recommended reading:

Weinberg, P., Groff, J., Oppel, A., SQL The Complete Reference, Third Edition, ISBN: 978-0-07-159255-0, The McGraw-Hill Companies, Inc., -, 2010, -.
Schneider, R., D., MySQL Database Design and Tuning, ISBN: 0-672-32765-1, Sams Publishing, -, 2005, -.
Date, C., J., SQL and Relational Theory, 1st Edition, ISBN: 978-0-596-52306-0, O'Reilly Media, Inc., -, 2009, -.
Saeed K. Rahimi, Frank S. Haug, Distributed Database Management Systems: A Practical Approach, Hoboken, New Jersey: Wiley Publishing INC, -, 2010, -.
Kroenke, David M, Database Processing: Fundamentals, Design & Implementation, New Jersey: Prentice Hall, -, 2000, -.