Answer to Question #238095 in HTML/JavaScript Web Application for Owen

Question

1.3 Once the information has been inputted by the student at the frontend (REGISTRATION FORM), all the fields need to be validated before being sent to the backend (MYSQL DATABASE). Only one SQL task is performed under registration form that is, INSERT operation where captured information is sent to the created table called student_reg.

Answer 1

CREATE ​DATABASE rgi_student;

CREATE ​TABLE student_reg (
   ​STID INTEGER (4)
   ​USERNAME VARCHAR(30)
   ​PASSWORD HASH CHAR(25)
   ​CONFIRM PASSWORD
   ​FIRSTNAME VARCHAR(30)
   ​SURNAME VARCHAR(30)
   ​EMAIL TEXT
   ​QUALIFICATION VARCHAR(15)
   ​CELL NUMBER INTERGER(10)
   ​GENDER VARCHAR(6)
   ​NATIONALITY VARCHAR(25)