text: 
  create table sport_league
  (sport_type_name varchar(15) NOT NULL
     constraint sl_sport_type_fk references sport_type(name),
   short_name varchar(10) NOT NULL,
   long_name varchar(60) NOT NULL,
   description varchar(120),
   constraint sport_league_pk primary key(short_name)
  );
  
  insert into sport_league(sport_type_name,short_name,long_name,description)
  values('baseball','MLB','Major League Baseball','Professional baseball league in North America.');
  
  insert into sport_league(sport_type_name,short_name,long_name,description)
  values('football','NFL','National Footbal League','Professional football league in North America.');
  
  