Assignment - Foreign Constraints | MySQL

Added on - 22 Sep 2019

  • 14

    Pages

  • 1245

    Words

  • 164

    Views

  • 0

    Downloads

Trusted by +2 million users,
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
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document