Question

Continue your S3 and S4 assignment for a young soccer league with the following specification. Do not include the previous queries from Task 5. A team will play some of the other teams in the same division once per season. For a scheduled game we will keep a unique 8 character code, the date, time and location (max 60 characters

Answer 1

Using the computational language in SQL script it is possible to write a code scheduled game we will keep a unique 8 character code, the date, time and location.

Writting the code in  SQL script:

SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,

Customer.firstName+' '+ Customer.lastName as customer

FROM Customer, Trainer

WHERE Trainer.handlingCustomer = Customer.id;

SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,

Customer.firstName+' '+ Customer.lastName as customer

FROM Customer, Trainer

WHERE Trainer.handlingCustomer = Customer.id AND

Customer.firstName = 'Robert';

SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,

Customer.firstName+' '+ Customer.lastName as customer

FROM Customer, Trainer

WHERE Trainer.handlingCustomer = Customer.id AND

Trainer.firstName = 'Mary';

SELECT Trainer.firstName+' '+ Trainer.lastName as trainer ,

Customer.firstName+' '+ Customer.lastName as customer

FROM Customer, Trainer

WHERE Trainer.handlingCustomer = Customer.id AND

Trainer.hiredIn >= 2015;

See more about  SQL script at brainly.com/question/15693585

#SPJ1