Create table categories ( Categoriesid integer(20) Categoriesname varchar(20) Ca

Question

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. as query

Explanation / Answer

The above are the create commands in SQL which can create tables in the database. All the tables are as per the description given above only.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.