SELECT T1.rank ,  T3.major_name FROM Major_Ranking AS T1 JOIN University AS T2 JOIN Major AS T3 ON T1.university_id  =  T2.university_id AND T1.major_id  =  T3.major_id WHERE T2.university_name  =  'Augustana College'
Show all majors and major ranks for the university with name Augustana College.
CREATE TABLE "university" (
"University_ID" int,
"University_Name" text,
"City" text,
"State" text,
"Team_Name" text,
"Affiliation" text,
"Enrollment" int,
"Home_Conference" text,
PRIMARY KEY ("University_ID")
);
CREATE TABLE "overall_ranking" (
"Rank" int,
"University_ID" int,
"Reputation_point" int,
"Research_point" int,
"Citation_point" int,
"Total" int,
PRIMARY KEY ("University_ID"),
FOREIGN KEY (`University_ID`) REFERENCES `university`(`University_ID`)
);
CREATE TABLE "major" (
"Major_ID" int,
"Major_Name" text,
"Major_Code" int,
PRIMARY KEY ("Major_ID")
);
CREATE TABLE "major_ranking" (
"Rank" int,
"University_ID" int,
"Major_ID" int,
PRIMARY KEY ("Rank","Major_ID","University_ID"),
FOREIGN KEY (`University_ID`) REFERENCES `university`(`University_ID`),
FOREIGN KEY (`Major_ID`) REFERENCES `major`(`Major_ID`)
);
INSERT INTO  "university" VALUES (1,"Augustana College","Rock Island","Illinois","Vikings","Private_Lutheran","2500","CCIW");
INSERT INTO  "overall_ranking" VALUES ("1",1,"5","2","0","7");
INSERT INTO  "major" VALUES (1,"Accounting",1054);
INSERT INTO  "major_ranking" VALUES (1,1,1);