Help getting started

Anonymous · ‎07-06-2023

I'm having a hard time getting started with this particular data set. I have tried creating new tables to separate the data, but they are not forming the correct relationships. Specifically, "student ID" is repeated many times to represent the # of internships per student. How, then, do I best approach this and model my data correctly?

StudentID

Applications ID

Employer ID

Employer Name

Jobs ID

Job Title

Industries Name

Application Created Date

Gender

Citizenship_Status

Race

URM_Status

First_Gen

Military_Status

School

School_Abbr

Deg_Level

Selected for Interview

Completed Interview

Offer Extended

Offer Accepted

KSA163

54160154

51482

Scholars Strategy Network

4220034

Policy Intern at Scholars Strategy

Non-Profit - Other

12/29/2020

Female

U.S. Citizen or Permanent Resident

Latinx

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

KSA163

54160239

72960

Lutheran Immigration Refugee Service

4216275

Outreach Programs Intern

Non-Profit - Other

12/29/2020

Female

U.S. Citizen or Permanent Resident

Latinx

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

KSA163

54160271

191320

Insight Policy Research

4216780

Summer Policy Research Internship

Research

12/29/2020

Female

U.S. Citizen or Permanent Resident

Latinx

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

Y

KSA163

54160538

212201

Democracy International

4221226

Democracy and Governance Internship

Management Consulting

12/29/2020

Female

U.S. Citizen or Permanent Resident

Latinx

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

KSA163

54161237

47720

Parks and People Foundation

4217200

Environmental Literacy Counselor Intern

Non-Profit - Other

12/29/2020

Female

U.S. Citizen or Permanent Resident

Latinx

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

KSA163

54161332

26024

American Council for an Energy-Efficient Economy

4218176

Research Internship – Strategic Energy Management

Non-Profit - Other

12/29/2020

Female

U.S. Citizen or Permanent Resident

Latinx

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

AAP101

54020860

13709

ZS Associates

4212078

Strategy Insights & Planning Associate - Intern

Management Consulting

12/27/2020

Female

Not U.S. Citizen

Asian/Asian American

Not URM

Not First Gen

Not a Veteran

Advanced Academic Programs

AAP

Graduate

N

KSA164

54170003

26024

American Council for an Energy-Efficient Economy

4218176

Research Internship – Strategic Energy Management

Non-Profit - Other

12/29/2020

Female

U.S. Citizen or Permanent Resident

Black or African American

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

KSA164

54170071

178994

Attentive

4217148

Client Strategy Intern

Internet & Software

12/29/2020

Female

U.S. Citizen or Permanent Resident

Black or African American

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

KSA164

54170133

47160

Catholic Relief Services

4240946

Short-term Summer?Hire – Fellows, Interns & Junior Professionals Support

Non-Profit - Other

12/29/2020

Female

U.S. Citizen or Permanent Resident

Black or African American

URM

First Gen

Not a Veteran

Krieger School of Arts and Sciences

KSAS

Undergraduate

N

Thanks so much in advance!

Anonymous · ‎07-09-2023

Hi @Anonymous ,

If I understand correctly, you would like to split this table above into multiple tables(two or above) and then create the appropriate relationships among them. What's your final expected result? Could you please provide background scenario and explain the requirement with more details? Later we can check if there is solution or another method to achieve it. Thank you.

Best Regards