Databases is one of the topics ion project 2.

1.1. Data types for planning.

If you have an application, of which planning resource availability is a major part, you may want to consider the advice in this slideset: Efficient use of range types for e.g. appointment planning

1.2. Your (PostgreSQL) Database can do so much more

Markus Winand of Vienna Austria is an independent consultant and teacher with Databases as his major field of expertise. He has some views on what you can and should with a database in 2019.

More Than a Query Language: SQL in the 21st Century Markus Winand, Devoxx Antwerp November 2019

1.3. SEBI Pom and GitHub Workflows

Continuous integration with e.g. github is very nice to have in your project. So is sebipom, the basic pom file we use in our programming teaching. To make sebipom as parent pom accessible by github workflows, you need to add the fontysvenlo.org maven repository to the pom file. It is actually copying a part of the maven settings file to the pom file.

Make sure you maven.yml file is configured for Java 11, not the default, Java 8.

Typical pom file tweaked for github workflows
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <repositories> <!-- 1-- >
        <repository>
            <id>fontysvenlo.org</id>
            <url>https://www.fontysvenlo.org/repository</url>
        </repository>
    </repositories> <!-- 2 -->
    <parent>
        <groupId>nl.fontys.sebivenlo</groupId>
        <artifactId>sebipom</artifactId>
        <version>2.3.9</version>
        <relativePath/>
    </parent>
    <groupId>com.example</groupId>
    <artifactId>application</artifactId>
    <version>1.1</version>
    <packaging>jar</packaging>
    <name>application</name>
    <properties>
        <exec.mainClass>applicatie.Applicatie</exec.mainClass>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.jfxtras</groupId>
            <artifactId>jfxtras-labs</artifactId>
            <version>8.0-r6</version>
        </dependency>
        <dependency>
            <groupId>org.openjfx</groupId>
            <artifactId>javafx-base</artifactId>
            <version>11.0.2</version>
            <type>jar</type>
        </dependency>
        <dependency>
            <groupId>org.openjfx</groupId>
            <artifactId>javafx-fxml</artifactId>
            <version>11.0.2</version>
            <type>jar</type>
        </dependency>

    </dependencies>
</project>
1 begin and
2 end of what you need to add.

You can then run your project locally with mvn -P fx javafx:run and build it with continuous integration on github the usual way..