logo

Assignment - Foreign Constraints | MySQL

14 Pages1245 Words258 Views
   

Added on  2019-09-22

Assignment - Foreign Constraints | MySQL

   Added on 2019-09-22

ShareRelated Documents
Assignment - Foreign Constraints | MySQL_1
INFS ASSIGNMENT 21 | P a g e28 October, 2016DATABASE QUERY REPORTSTUDENT
Assignment - Foreign Constraints | MySQL_2
ContentsCREATE TABLE STATEMENTS.................................................................................................................2SELECT STATEMENTS.............................................................................................................................7SQL QUERIES........................................................................................................................................10SQL VIEWS...........................................................................................................................................112 | P a g e
Assignment - Foreign Constraints | MySQL_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
Assignment - Foreign Constraints | MySQL_4

End of preview

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

Related Documents
Database Management System Assignment 2022
|32
|6949
|24

Draft SQL Implementation Assignment
|12
|1254
|190

Assignment on Database PDF
|14
|2236
|34

Employee Database: ER Diagram, Table Commands, Sample Data, SQL Queries
|15
|704
|88

Enterprise Rules - Hospital Management System
|22
|1437
|45

Database Design and Implementation PDF
|9
|1080
|11