[SOLVED] CPRG307 - Assignment 3

This is the Database course assignment ,

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.