Here is the comp
No category Today 16:17
Here is the complete data dictionary in a
table format, without length specifications
for fixed-length data types like `int`:
_Customers_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| CustomerID | int | PK | Unique | |
| Name | varchar | | | |
| DateOfBirth | date | | | |
| CreditScore | int | | 0-999 | Credit score
must be between 0 and 999 |
| EmploymentStatus | varchar | | | |
| Income | decimal | | | |
_CustomerAddresses_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| AddressID | int | PK | Unique | |
| CustomerID | int | FK | References
Customers(CustomerID) | Address must be
associated with a customer |
| Street | varchar | | | |
| City | varchar | | | |
| State | varchar | | | |
| ZIP | varchar | | | |
_Staff_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| StaffID | int | PK | Unique | |
| Name | varchar | | | |
| Role | varchar | | | Staff member must
have a role |
| Department | varchar | | | Staff member
must have a department |
_StaffContacts_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| ContactID | int | PK | Unique | |
| StaffID | int | FK | References Staff(StaffID)
| Contact must be associated with a staff
member |
| Phone | varchar | | | |
| Email | varchar | | | |
| Fax | varchar | | | |
_CoSigners_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| CoSignerID | int | PK | Unique | |
| Name | varchar | | | |
| Address | varchar | | | |
| RelationshipToCustomer | varchar | | | |
| CreditScore | int | | 0-999 | Credit score
must be between 0 and 999 |
| CustomerID | int | FK | References
Customers(CustomerID) | Co-signer must
be associated with a customer |
_Loans_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| LoanID | int | PK | Unique | |
| CustomerID | int | FK | References
Customers(CustomerID) | Loan must be
associated with a customer |
| LoanAmount | decimal | | | |
| LoanTerm | int | | | |
| InterestRate | decimal | | | |
_PaymentPlans_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| PaymentPlanID | int | PK | Unique | |
| LoanID | int | FK | References
Loans(LoanID) | Payment plan must be
associated with a loan |
| PaymentFrequency | varchar | | | |
| PaymentAmount | decimal | | | |
_LoanPayments_
| Attribute | Data Type | PK/FK | Constraints |
Business Rule |
| --- | --- | --- | --- | --- |
| PaymentID | int | PK | Unique | |
| PaymentPlanID | int | FK | References
PaymentPlans(PaymentPlanID) | Loan
payment must be associated with a
payment plan |
| PaymentDate | date | | | |
| PaymentAmount | decimal | | | |
| PaymentStatus | varchar | | | |
Let me know if this is what you needed!
