Develop a plan to integrate this new data warehouse with an Internet application. Include in your plan: A description of the transformation process A schema diagram identifying the changes needed (re
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
