When you finish creating your Entity Relationship Diagram and made sure that there are no errors; you can then start converting to tables by using the conversion rules. See below.
Entity Type Rule: Convert the Student, Loan, Institution, Lender and DisburseLine entity types into tables.
1-M Relationships rule for all relationships except Sent relationship.
Use the M-N relationship to convert the Sent relationship.
Use the identification dependency rule to add two components (LoanNO, DateSent) as part of the primary key of the Sent table.
Student(StdNO Primary Key, StdName, StdAddress, StdCity, StdState, StdZip, StdEmail)
Loan(LoanNO Primary Key, ProcDate, DisbMethod, DisbBank, DateAuth, NoteValue, Subsidized, Rate)
Foreign Key (StdNO) References Student(StdNO)
Foreign Key(InstID) References Institution(InstID)
Foreign Key(LenderNO) References Lender(LenderNO)
StdNO Not Null
InstID Not Null
LenderNO Not Null
Institution(InstID Primary Key, InstName, InstMascot)
Lender(LenderNO Primary Key, LendName)
DisburseLine(DateSent, Amount, OrigFee, GuarFee)
Sent (LoanNO, DateSent)
Foreign Key(LoanNO) References Loan(LoanNO)
Foreign Key(DateSent) References DisburseLine(DateSent)
LoanNO Not Null
Notable 