The Language of this is SQL and this Question Involves Database Structuring

#############################################################################

Consider the relation: STUDENT (SSN, FirstName, MiddleInitial, LastName, Address, PhoneNumber, Age, GPA)

a) Give an argument for keeping the FirstName, MiddleInitial, LastName as separate attributes instead of combining them into a single attribute (e.g., Name).

b) Suppose we want to store three different phone numbers -- home phone, cell phone, office phone -- for each student. Then, the single attribute PhoneNumber is not suitable anymore. State the reason why it is not, and propose how you would change the schema to accommodate this situation.

c) Give an argument against using Age as an attribute, and suggest an alternative attribute that resolves the point of your argument