Problem

Make a copy of the Stock Tracker database and name it, StockTracker2. Create an ODBC data source name, also named StockTracker2, that references this database. Write a Java utility program that will create the new table designed in Assignment 1, adding it to the StockTracker2 database. The program can be a console program and does not need a GUI interface. The new table should include all of the fields listed in assignment 1. Additionally, it should create the key(s) and relationship(s) indicated in your design. In the program, create some test data and add to the database, remembering to keep data in the tables synchronized (i.e., do not add a transaction for a nonexistent user or stock), which may require writing data to other tables in the database as well. Finally, using Access, open the database, click Tools on the menu bar and then click Relationships. Verify that the relationship diagram looks like your original design.