You have the following table and data: PROJECT PNAME PNUMBER PMGRSSN PLOCATIONS

Question

You have the following table and data:

PROJECT

PNAME

PNUMBER

PMGRSSN

PLOCATIONS

Soil research                               5                                  333445555             {Pensacola, Houston,                                                                                                                      Panama City}

Leaf research                               4                                  987654321             {Stafford, Milton}

Water research                             1                                  888665555              {Gulf Breeze}

Is this a good database design? Does it have to be normalized? If so, normalize it.

PNAME

PNUMBER

PMGRSSN

PLOCATIONS

Explanation / Answer

Solution:

This is not the good database design since there are more than one entries which are in comma separated value type

So we can decompose this table into two

The decomposed table will be

PROJECTS(PNAME, PNUMBER, PMGRSSN)

LOCATIONS(PLOCATIONS, PNUMBER)

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.