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: | 408 Weeks Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Consider a research management system in which faculty members from different departments are often collaborated to a research project. Each faculty member
is allocated with a certain amount of research fund. The following is an
example of an un-normalized RESEARCH-DATA table for two research projects.
RESEARCH-DATA
|
Research ID |
Research Name |
Start Date |
Faculty ID |
Faculty Name |
Research Fund |
Department ID |
Department Name |
|
1 |
E-Commerce |
04/10/2015 |
2489 |
Smith |
$200,000 |
1 |
ITEC |
| Â | Â | Â |
1887 |
Jones |
$5,000 |
1 |
ITEC |
| Â | Â | Â |
9540 |
Mike |
$25,000 |
5 |
ISAS |
|
2 |
Cloud Computing |
12/15/2015 |
3436 |
Catherine |
$200,000 |
2 |
BUS |
| Â | Â | Â |
2489 |
Smith |
$10,000 |
1 |
ITEC |
Perform the normalization process to convert the above un-normalized table to:
1. First normal form (1NF)
2. Second normal form (2NF)
3. Third normal form (3NF)
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