Databases
About
The course covers the basic principles of database systems as seen by users, application programmers and database administrators. A laboratory assignment develops these topics as a running example throughout the course. These include programming in SQL, as seen by a user querying or modifying an existing database, by a database designer,
and by an application programmer invoking SQL from a host language.
Course contents include:
- entity-relationship modeling
- functional dependencies and normalisation
- database querying and manipulation through SQL
- interfacing to a database from a host language (such as Java/JDBC)
- overview of non-SQL models (such as JSON or XML)
Prerequisites and selection
Entry requirements
To be eligible for the course the student must have successfully completed university level courses of at least 45 credits, including:
- at least 15 credits in programming, e.g., DIT440, DIT012, DIT953, or equivalent,
- at least 7.5 credits in mathematics or mathematic reasoning, e.g., DIT980, DIT855, or equivalent,
- concepts in logic, sets, functions and relations that could be acquired with, e.g., DIT980, DIT851, or equivalent.
Selection
Selection is based upon the number of credits from previous university studies, maximum 165 credits.