Script started on Mon 25 Sep 2017 02:27:57 PM EDT [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> php tables.php Created/opened the database Created table english Created spanish table Created translate table [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> php insert[K[K[K[K[K[K[K[K[Kswlite3[K[K[K[K[K[Kqlite3 pdo.db SQLite version 3.11.0 2016-02-15 17:29:24 Enter ".help" for usage hints. sqlite> .column [K[K[K[K[K[K[Kmode column sqlite> .schema CREATE TABLE english( id INTEGER PRIMARY KEY,lexeme VARCHAR(255) UNIQUE NOT NULL); CREATE TABLE spanish( id INTEGER PRIMARY KEY,lexeme VARCHAR (255) UNIQUE NOT NULL); CREATE TABLE translate( id INTEGER PRIMARY KEY,en INTEGER UNIQUE NOT NULL,sp INTEGER UNIQUE NOT NULL,FOREIGN KEY(en) REFERENCES english(id)FOREIGN KEY(sp) REFERENCES spanish(id)); sqlite> select * from english; sqlite> .quit [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> php inseret[K[Kt1.php Created/opened the database 0 => hello, hola hello|hola| inserted 'hello' into english row id is 1 inserted 'hola' into spanish row id is 1 inserted 1, 1 into translate 1 => science, ciencia science|ciencia| inserted 'science' into english row id is 2 inserted 'ciencia' into spanish row id is 2 inserted 2, 2 into translate [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> sqlite3.p[K[K pdo.db SQLite version 3.11.0 2016-02-15 17:29:24 Enter ".help" for usage hints. sqlite> .mode column sqlite> select * for[K[Krom english; 1 hello 2 science sqlite> select * from spanissh[K[Kh; 1 hola 2 ciencia sqlite> select * from translate; 1 1 1 2 2 2 sqlite> .quit [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> php insert2.php;[K Created/opened the database 0 => laptop, ordenador portátil Test 1 laptop|ordenador portátil| inserted 'laptop' into english row id is 3 inserted 'ordenador portátil' into spanish row id is 3 inserted 3, 3 into translate 1 => internet, internet Test 1 internet|internet| inserted 'internet' into english row id is 4 inserted 'internet' into spanish row id is 4 inserted 4, 4 into translate [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> sqlite 3 pdo.db SQLite version 3.11.0 2016-02-15 17:29:24 Enter ".help" for usage hints. sqlite> .mode column sqlite> select* from E[Kenglish; 1 hello 2 science 3 laptop 4 internet sqlite> slect * from spanish;[1@e[1P[C[1@e 1 hola 2 ciencia 3 ordenador 4 internet sqlite> select * from translate; 1 1 1 2 2 2 3 3 3 4 4 4 sqlite> .qi[Kuit [4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> exit exit Script done on Mon 25 Sep 2017 02:35:21 PM EDT