INFS ASSIGNMENT 21 | P a g e28 October, 2016DATABASE QUERY REPORTSTUDENT
ContentsCREATE TABLE STATEMENTS.................................................................................................................2SELECT STATEMENTS.............................................................................................................................7SQL QUERIES........................................................................................................................................10SQL VIEWS...........................................................................................................................................112 | P a g e
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
Found this document preview useful?
Related Documents
Database Management System Assignment 2022lg...
|32
|6949
|24
Draft SQL Implementation Assignmentlg...
|12
|1254
|190
Assignment on Database PDFlg...
|14
|2236
|34
Employee Database: ER Diagram, Table Commands, Sample Data, SQL Querieslg...