Answer to Question #248048 in HTML/JavaScript Web Application for NovaCodings

Question

1 In this task, you are to create a simple registration form. Use the sample below:

1.2 Create MYSQL database called rgi_student and a table called student_reg which consist of the

following attributes:



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)

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 3

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)
);