Chapter 9 Part II Group Assignment

Topics: Academic degree, High school, University Pages: 1 (200 words) Published: November 29, 2014
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.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Part Ii Chapter 1 Essay
  • Group B Assignment II Research Paper
  • Chapter 9 Group Behavior Notes Essay
  • CHAPTER II Essay
  • Chapter II Essay
  • Chapter II Essay
  • CHAPTER II Essay
  • Chapter II Essay

Become a StudyMode Member

Sign Up - It's Free