logo

Recommendation System

   

Added on  2019-09-22

14 Pages1245 Words258 Views
 | 
 | 
 | 
Recommendation System_1

INFS ASSIGNMENT 21 | P a g e28 October, 2016DATABASE QUERY REPORTSTUDENT
Recommendation System_2

ContentsCREATE TABLE STATEMENTS.................................................................................................................2SELECT STATEMENTS.............................................................................................................................7SQL QUERIES........................................................................................................................................10SQL VIEWS...........................................................................................................................................112 | P a g e
Recommendation System_3

CREATE TABLE STATEMENTSCreate table ONLINE_CLINICIAN(OID int primary key,Phone double,eMail varchar(20),FName varchar(20),LName varchar(20),Address varchar(50));create table HOME_USER (UID varchar(20) primary key,Phone double,eMail varchar(20),FName varchar(20),LName varchar(20),Address varchar(50),OID int,constraint h_fk foreign key(OID) references ONLINE_CLINICIAN(OID) on delete set null);create table QUESTION(QID int primary key,QText varchar(30),Type varchar(20),QTimestamp timestamp,3 | P a g e
Recommendation System_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents