Assignment title: Java
Attached is the original question paper for the assignment. I do not need the whole assignment done, just the source code for it. 2) Write a Java Program which allows the users to do CRUD (Create, Retrieve, Update, and Delete) operations on a Student table in a School database in the database server installed in the laboratory in your center. The program must use JDBC type 4 driver. The user interface should be implemented using Java Swing components. The user interface does not need to be done in swing just in normal cmd window is sufficient. The database used is the IBM db2, it needs to link up with db2 software not oracle/microsoft. Please let me know the price, also needs to be done within 24 hours.Discuss with clear explanation the database security for the database software installed in the
laboratory in your center. Your discussion must cover the tools available for the customization
and the best practice for assigning of privileges, authorities, roles to users and groups.
The description must be specific to the database environment in the laboratory in
your centre.
You must cite the sources using Harvard Referencing. You may refer to the Mondofacto Research Skills web site
(http://www.mondofacto.com/study-skills/writing/how-to-reference/) for the way of
proper Reference and Citation style.
Your description must cover the following topics with evidences such as screen shots,
lab exercises, scripts, your own sample commands, etc.
a.) System-level Security
b.) Database Level Security
c.) Database Object Level Security
d.) Contents level Security
Question 2
Write a Java Program which allows the users to do CRUD (Create, Retrieve, Update, and
Delete) operations on a Student table in a School database in the database server installed in
the laboratory in your center. The program must use JDBC type 4 driver. The user interface
should be implemented using Java Swing components.
a.) Source Codes; T314 CDB203 ASSIGNMENT QP Page 8 of 8
b.) CRUD Operations;
c.) Interface;
d.) Test Plan and Test Results;
e.) Report: The report must cover database creation, critical design decisions, interface
design, connection to the database, test plan and test results.