- Recreate the tables previously created (PLAYER AND CLUB) with parameter delete and update cascade on clubid (PK). Run a delete and an update operation with values others that those in the PK of CLUB to see that it works
- Recreate the tables previously created (PLAYER AND CLUB) with parameter delete and update set_to_null on clubid (PK). Run a delete and an update operation with values others that those in the PK of CLUB to see that it works
- Recreate the tables previously created (PLAYER AND CLUB) with parameter delete and update default on the clubid. Run a delete and an update operation with values others that those in the PK of CLUB to see that it works.
- In the table “PLAYER” build a check constraint that limits the age of the player to 40 years old. You can modify the table or recreate the table with the check constraint.
- Build the query to create an index in the “last name” column of the player. Explain in your own words what the index does. Check the slides, ar any other external source.
follow the instruction and finish the excel powerpoint presentation about health system
Scroll to top
