I need an explanation for this C Programming question to help me study.
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
Submit: issues/assumption document, ERD, and MS-Access file.