|
Server IP : 172.16.15.8 / Your IP : 3.137.164.229 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/cmsalazar/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
drop table STUDENT;
create table STUDENT (ID int, FIRSTNAME varchar(20), LASTNAME varchar(20), GENDER varchar(6));
insert into STUDENT values (1001, "Josh", "Smith", "Male");
insert into STUDENT values (1002, "Ann", "Brown", "Female");
select * from STUDENT;
drop table EVALUATION;
create table EVALUATION (GENDER varchar(6), GRADE varchar(10), COURSE varchar(10), LECT_PREP int, STU_PART int, OVERALL int);
insert EVALUATION values ("Female", "Sophmore", "CS212", 1, 2, 0);
insert EVALUATION values ("Male", "Junior", "CS489", 0, 2, 2);
insert EVALUATION values ("Male", "Freshman", "CS205", 0, 2, 2);
select * from EVALUATION;