Column Name

Primary key

Data type

NOT NULL

AUTO INC

ID

Username

Password

First name

Middle name

Last name

Department

Level

Address

Sex

Matric No.

Yes

INTEGER

VARCHAR (45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (4500)

VARCHAR (45)

VARCHAR (45)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes