SEPTEMBER 6

Same steps are followed to create the manager table , reviewing officer table and accepting officer table.
MANAGER TABLE:
Name of table : ZPROJECT_MGR.
Short description :  MANAGER TABLE FOR PROJECT EAS
Required Fields:
MGR_ID - manager id.
MGR_NAME - name of manager.
DEPT_NO - department number
DEPT_NAME - department name.
PASSCODE - password.
PHONE_NO - phone number
ADDRESS - address

After the fields are defined, we enter the values.

REVIEWING OFFICER TABLE:

Name of table : ZPROJECT_RO.
Short description : REVIEWING OFFICER TABLE FOR PROJECT EAS
Required Fields:
RO_ID -  reviewing officer  id.
NAME - name of  reviewing officer.
DEPT_NO - department number
DEPT_NAME - department name.
PASSCODE - password.

Values are then entered in the fields.

ACCEPTING OFFICER TABLE:

Name of table : ZPROJECT_AO.
Short description : ACCEPTING OFFICER TABLE FOR PROJECT EAS
Required Fields:
AO_ID -  accepting officer  id.
NAME - name of  accepting officer.
DEPT_NO - department number
DEPT_NAME - department name.
PASSCODE - password.

Values entered in the tables are: