Chapter 9 Part II Group Assignment
SAD – Chapter 9 Part I Group Assignment
Answer the following questions and then submit through Blackboard Vista:
1. Consider the following functional dependencies:
Applicant_ID Applicant_Name
Applicant_ID Applicant_Address
Position_ID Position_Title
Position_ID Date_Position_Opens
Position_ID Department
Applicant_ID + Position_ID Date_Applied
Application_ID + Position_ID +Date_Interviewed Interview_Duration
a. Represent these attributes with 3NF relations. Provide meaningful relation names.
APPLICANT (APPLICANT ID, APPLICANT_NAME, APPLICANT_ADDRESS)
POSITION (POSITION ID, POSITION_TITLE, DATE_POSITION_OPENS, DEPARTMENT)
APPLICATION (APPLICANT ID, POSITION ID, DATE_APPLIED)
INTERVIEW (APPLICANT ID, POSITION ID, DATE INTERVIEWED, INTERVIEW_DURATION)
2. Suppose you were designing a default value for the age field in a student record at your university. What possible values would you consider and why? How might the default vary by other characteristics about the student, such as school within the university or degree sought?
The default value for the age field in a student record at the university would be 18 because the average age that a student graduates high school and enters college is 18. The default age would vary depending on degree sought because higher degrees such as masters and PHd’s are sought out by older students and Alumni.
Answer the following questions and then submit through Blackboard Vista:
1. Consider the following functional dependencies:
Applicant_ID Applicant_Name
Applicant_ID Applicant_Address
Position_ID Position_Title
Position_ID Date_Position_Opens
Position_ID Department
Applicant_ID + Position_ID Date_Applied
Application_ID + Position_ID +Date_Interviewed Interview_Duration
a. Represent these attributes with 3NF relations. Provide meaningful relation names.
APPLICANT (APPLICANT ID, APPLICANT_NAME, APPLICANT_ADDRESS)
POSITION (POSITION ID, POSITION_TITLE, DATE_POSITION_OPENS, DEPARTMENT)
APPLICATION (APPLICANT ID, POSITION ID, DATE_APPLIED)
INTERVIEW (APPLICANT ID, POSITION ID, DATE INTERVIEWED, INTERVIEW_DURATION)
2. Suppose you were designing a default value for the age field in a student record at your university. What possible values would you consider and why? How might the default vary by other characteristics about the student, such as school within the university or degree sought?
The default value for the age field in a student record at the university would be 18 because the average age that a student graduates high school and enters college is 18. The default age would vary depending on degree sought because higher degrees such as masters and PHd’s are sought out by older students and Alumni.