Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

database system 6

/in /by

  1. 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)
  2. 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.
 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"