Assignment ContentThis week you will continue your work on the project to evaluate higher education student aid data. You will test your recommended U.S. Student Aid database schema, build the databas

School

PK SchoolCode

SchoolName

Address

City

StateCode

ZipCode

Province

Country

PostalCode

DLGradPlus

PK DLGradPlusId

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

AmountOfDisbursement

FK DLId

DLParentPlus

PK DLParentPlusId

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

AmountOfDisbursement

FK DLId

FFEL

PK FFELId

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

FFELLoanType

FK LoandId

DirectLoanUnsubsidized

PK DLUnsubsidizedId

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

AmountOfDisbursement

FK DLId

DirectLoanSubsidized

PK DLSubsidizedId

Recepients

NoOfLoans

AmountOfLoans

NoOfDisbursement

AmountOfDisbursement

FK DLId

Grants

PK GrantId

GrantProgram

FK SchoolCode

FederalPellGrant

PK FederalPellfrantId

SumOfRecepients

SumOfDisbursement

FK GrantId

TeachGrant

PK TeachGrantId

SumOfRecipents

SumOfDisbursements

FK GrantId

IraqAfghanGrant

PK IraqAfghanGrantId

SumOfRecepients

SumOfDisbursements

FK GrantId

GainfulEmployment

PK GEId

CIPCode

CIPName

CredentialLevel

RepaymentRate

RepaymentNumerator

RepaymentDenominator

DirectLoans

PK DLId

LoanType

FK LoanId

Loans

PK LoanId

LoanType

FK SchoolCode