Showing pages 1 to 4 of 14 pages
INFS ASSIGNMENT 21|P a g e28October,2016DATABASEQUERYREPORTSTUDENT
ContentsCREATETABLESTATEMENTS.................................................................................................................2SELECTSTATEMENTS.............................................................................................................................7SQLQUERIES........................................................................................................................................10SQLVIEWS...........................................................................................................................................112|P a g e
CREATE TABLE STATEMENTSCreatetableONLINE_CLINICIAN(OIDintprimarykey,Phonedouble,eMailvarchar(20),FNamevarchar(20),LNamevarchar(20),Addressvarchar(50));createtableHOME_USER(UIDvarchar(20)primarykey,Phonedouble,eMailvarchar(20),FNamevarchar(20),LNamevarchar(20),Addressvarchar(50),OIDint,constrainth_fkforeignkey(OID)referencesONLINE_CLINICIAN(OID)ondeletesetnull);createtableQUESTION(QIDintprimarykey,QTextvarchar(30),Typevarchar(20),QTimestamptimestamp,3|P a g e
You are reading a preview
Upload your documents to download orBecome a Desklib member to get access