Revise the schema you submitted in the Week One Individual Assignment, "U.S. Student Aid Initial Database Schema" per your instructor's feedback.Test your schema by completing the following tasks:Defi
Introduction
There are certain discrepancies that may arise such as duplication of data. We will identify each table with a primary key which ought to be unique. A primary key is the candidate key that is selected to identify things uniquely within the relation. We will also employ the use of foreign keys. A foreign key is an attribute within one relation that matches the primary key of some relation. In some instances, it could be the same relation.
We will also use foreign key with cascade delete to enforce data quality. This means that, if a record in the parent table is deleted then the corresponding record in the child table should also be deleted automatically.
We will also use data types whereby a user cannot enter something that is contrary to the data type. For example, the attribute AmountOfLoans from table FFEL ought to be a currency, so we need to use a data type that supports currency such as DECIMAL(15,2).
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
School
PK SchoolCode
SchoolName
Address
City
State
Zip
Province
Country
PostCode
SchoolType