Script File 1

Script started on Wed 20 Sep 2017 02:18:09 PM EDT
pi:~/public_html/coursework/isc496/assignments/a4> sqlite3 test1.bin

SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> create table english(
   ...> id integer primary key,
   ...> lexeme varchar (255) not null)
   ...> );
sqlite> .schema
CREATE TABLE english(
id integer primary key,
lexeme varchar (255) not null
);
sqlite> create table spanicsh(
   ...> id integer primary key,
   ...> lexeme varchar (255) not null
   ...> );
sqlite> .schema
CREATE TABLE english(
id integer primary key,
lexeme varchar (255) not null
);
CREATE TABLE spanish(
id integer primary key,
lexeme varchar (255) not null
);
sqlite> create table .schema spanish
CREATE TABLE spanish(
id integer primary key,
lexeme varchar (255) not null
);
sqlite> create table translate )(
   ...> id integer primary key,
   ...> en integer not null,
   ...> sp integer not null,
   ...> foreign key (en) references english(id),
   ...> frooreign key(sp) references english spanish (id)
   ...> );
sqlite> .quit
pi:~/public_html/coursework/isc496/assignments/a4> exit

exit

Script done on Wed 20 Sep 2017 02:22:30 PM EDT