This Lab will use the following Lab Resources:
Microsoft Excel
Scenario:
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:
Student First Name
Student Last Name
Student Address (including street address, city, state, and zip code)
Birthdate
Tuition Cost
Status (Freshman, sophomore, junior, or senior)
Degree plan ID
Scholarships applied
Tuition per credit
Number of credits for student
Student Email
Student Phone
Deliverables:
Given the information about each model component, what would you recommend to use for Entities? (There should be at least three entities)
What would be the list of attributes to have in each entity?
What would the primary and foreign keys be for each entity?
Use the following format using MS Excel and label each entity, list attributes under the entity name, and designate FK and PK.
Example:
Entity Name
Label PK, FK Here
Attribute List