Trusted by +2 million users,
1000+ happy students everyday
1000+ happy students everyday
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’re reading a preview
To View Complete Document
Click the button to download
Subscribe to our plans