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
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
