BASIC SQL

/* 1 SQL CREATE TABLE */
/* student table */
CREATE TABLE student
(student_number CHAR(8)
, surname CHAR VARYNG(50)
, forename CHAR VARYING(50)
, gender CHAR VARYING(7)
, title CHAR VARYING(4)
, date_of_birth DATE
, department_number CHAR (6)
, course_number CHAR (10)
);
/* Staff Table */
CREATE TABLE staff
(staff_number CHAR(10)
, surname CHAR VARYING(50)
, forename CHAR VARYING(50)
, gender CHAR VARYING(7)
, title CHAR VARYING(4)
, date_of_birth DATE
, salary DECIMAL(7,2)
, dept_number CHAR(6)
);
/* Department Table */
CREATE TABLE department
(department_number CHAR(6)
, department_name CHAR VARYING(50)
);
/* Course Table */
CREATE TABLE course
(course_number CHAR(10)
, course_name CHAR VARYING(50)
, department_number CHAR(6)
);
/* Unit Table */
CREATE TABLE unit
(unit_number CHAR(10)
, unit_name CHAR VARYING(50)
, course_number CHAR(10)
);
/* Altering student table */
ALTER TABLE student ADD telephone_number CHAR(7);
ALTER TABLE student ADD mobile_number CHAR(10);
/* Altering staff table */
ALTER TABLE staff ADD email CHAR VARYING(50);
/* Altering department table */
ALTER TABLE department ADD location CHAR VARYING(50);
/* inputing records into student table */
INSERT INTO student
VALUES ('SN002349', 'Grant', 'Richard', 'Male', 'Mr.', '1995-09-19', 'DEP22', 'BS0101',
'913-515-7889', '913-545-7898');
INSERT INTO student (student_number, surname, forename, gender, title,
department_number, course_number)
VALUES ('SN003211', 'Huber', 'Jennifer', 'Female', 'Ms.', 'DEP22', 'BS0101');
INSERT INTO student
VALUES ('SN001388', 'Ramirez', 'Marco', 'Male', 'Mr.', '1994-01-20', 'DEP21', 'IS8100',
'613-415-2829', '616-535-6867');
SELECT * FROM student