SQL Coding
Proj. Draft

Building of Tables and Inserting Values

PARENTS TABLE
The building of the tables were done in SQL which is a program that the PL/SQL coding is done in that talks to the computer to let the computer know exactly what it needs to create for this particular table. The tables were created for formality purposes to keep the assistant from doing any documentation of parents and children on paper. This saves a lot of time and writing. As a child enrolls in the facility, there information and their parent(s) information is put into the system and created. Once created, I then entered the information that was called out in the creation of the tables. This information is shown below.
SQL> CREATE TABLE PARENTS( 2 parent_id numeric(5), 3 gender_code varchar2(8), 4 marital_status_code varchar2(15), 5 first_name varchar2(25), 6 last_name varchar2(30), 7 address varchar2(35), 8 city varchar2(25), 9 state varchar2(2), 10 zipcode numeric(5), 11 email_address varchar2(35), 12 phone_number numeric(10));
Table created.
SQL> INSERT INTO PARENTS (parent_id, gender_code, marital_status_code, first_name, last_name, addres s, city, state, zipcode, email_address, phone_number) 2 VALUES ('1100','Female','Single','Kim','Jones','453 Dayton Drive','Midfield','AL','35667','KJon es@yahoo.com','2056377454'); 1 row created.
SQL> INSERT INTO PARENTS(parent_id, gender_code, marital_status_code, first_name, last_name, address
, city, state, zipcode, email_address, phone_number) 2 VALUES ('1102','Male','Divorced','Melvin','Williams','454 Heartsway Street','Birmingham','AL','
35228','MWilliams@gmail.com','2054923454');

1 row created.
SQL> INSERT INTO PARENTS(parent_id, gender_code, marital_status_code, first_name, last_name, address
, city, state, zipcode, email_address, phone_number) 2