Write an Oracle PL/SQL stored procedure named TransferPlayer with the following input parameters:

- p_PlayerID — identifier of the player to transfer.

- p_NewTeamID — identifier of the destination team.

Requirements:

1. Verify that the player exists in the Players table.

2. Verify that the destination team exists in the Teams table.

3. Update the player's TeamID to the new team ID if all validations pass.

4. Raise a meaningful application error if the player or destination team does not exist, or if the jersey number conflicts with another player.

5. Execute the procedure for PlayerID = 501 and p_NewTeamID = 102.

Football League Database Schema

Note: PK-Primary key, FK-Foreign key

Tables

Teams

Players

Stadiums

Matches

Goals

Referees

and answer the following question 

Write an SQL DML statement to insert a new player with the following details:

- PlayerID: 501

- TeamID: 101

- PlayerName: Player501

- Position: Forward

- JerseyNumber: 9

Consider the relational algebra expression:

Assume that the join is based on the department identifier and that the condition Dept='CSE' refers only to attributes of DEPARTMENT. Which transformation is generally beneficial for reducing the number of tuples participating in the join?

Consider the SQL query:

SELECT Name
FROM STUDENT
WHERE Department = 'CSE';

Which relational algebra expression correctly represents this query?

Which of the following statement(s) about BCNF is/are true?

Which of the following best describes a lossless-join decomposition?

Which sequence best represents the major stages of processing a high-level SQL query?

 Suppose you have two relations 𝑅(𝐴,𝐵) and 𝑆(𝐵,𝐶).

Which join method is most appropriate (i.e. efficient) if both relations are sorted by the join attribute  B?

Which of the the following is a condition for a relation to be in Third Normal Form (3NF) (using the common definition in Silberschatz et al.)?

In a B+ tree, the actual data record pointers or data entries are stored at the Answer Question 17 level