Answer to Question #235615 in HTML/JavaScript Web Application for Tebogo mosehla

Question

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)

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