Database
Click to view a sample of my work
Click here to download the full version on the Animal Shelter Powerpoint Presentation (examples below)
A table and the SQL code used to create it |
Student Table
|
CREATE TABLE "STUDENTS"
( "STU_ID" NUMBER(7,0),
"FIRST_NAME" VARCHAR2(25) CONSTRAINT "SA_STU_FN_NN" NOT NULL ENABLE,
"LAST_NAME" VARCHAR2(40) CONSTRAINT "SA_STU_LN_NN" NOT NULL ENABLE,
"CONTACT_PHONE" VARCHAR2(20), "EMAIL" VARCHAR2(80),
"EXPECTED_GRADUATION_DATE" DATE, "ADDRESS1" VARCHAR2(50),
"ADDRESS2" VARCHAR2(50),
"CITY" VARCHAR2(40),
"STATE_PROVINCE" VARCHAR2(30),
"POSTAL_CODE" VARCHAR2(10),
"COUNTRY" VARCHAR2(40),
CONSTRAINT "SA_STU_PK" PRIMARY KEY ("STU_ID") ENABLE
)
/
|
Dual-enrollment with NOVA Community College in this course
