Create table categories ( Categoriesid integer(20) Categoriesname varchar(20) Categoriespicture Primary key Categoriesid Foreign key Categoriesid reference categories )

Create table comments ( Commentsid integer(20) Text varchar(20) Commentsdate date Primary key Commentsid Foreign key Commentsid reference comments )

create table dictionary ( word varchar(20) picture video )

create table list ( listid integer lname varchar(20) Primary key listid )

create table message ( date date subject varchar(20) Email varchar(20) s.name varchar(20) MSG varchar(20) )

create table record ( username varchar(20 Email varchar(20 f.name varchar(20 l.name varchar(20 password Primary key (username, Email ) ) ]

create table test ( testno integer Time Level varchar Primary key testno )

create table question ( Qid integer Qtext varchar(40) c.answer varchar(40) option 1 varchar(40) option 2 varchar(40) option 3 varchar(40) primary key Qid ) create table answer ( Qid integer Actual.answer varchar(40) Primary key Qid Foreign key Qid reference question )

create table has2 ( testno integer Qid integer Primary key (Qid, testno) Foreign key Qid reference question Foreign key testno reference test )

create table has ( Categoriesid integer(20) Primary key Categoriesid Foreign key Categoriesid reference Categories )

create table contact ( )

create table post ( cid integer primary key cid Foreign key cid reference comment )

create table create ( lid integer primary key lid Foreign key lid reference list )

create table instructor ( username varchar(20) primary key username Foreign key username reference records )

create table registereduser ( username varchar(20) primary key username Foreign key username reference records )

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

1. Provide SQL statements to create all of the relations/ views in your database.

2. Provide insert, update delete statements used in your database.