Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Assignment 1(SET A)
create table hospital12 (h_no int primary key,h_name varchar(20),city varchar (20)); create table Doctor12 (d_no int primary key,d_name varchar (20),city varchar (20)); ---many to many relationship create table hospital12doctor12( h_no int, d_no int, Foreign key (h_no) references hospital12 (h_no), Foreign key (d_no) references Doctor12 (d_no), unique(h_no,d_no)); insert into hospital12 values (50,'KEM','pune'); insert into hospital12 values (51,'YCM','chinchwad'); insert into hospital12 values (53,'ruby hall','pune'); insert into doctor12 values (5,'vijay','pune'); insert into doctor12 values (6,'pallavi','chinchwad'); insert into doctor12 values (7,'nirmal','pune'); select * from hospital12doctor12;
run
|
edit
|
history
|
help
0
E-Commerce SQL Analysis by Ran Li
PostreSQL: Today's Date/Time
SQL social network practice by Han Wang 20200720 - 2
2
Final 1
hell
Ecommerce Website Analysis by SQL
PostgreSQL Sandbox: Legitimate Resale
IF IN POSTGRESQL
Assignment 1(SET A)