/* homework 3 */

SET echo ON

spool D:hw3.txt

DROP TABLE STUDENTS;

CREATE TABLE STUDENTS (
    SSN CHAR(9),
    Lastname CHAR(10),
    Firstname CHAR(10),
    Major CHAR(10),
    GPA NUMBER(3,2),
    DOB DATE);


INSERT INTO STUDENTS VALUES ('101', 'Smith', 'Johnny', 'IS', 3.41, 18-May-92);
INSERT INTO STUDENTS VALUES ('102', 'Smith', 'Jack', 'FIN', 3.25, 11-March-90);
INSERT INTO STUDENTS VALUES ('103', 'Meyer', 'Jim', 'HRM', 2.82, 11-Oct-91);
INSERT INTO STUDENTS VALUES ('104', 'Brown', 'Jenny', 'IS', 2.78, 04-April-91);

SELECT * FROM STUDENTS;

spool off