Quiz RDMS 22/02 [MySql Command]

Mysql Command

a. create database Raju_Clinic;

b. create table Patient (patientNo varchar(4) primary key,
                                  patient_ic varchar(12),
                                  patient_Name varchar(50),
                                  patient_address varchar(100),
                                  patient_mobile int(12))engine:innodb;

    create table Treatment (treatmentId varchar(4) primary key,
                                       treat_date date,
                                       treat_time time,
                                       patientNo varchar(4),
                                       foreign key (patientNo) references Patient
                                       (patientNo))engine:innodb;

    create table Doctor (DoctorId varchar(4) primary key,
                                  Doctor_Name varchar(50),
                                  TypeOFSick varchar(100),
                                  Medication varchar(100),
                                  TreatmentId varhcar(4),
                                  foreign key (TreatmentId) references Treatment
                                  (TreatmentId))engine:innodb;

   create table Pharmacy (PharmacyNo varchar(4) primary key,
                                      Price int(5),
                                      Recipe_Date date,
                                      DoctorId varchar(4),
                                      foreign key (DoctorId) references Doctor (DoctorId))engine:innodb;

c. show databases;

d. show tables;

e. describe Patient;
    describe Treatment;
    describe Doctor;
    describe Pharmacy;

f. insert into Patient values ("P001","890521056889","Ahmad","Jalan
   Merbau","0124567896");
   insert into Patient values ("P002:,"780316015686","Rita","Jalan Jati","0136548576");

g. select * from Patient;
    select * form Treatment;
    select * from Doctor;
    select * from Pharmacy;

h. drop database Raju_Clinic;