Problem
You are a Database Administrator for a small community college. (Approximately 5,000 students). You have been tasked by your Manager to develop a student database that will track the following information:
a) Student First Name
b) Student Last Name
c) Student Address (including street address, city, state, and zip code)
d) Birth date
e) Tuition Cost
f) Status (Freshman, sophomore, junior, or senior)
g) Degree plan ID
h) Scholarships applied
i) Tuition per credit
j) Number of credits for student
k) Student Email
l) Student Phone
For this problem, you will be submitting a single Excel file to Canvas when completed.
1) Given the information about each model component, what would you recommend to use for Entities? (There should be at least three entities)
2) What would be the list of attributes to have in each entity?
3) What would the primary and foreign keys be for each entity?