Question
The Language of this is SQL and this Question Involves Database Structuring ############################################################################# Consider the relation: STUDENT (SSN, FirstName, MiddleInitial, LastName, Address, PhoneNumber, Age, GPA)
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started