Data Modelling and Database Systems
Study plans 2016-2017 - IMT2571 - 10 ECTS

On the basis of

IMT1031 Fundamental Programming and IMT1082 Object-Oriented Programming, or IMT1241 Fundamental Programming in Java

Expected learning outcomes

After successful completion, the student is capable of describing:
•    database tasks and purpose in applications and computer systems
•    database management systems; their role and tasks
•    relational databases; their foundation and characteristics
•    other types of database management systems (NOSQL)
•    structuring and management of semi-structured data (XML)

After successful completion, the student posesses the skills to:
•    assess the use of relational database, NOSQL database, and XML in actual applications and computer systems
•    develop and evaluate functional and effective conceptual data models - and corresponding logcial, relational models - for real applications
•    construct relational database solutions - and select appropriate physical structure - based on the conceptual and logical models designed for the system
•    make use of SQL for inserting, querying, and modifying database data
•    develop applications that retrieves and stores data in databases
•    utilize XML technologies for storing and processing semi-structured data

The student has acquired general competency in:
•    developing abstract models and solutions for practical problems
•    assessing alternatives for storing and managing digital data
•    using computer tools for developing software systems

Topic(s)

•    Databases and database management systems
•    Introduction to conceptual data modelling
•    The relational model, relational algebra, and SQL
•    Database design
•    Database normalisation
•    Query processing
•    Data integrity
•    Transaction management
•    File organisations and indexes
•    Security
•    NOSQL databases
•    XML data, XML DOM, XPath og XML Schema
•    Data transformation

Teaching Methods

Lectures
Laboratory work
Mandatory assignments

Form(s) of Assessment

Written exam, 5 hours

Grading Scale

Alphabetical Scale, A(best) – F (fail)

External/internal examiner

Internal examiner. An external examiner will be involved in the examination at least every fifth year - next time no later than 2020.

Re-sit examination

Ordinary re-sit offered in August.

Coursework Requirements

5 out of 6 assignments must be passed.

Teaching Materials

•    T. Connolly & C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management. 5th Edition, Addison Wesley 2010
ISBN-10: 0-321-52306-7
•    Web resources (titles to be announced at the start of the course)

Additional information

Overlaps 90% with IMT2261