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