The data will be stored in a relational database (RDBMS). Therefore, we need to define the tables and relations within the database.

The products table

The table “products” must only contain the unique id, which is also the primary key.

The "products" table

The "products" table

The names table

The table “names” must contain a column for the product id, one for the language code, and one for the name. Its primary key is the combination of the product id and the language code. All columns must not be null.

The "names" table

The "names" table

The relation to the products is realized by a foreign key constraint to the products table via the product id.

HTTP API

The HTTP API shall provide the following endpoints on the given paths:

Path HTTP Method Function

/products POST Create a product

/products GET Get all products and translations

/product/{UUID} PUT Update product

/product/{UUID} GET Get the specific product

The data shall be encoded in JSON using the following specifications: