Answer to Question #237750 in Databases | SQL | Oracle | MS Access for Lesiba

Question

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

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