“Task 1 Construction and use of an object-based interface to a relational database. Task 2 Investigation of object-relational databases.”

Modify the application to display foreign keys.

To do this I created a new method called findFKConstraints().  The method is very similar to the existing method findPKConstraints(), however I have made the method change the text fields and labels of foreign key fields to red text.  To do this I changed the select query so that the column numbers were found as opposed to the position.  I needed to do this so that I knew which row of the editFields vector and the columntypes vector to change to red text.  Also if any foreign keys are found this method displays a label in the window that says ***Red text indicates a Foreign Key***….(short extract)