The Midtown Ladies Auxiliary is sponsoring a scholarship for local high school students. They have constructed a table with the structure tblScholarshipApplicants(appId, lastName, hsAttended, hsAddress, gpa, honors, clubsActivities). The hsAttended and hsAddress attributes represent the high school attended and its street address, respectively. The gpa attribute is a grade point average. The honors attribute holds awards received, and the clubsActivities attribute holds the names of clubs and activities in which the student participated. If necessary, redesign the table so it satisfies 1NF, 2NF, and 3NF.

Transcribed Image Text:

appId lastName hsAttended hsAddress gpa 1 Wong Central 1500 Main 3.8 2 3 4 5 Jefferson Central Mitchell Highland O'Malley St. Joseph Abel Central 1500 Main 4.0 Valedictorian 200 Airport honors Citizenship award Future teachers Class officer Model airplane Soccer MVP Newspaper Pep Yearbook Homecoming court Football MVP Pep 3.6 Citizenship award Class officer clubsActivities Homecoming court Future teachers Pep Chess 1500 Main 3.7 Citizenship award Yearbook Class officer X 300 Fourth 4.0 Valedictorian