Data Model

The Lending Process at PNC Bank has keys elements that can be updated and change fairly easily with in the database. Keys elements used in the data base are Primary Keys, relationships within the database and the tables in the database. The primary keys used in our database are staff ID, client ID, and loan ID.Primary keys can be described as “column or group of columns that identifies a unique row in a table” (Kroneke, 2009).The relationship element shows how the data has referential integrity to show data consistency. Relationships through the cardinality of the tables. Relationships can be one to one, one to many, and many to many. The last key element is the tables in the database; the tables we have are the loan table, the client table, and the employee table. The tables help sort the data out so the data is easy to find when needed.

Based on the interview we had with Jim Marino our database is categorized based on what kind of loan the client needs and which employee would help. The employee refers to the loan and client by their ID and what kind of loan they need so cardinality is maintained through the tables. The relationships between the tables is one to many. One loan can go to many employees; One loan can go to many clients. This means each loan can go to many borrowers.

The loan table is broken down by the loan ID and the loan type. This table shows the different types of loan the client can get from PNC bank. This table forms a one to many relationship to the the client table and the employee table.

The client table is broken down into five sections: client ID, client name, credit score, income/ net worth, and employment history. This table shows information about the clients who are applying for a loan. The client table is connected to the employee table and the loan table. One client cam apply for many loans and work with many employee from the bank.

The employee table is broken down by the staff ID, their name, and their job title. The table shows which employee can help each client in the loaning process. Each staff member can have many clients and have access to many loans.