A delimited text file with the payroll transaction information in it. This delimited text file is processed, a month end process is performed and database data is exported - payroll.txt 3. An executable jar file so that you can perform integration tests to ensure your code is compatible with the front end. - CPRG307-Assignment3.jar 4. Physical ERD of the database used for the assignment - WKIS ERD.pdf 5. SQL scripts to create the database tables - createwkis.sql, add constraints to the tables - constraintswkis.sql, load data in the tables - loadwkis.sql
Execute the scripts in the following order: 1. createwkis.sql 2. constraintswkis.sql 3. load_wkis.sql
My assignment solution - Assignment solution.sql which is complete and correct.
