Course INFO 201 · Year II · Autumn 2024-2025

DATABASES

Compulsory course in Computer Science, taught by Maria Viorela Muntean.

This course page is from 2024-2025 and is archived.
See this course for the current academic year

Overview

Lecturer
Maria Viorela Muntean
Seminar tutor
Maria Viorela Muntean
Type of course
Compulsory
Language of instruction
Romanian
Erasmus language
English
Domain
Computer Science
Field of study
Computer Science
Form of education
Full-time
Form of instruction
Class
Credit awarded by
Grade
Teaching methods
Lecture, conversation, exemplification
Entry requirements
-

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 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

Learning outcomes

Minimum performance standard: minimum 5 at each evaluation criteria

Assessment

Written paper 50%Laboratory activities portfolio 50%

Recommended reading

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