Create an application to split database tables into two related tables

**Project:? ** Write a VB2008 application that will be pointed to a database, discover all tables and fields in the database, then, after the discovered table and field information is edited by the application user, will divide specified tables into two, moving some fields and the contents of the specified fields to the new table. ## Deliverables **Project:? ** Write a VB2008 application that will be pointed to a database, discover all tables and fields in the database, then, after the discovered table and field information is edited by the application user, will divide specified tables into two, moving some fields and the contents of the specified fields to the new table. ? Note:? The attached sample ACCESS database contains example tables required for this application and also “before split?? and “after split?? examples.? View the Relationships tab to review the sample tables. ? The application must perform the following: (1) discover all tables in a target database and load table and field values into predefined tables, (2) facilitate editing of these table records, (3) modify database table structures based on the edited records’ values, and (4) at a later time compare the recorded structure of the database(s) with the current database structure and notify the user of any differences. ? The application user will load the name of the target database and any required connection information into (Sample Table "TargetDB").? This can then be used by the application to gather Table and Field information. ? Feel free to add/remove fields as may be needed. ? The application will discover all files and fields and load this information into tables "TargetTables" and “TargetFields??.? The application user will then edit the table with the records linked similar to Query1. ? Split this table ??" indicates this table should be split ? Spawn Table Name ??" indicates the name of the new table ? TableLink Field Name ??" the new table must be linked back to the original table in a one-to-many relationship (original to spawn).? This identifies the name of the field to be added to the original table to link to the spawned table records. ? Move This Field ??" indicates this field should be moved to the new table ? **Project Deliverable #1** is a Windows UI that allows the application user to enter Target Database information, launch the database discovery process, then edit the TargetTables and TargetFields information as described above. ? ? ? After the application user has determined which tables should be split and which fields in each table should be moved to the split table, the user will launch a process which will create a new table for each table which is to be split, naming it the name specified in the setup record.? It will create fields in each new table identically named as the fields that were tagged to be moved. ? A standard primary index field and a linking field whose name was specified in the “TableLink Field Name?? field must be added to each new table. ? A one-to-many relationship will be established between the new TableLink Field and the Primary Key of the original table. ? After the tables and relationships are established, field data of the fields to be moved must be written to the new table for all records in the original tables.? After the data are moved, the moved field columns must be dropped from the original table. ? ? **Project Deliverable #2** is a button on the Windows UI the application user can click to (after confirmation) will split each specified table, move the data, and drop the moved field columns as described above.? The UI will provide a percentage completed indication based on the count of steps completed (including table and fields created/moved) and an indication of completion of the entire process. ? ? Since this application retains the table and field structure of the database, the final feature is to validate the database structure of any table tagged as having been split.? This should occur automatically on application startup, with either an indication of “Data Structure has not changed?? or “WARNING ??" Data Structure has Changed!?? being delivered through the Windows UI. ? **Project Deliverable #3** is to devise a means to identify the new structure of the split tables and provide an indication of change or no change as specified above. ?