(Baby names) Create the following table:

(Baby names) Create the following table:

create table Babyname (
 year integer,
 name varchar(50),
 gender char(1),
 count integer,
constraint pkBabyname primary key (year, name, gender)
);

The baby name ranking data was described in Programming Exercise 12.31. Write a program to read data from the following URL and store into the Babyname table. http://www.cs.armstrong.edu/liang/data/babynamesranking2001.txt,

…

http://www.cs.armstrong.edu/liang/data/babynamesranking2010.txt.