Databases

Code 765AA
Credits 6

Learning outcomes

The management of information is the main use of computers in organizations of all types and sizes. Information management is mostly based on data base technology. The aim of the course is to present the features of these systems, in particular the relational ones, their architecture and the principles they are inspired by, from the point of view of application designers

Syllabus:
• Data base and database management system. definition and functionalities
• Database design: conceptual modeling using the object-oriented data model
• The relational data model
• Mapping of conceptual schemas onto relational logical schema.
• The SQL language, with a special emphasis on the query sublanguage and its relationship with first order logic.
• Theory of relational database normalization
• Database implementation: access plans and transaction management
• NoSQL systems