I need help with the following Consider a STUDENT relation in a UNIVERSITY database with the following attributes (Name, Ssn, Local_phone, Address, Cell_phone, Age, Gpa). Note that the cell phone may be from a different city and state (or province) from the local phone. A possible tuple of the relation is shown below: Name Ssn Local_phone Address Cell_phone Age Gpa George Shaw 123-45-6789 555-1234 123 Main St., 555-4321 19 3.75 William Edwards Anytown, CA 94539 a. Identify the critical missing information from the Local_phone and Cell_phone attributes. (Hint: How do you call someone who lives in a dif ferent state or province?) b. Would you store this additional information in the Local_phone and Cell_phone attributes or add new attributes to the schema for STUDENT? c. Consider the Name attribute. What are the advantages and disadvantages of splitting this field from one attribute into three attributes (first name, middle name, and last name)? d. What general guideline would you recommend for deciding when to store information in a single attribute and when to split the information? e. Suppose the student can have between 0 and 5 phones. Suggest two dif ferent designs that allow this type of information.
I need help with the following
Consider a STUDENT relation in a UNIVERSITY
attributes (Name, Ssn, Local_phone, Address, Cell_phone, Age, Gpa). Note that
the cell phone may be from a different city and state (or province) from the
local phone. A possible tuple of the relation is shown below:
Name Ssn Local_phone Address Cell_phone Age Gpa
George Shaw 123-45-6789 555-1234 123 Main St., 555-4321 19 3.75
William Edwards Anytown, CA 94539
a. Identify the critical missing information from the Local_phone and
Cell_phone attributes. (Hint: How do you call someone who lives in a dif ferent state or province?)
b. Would you store this additional information in the Local_phone and
Cell_phone attributes or add new attributes to the schema for STUDENT?
c. Consider the Name attribute. What are the advantages and disadvantages
of splitting this field from one attribute into three attributes (first name,
middle name, and last name)?
d. What general guideline would you recommend for deciding when to
store information in a single attribute and when to split the information?
e. Suppose the student can have between 0 and 5 phones. Suggest two dif ferent designs that allow this type of information.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
