PLAYER (id int(PK), fname varchar (30) ,lname varchar(30) ,age int ,position varchar(30) clubid int(FK), clubid is a FK to the PK of the table CLUB. (id, first name, last name,age, position in the id of the club it refers)
CLUB( clubid(PK int ), name, titlesno,founded) id of the club, name of the club, number of titles, and year of foundation.
INSERT 4 RECORDS FOR PLAYER AND 3 RECORDS FOR CLUB (YOU CHOOSE)
Build and run the following queries:
Select all the club names that has an average age of players lower than 25 playing in it
Select the first name and last name of those players younger than average.
select club names with less than 3 players
Return first name, last name age and club name of those players elder than 35
Modify the table player by adding a column ‘SALARY’ int (NOT optional) and insert the salary of every player . You choose the salaries.
Delete all the players older than 50 years old.
Create a view that return the names and the year of foundation of those clubs that are more than 100 years old.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code "Newclient" for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post database system 6 appeared first on My Nursing Experts.