NDAB21010U Databases and Information Systems (DIS)
BSc Programme in Bioinformatics
BSc Programme in Computer Science and Economics
BSc Programme in Computer Science
BSc Programme in Machine Learning and Data Science
This course introduces students to basic database concepts such as relational databases, normal forms, and transactions. In addition, the course covers system development (basic software development) and version control and includes the practical development of a smaller system (web system, mobile system, or the like, which must be decided before the course starts) as project work. Formal languages and reading of structured text are also covered.
Knowledge of
- Key database technical concepts such as the relational model, data independence and transactions.
- Entity-relationship modeling (ER modeling) and relational data modeling, including transformations from ER modeling to relational data modeling.
- Queries in database query languages, including relational calculus, relational algebra, and SQL.
- The theory of database normalization, including functional dependencies, keys, and relational decompositions.
- ACID (atomicity, consistency, isolation, durability) properties and use of transactions.
- Indexing techniques and their role in database query optimization.
- Use of constraints and triggers.
- Facilities for connecting databases, programming environments, and program libraries.
- Methods for reading structured texts (i.e. regular expressions, finite automata, context-free grammars).
- Data protection regulation (GDPR)
Skills in
- Developing a data model and realizing database applications starting from the ER modeling, over relational modeling and normalization, to concrete relational, SQL-based database application.
- Planning and managing an agile, iterative, and learning-oriented system development process, which under given resource and time constraints leads to the realization of a new database application.
Competence in
- Developing a database design and implement database applications.
- Effectively participating in an agile software development process as part of a group of developers.
See Absalon when the course is set up.
Additionally, most of the contents of this course was covered in the discontinued courses "NDAB 16009U Udvikling af informationssystemer (UIS" and "NDAB 21002UData Science (DS)", so we advice against taking this course if you have passed either of those.
- Category
- Hours
- Lectures
- 28
- Preparation
- 78
- Exercises
- 14
- Project work
- 82
- Exam
- 4
- Total
- 206
As
an exchange, guest and credit student - click here!
Continuing Education - click here!
- Credit
- 7,5 ECTS
- Type of assessment
- On-site written exam, 4 hours under invigilation
- Type of assessment details
- The on-site written exam is an ITX exam.
See important information about ITX-exams at Study Information, menu point: Exams -> Exam types and rules -> Written on-site exams (ITX) - Exam registration requirements
1. The group project must be approved.
2. Two mandatory assignments, marked as pass/fail, must be passed.
- Aid
- Written aids allowed
Books, notes, printouts are allowed.
Books, notes, and similar materials can be brought in paper form or uploaded before the exam and accessed digitally from the ITX computer. Read more about this at Study Information.
- Marking scale
- 7-point grading scale
- Censorship form
- External censorship
- Re-exam
4-hour written test with written aids (as in the ordinary exam).
If there are 10 or fewer students registered, the re-exam will be changed to an oral exam (30 min. including voting) without preparation.
Exam registration requirements: Mandatory assignments and the project (possibly as an individual project) must be resubmitted and approved no later than 3 weeks before the re-examination date.
Criteria for exam assesment
See Learning Outcome.
Course information
- Language
- English
- Course code
- NDAB21010U
- Credit
- 7,5 ECTS
- Level
- Bachelor
- Duration
- 1 block
- Placement
- Block 4
- Schedule
- A
- Course capacity
- No limitation – unless you register in the late-registration period (BSc and MSc) or as a credit or single subject student.
Study board
- Study Board of Mathematics and Computer Science
Contracting department
- Department of Computer Science
Contracting faculty
- Faculty of Science
Course Coordinators
- Dmitriy Traytel (7-8684738b86777e52767b407d8740767d)