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