Use SQL to create a relation for football players! Football players have a first and a last name, a birth date, a shirt number and a position, where they are playing. The position is restricted to following values: Goalkeeper, defence, forwards and midfield. Prepare two different solutions to check the value domain of the position attribute.
Name the table Player!
Hint:
This DBMS doesn't support the "Create Domain" command.
The validator doesn't check whether you have actually restricted the values. Use it to make sure your syntax doesn't produce a syntax error and that the rest of the task is fullfilled.