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 approprirate physical structure - based on the conceptual and logical models designed for the system
• make use of SQL for inserting, querying, and modifying database data and to assess alternative SQL statements from an efficiency point of view
• 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.
The student has acquired a general understanding of alternatives for storing and managing digital data.
• 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
• NoSQL databases
• XML data, XML DOM, XPath og XML Schema
• Data transformation
Form(s) of Assessment
Written exam, 5 hours
Alphabetical Scale, A(best) – F (fail)
External and internal examiner assess all answers.
Ordinary re-sit offered.
6 out of 7 assignments must be passed.
• T. Connolly & C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management. 5th Edition, Addison Wesley 2010
• Web resources (titles to be announced at the start of the course)
Overlaps 90% with IMT2261