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

The database design seems to be good, but still something can be done.

You can have the following properties that can be added to this.

First you can set PNUMBER as Primary Key and set it as auto increment. You can also set PMGRSSN at foreign key if it is being picked from other table.

The design seems to be normalized and no redundancy is found.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

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