Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sss
--a) create table shipping_service( ship_ID decimal(12), name varchar(32), primary key(ship_ID) ); create table Package( package_ID decimal(12), description varchar(25), date_delivered date, ship_ID decimal(12) references shipping_service(ship_ID), primary key(package_ID)); insert into shipping_service(ship_ID, name) VALUES ('1001', 'Kazpost'), ('1002', 'DHL'), ('1003', 'FedEx'), ('1004', 'PonyExpress'); insert into Package(package_ID, description, date_delivered, ship_ID) VALUES ('9001','IT devices', '25-May-2019', '1001'), ('9002','fragile box', '15-June-2019', '1002'), ('9003','sport equipment', '20-Apr-2018', '1003'), ('9004','express mail', '22-July-2019', null)
run
|
edit
|
history
|
help
0
PostreSQL: warehouse table
Food Delivery Website SQL Analysis
Final test
Descriptor test
Movie Rating SQL Analysis Project
3
Q4_2
prec
SQL social network practice by Han Wang 20200720 - 2
statistics