You have been tasked by your University to set up an Alumni Locator to begin developing more alumni events. Thy have an Excel spreadsheet which shows an excerpt of the data that they are currently retrieving on students’ graduation. They want to also keep track of the alums LinkedIn account. In addition, they want to collect information (start and end date, organization, job position, location) on the jobs that the alums have been in and are in.
Check out the Excel file and complete the following tasks:
Identify issues with the Excel spreadsheet that affect the normalization process and document any assumptions that you will make in the database design
Develop an ERD as a data model
Develop an MS-Access data. Include relationships and data type into a normalized table.
Populate with sample data from the spreadsheet and test data for the additional fields, at least 2 rows in each table
Sample Solution
