The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 3 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
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 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 each of the following:
a. 1NF
b. 2NF
c. 3NF
|
appId |
lastName |
hsAttended |
hsAddress |
gpa |
honors |
clubsActivities |
|
1 |
Wong |
Central |
1500 Main |
3.8 |
Citizenship award |
Future teachers |
|
 |
 |
 |
 |
 |
Class officer |
Model airplane |
|
 |
 |
 |
 |
 |
Soccer MVP |
Newspaper |
|
2 |
Jefferson |
Central |
1500 Main |
4.0 |
Valedictorian |
Pep Yearbook |
|
 |
 |
 |
 |
 |
Citizenship award |
 |
|
 |
 |
 |
 |
 |
Homecoming court |
 |
|
 |
 |
 |
 |
 |
Football MVP |
 |
|
3 |
Mitchell |
Highland |
200 Airport |
3.6 |
Class officer |
Pep |
|
 |
 |
 |
 |
 |
Homecoming court |
Future teachers |
|
4 |
O’Malley |
St. Joseph |
300 Fourth |
4.0 |
Valedictorian |
Pep Chess |
|
5 |
Abel |
Central |
1500 Main |
3.7 |
Citizenship award |
Yearbook |
|
 |
 |
 |
 |
 |
Class officer |
 |
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll