Databases and Web programming (DAT130)
This course introduces students to the most prominent technologies behind modern applications, Web programming, and database systems. The course includes principles and tools for data modeling, relational databases, SQL and tools, and the development of Web applications. Students will learn to develop a full-stack Web application for their final project.
Course description for study year 2025-2026. Please note that changes may occur.
Course code
DAT130
Version
1
Credits (ECTS)
10
Semester tution start
Spring
Number of semesters
1
Exam semester
Spring
Language of instruction
English
Content
The course focuses on the technical skills and design principles required to develop interactive applications, ranging from data-modeling and data storage to interactive Web-frontend. In particular, the course covers the following:
● Data modeling and database design
● SQL scripting
● Creating, structuring, and styling web pages using HTML and CSS
● Using event-driven programming in Javascript to provide dynamic interaction.
● Dynamically displaying content using AJAX
● Access control and input validation
Learning outcome
Knowledge:
- Describe what a relational database is and explain the basics of how a relational database works
- Compare and debate different database concepts
- Know about Client-server communication on the Web, W3C standards, accessing and manipulating data from a Web application
- Know about access control and input validation
Skills:
- Create a data model using ER diagrams
- Design a relational database based on a data model using standard methodology
- Design efficient SQL queries
- Design and implement a full-stack Web application
General competence:
- Design interactive systems that bring users a positive experience.
- Apply a database in a Web application
Required prerequisite knowledge
Recommended prerequisites
Exam
Project assignment with oral corrective hearing and written exam
| Form of assessment | Weight | Duration | Marks | Aid |
|---|---|---|---|---|
| Project assignment with oral corrective hearing | 6/10 | Letter grades | All | |
| Written exam | 4/10 | 2 Hours | Letter grades | None permitted |
Project:The project is done in groups of max. 2 students. The final delivery happens in the form of program code with documentation. If a student does not pass the project, the student must submit a new project the next time the course is lectured.The project must be presented orally. In the presentation students must show that their program works and explain their code. Submitted code that the student cannot explain, will count as not working. The oral presentation must happen in person at the assigned date. Students who do not participate in the presentation have to do a new project the next time the course is lectured.Written exam:2 hours digital exam. Multiple-choice.
Coursework requirements
Students must present and explain their group project in an oral presentation. The presentation has to be given in person at the assigned time. Students have to show understanding and knowledge of the delivered code. Students who do not get their presentation approved will not get a grade on their project and have to deliver a new project the next time the course is given.
Obligatory assignments in groups of at most two students. Assignments need to be delivered within the assigned time frame.
Course teacher(s)
Course teacher:
Petra GaluscakovaCourse coordinator:
Leander Nikolaus JehlHead of Department:
Tom RyenMethod of work
Overlapping courses
| Course | Reduction (SP) |
|---|---|
| Web Programming (DAT310_1) | 5 |
| Database Systems (DAT220_1) | 5 |