Question: Make them in Oracle or MySQL. Then send me each screenshot of each table. CREATE TABLE Patient( SSN INTEGER NOT NULL PRIMARY KEY, Gender CHAR(1),

Make them in Oracle or MySQL. Then send me each screenshot of each table.

CREATE TABLE Patient(

SSN INTEGER NOT NULL PRIMARY KEY,

Gender CHAR(1),

MedicalInsurance VARCHAR(30)

);

CREATE TABLE Department(

DID INTEGER NOT NULL PRIMARY KEY,

Name VARCHAR(30),

Address VARCHAR(255)

);

CREATE TABLE Admission(

PID INTEGER,

DID INTEGER,

Time DATETIME,

PRIMARY KEY(PID, DID),

FOREIGN KEY(PID) REFERENCES Patient(SSN),

FOREIGN KEY(DID) REFERENCES Department(DID),

);

CREATE TABLE Bed(

BNumber INTEGER NOT NULL PRIMARY KEY,

Size INTEGER,

DID INTEGER,

FOREIGN KEY(DID) REFERENCES Department(DID)

);

CREATE TABLE Treatment(

TID INTEGER NOT NULL PRIMARY KEY,

Detail VARCHAR(100)

);

CREATE TABLE PatientTreatment(

PID INTEGER,

TID INTEGER,

PRIMARY KEY(PID, TID),

FOREIGN KEY(PID) REFERENCES Patient(SSN),

FOREIGN KEY(TID) REFERENCES Treatment(TID)

);

CREATE TABLE Employee(

EID INTEGER NOT NULL PRIMARY KEY,

ENAME VARCHAR(100),

Salary REAL(10,2),

Schedule VARCHAR(100),

DID INTEGER,

FOREIGN KEY(DID) REFERENCES Department(DID)

);

CREATE TABLE Technician(

DID INTEGER,

Technician VARCHAR(100),

Machine VARCHAR(100),

ProductDate DATE,

FOREIGN KEY(DID) REFERENCES Department(DID)

);

SELECT * FROM Patient;

SELECT * FROM Department;

SELECT * FROM Treatment;

SELECT * FROM Admission;

SELECT * FROM Bed;

SELECT * FROM Employee;

SELECT * FROM PatientTreatment;

SELECT * FROM Technician;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!