USD C Programming Alumni Locator Entity Relationship Diagram Project

Content Type

User Generated

User

Egf1991

Subject

Programming

School

University of San Diego

Description

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

Unformatted Attachment Preview

ID 2233893 2356229 2415590 2477813 1973420 2296069 2491971 2455624 2497066 2458754 2395777 2297185 2147303 2080482 2461453 2287207 2327366 2457868 1975988 Prefix Mr. Mr. Mr. Mr. Mr. Ms. Mr. Mr. Ms. Mr. Mr. Ms. Mr. Ms. Mr. Miss Miss Mr. Mr. First Name Last Name Bader Ababtain Salman Ababtain Christopher Abadir Muhannad Abbas Khalid Abdelaziz Houda Abdelghani Mohammed Abdelsalam Mohamed Elmunzir Abdelwahab Nimco Abdillahi Mahmood Abdulmoniem Aimen Aberra Linera Abieva Majid Abunahyyah Daya Acharya Farid Adechoubou Kamana Adhikari Sonia Agarwal Samson Agidie Mauricio Aguilar Cadima Cn Preferred Address 2121 N Westmoreland St Apt 436 2121 N Westmoreland St 4858 Muddler Way 22609 Cambridgeport Sq 6198 Edsall Rd, #223 3535 S Ball St, APT 202 7850 Roundabout Way 3438 Rock Spring Ave 3969 Fairfax Square 500 Roosevelt Blvd Apt 621 205 Yoakum Pkwy, Apt 1612 6403 McCoy Rd. 3035 Silent Valley Dr 2112 Columbia Pike, Apt #A9 703 Vista Ridge Dr 15530 Exmore Ct 8920 Sylvania St Cn Pref Addr City Arlington Arlington Fairfax Cn Pref Addr State Cn Pref Addr Zip VA 22213-1067 VA 22213 VA 22030 Ashburn Alexandria Arlington VA VA VA Springfield Falls Church Fairfax Falls Church Alexandria Centreville Fairfax Arlington Leesburg Woodbridge Lorton VA VA VA VA VA VA VA VA VA VA VA 20148-6609 22304 22202 22153 22041 22031 22044-3112 22304 20121 22031 22204 20176 22191 22079-1611 X Per Pphone Home Email 202-374-7171 bader.ababtain@gmail.com 317-657-6666, 202-374-7171 salman_4321@hotmail.com 703-502-9444, 7035029444 cabadir@gmail.com 571-241-8255 mohabbas20017@gmail.com 703-878-1020, 703-407-0378, 703-670-9506, 7037237471 khalid_abdelaziz@yahoo.com h0a96069@marymount.edu 571-276-4844 mak123@hotmail.com 571-275-3175 munziraw@gmail.com nimcova@outlook.com 703-820-9685 mabdulmo@umw.edu 703-273-2653, 7032732693 aimen.aberra@gmail.com 210-837-9598 linera@abieva.com 619-228-5969, 202-631-8191 majed_9@yahoo.com 703-583-1784, 703-502-7635, 703-583-1789, 6176294963 daya.acharya@gmail.com 703-207-0086, 7032070086 faa273@email.vccs.edu 703-328-6182 kamanaadhikari@hotmail.com 571-291-1651 sagarwal25@hotmail.com 703-307-9478, 7038761000 samson_10160@msn.com 703-599-0308, 703-569-1017 mcadima3@gmail.com Program Code Acad Majors IT.BS.UG IT IT.BS.UG IT IT.BS.UG IT IT.BS.UG IT IT.BS.UG IT IT.BS.UG, IT.MS.GR, CYBSEC.MS.GR IT, IT, CYBSC IT.MS.GR, ITPM.CTGR.GR IT, ITPM IT.BS.UG IT IT.BS.UG IT IT.BS.UG IT IT.BS.UG IT IT.BS.UG IT IT.MS.GR, ITPM.CTGR.GR IT, IT IT.MS.GR IT IT.BS.UG IT IT.MS.GR IT IT.MS.GR IT CYBSEC.MS.GR CYBSC CYBSEC.MS.GR CYBSC Degree End Date 8/4/2012 5/9/2015 5/13/2017 8/5/2017 5/1/2011 2015-08-29, 2017-12-16, 2017-12-16 2018-05-12, 2018-05-12 8/5/2017 5/12/2018 5/7/2016 5/7/2016 5/9/2015 2011-05-01, 2011-07-30, 2011-07-30 12/12/2009 5/13/2017 12/15/2012 5/11/2013 5/13/2017 12/13/2014
Purchase answer to see full attachment

Explanation & Answer:

1 C Programming Project

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

ALUMNI LOCATOR

1

Alumni Locator
Name
Institution Affiliation

ALUMNI LOCATOR

2
Alumni Locator
Issues that affect the Normalization process

Normalization is a critical process in the successful design of a database. If a database is
not normalized, the system will be highly inaccurate, slow, and efficient (Amin et al., 2019). In
the provided Excel spreadsheet, one of the primary issu...