Creativity tasks:

-Decide what database table(s)/fields do you need for this. Tables at minimum should include a login table, a trouble ticket table and a table of your choice to complete your domain.

-Design a GUI for which will include the following options

-Create or start a ticket

-Close a ticket

-View a ticket(s) allow for user to view a particular ticket or multiple tickets

-Update a ticket

-Delete a ticket(s) allow for user to delete a particular ticket or multiple tickets

*Note- authentication should be included in your logic to allow an admin full viewing / CRUD rights to the system. All other users will just be allowed creation rights. Creation rights include adding a ticket, filling in a brief description and including a priority choice for the ticket as either High, Medium or Low.

Runtime tasks: (Your program should perform the following tasks)

-Input (open up) at least 5 trouble ticket cases. 3 of the tickets should be high priority. Include needed data to complete a starter ticket.

-Show a view of a particular ticket created (include all pertinent fields in a JTable)

-Show a view of all tickets created (include all pertinent fields in a JTable)

-Allow for a closing of at least one ticket. Show pop up message stating that the ticket was closed as follows:

Ticket #xxxxxxxxxx has been closed where xxxxxxxxxx represents the ticket number closed

-Update at least one trouble ticket by changing the current description to WH WIFI PROBLEM

-Delete at least one ticket. Make sure to display a pop up to ask user the following:

Are you sure you want to delete this ticket #xxxxxxxxxx? where xxxxxxxxxx represents the ticket number in question