An incorrect database name on the server will disqualify the task. $(148\mathrm{.}81\mathrm{.}196\mathrm{.}51\backslash$LABSQLSVR$01,50067).$

Create a database named E$2\_$grup$\_$ID

ID is your ID at the university

The task is valid when executed on SQL server.

Tasks

$1.(5$ points$)$ Create foreign keys in tables,

then find in the database $($Upload data from data$\_2024\_$May.txt$)$:

the pair of products that generated the most revenue by the seller with the ID $($ID is your ID in the

university$).$ The solution is a view called sell$\_$ID $($ID your number$).$ It should look like

Product A Product B Number of products ID Value

$2.(3$ points$)$ Your data is in the salesman table.

Check if your data is in the seller table, else use id$=121212$

The table is in relation to the product table.

Who sold the same products $($at least one product$)$ with You in in November $2022?$

The solution is a procedure sellers with default parameter $($your ID$)$

$3.(3$ points$)$ Create a tables as shown in the figure and write a trigger that records insert and delete

changes to the product table.

Prepare a script with the solution and save it in a file $($ID$\_$student$\_$surname$\_$name.TXT$)$ with the TXT

extension.

Place the file on the Platon platform in: Training path elements $-$ Introduction to Database Lab exam$\_2$