A schema diagram identifying the changes needed (revise the diagram you submitted for the Week Two Individual Assignment, "U.S. Student Aid Database Schema and Query Recommendations" per your instructor's feedback) Specific integration plans

USAidFact_Table

SchoolId

LoanId

DLId

DLSubsidizedId

GEId

DLUnsubsidizedId

DLParentPlusId

GradPlusId

GrantId

FFELId

IraqAfghanGrantId

TeachGrantId

FederalPellGrantId

Grants

GrantId {PK}

GrantProgram

FFEL

FFELId {PK}

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

FFELLoanType

Loans

LoanId {PK}

LoanType

DirectLoans

DLId {PK}

LoanType

DirectLoanSubsidized

DLSubsidizedId {PK}

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

AmountOfDisbursement

IraqAfghanGrant

IraqAfghanGrantId {PK}

SumOfRecepients

SumOfDisbursement

TeachGrant

TeachGrantId {PK}

SumOfRecepients

SumOfDisbursement

FederalPellGrant

FederalPellGrantId {PK}

SumOfRecepients

SumOfDisbursement

DLGradPlus

DLGradPlusId {PK}

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

AmountOfDisbursement

DLParentPlus

DLParentPlusId {PK}

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

AmountOfDisbursement

DirectLoanUnsubsidized

DLUnsubsidizedId {PK}

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

GainfulEmployment

GEId {PK}

CIPCode

CIPName

CredentialLevel

RepaymentRate

RepaymentNumerator

RepaymentDenominator

School

SchoolId {PK}

SchoolCode

Address

City

State

Zip

Province

Country

PostCode

SchoolType