i send you a file . i have already finish supplier , depot and product sql codes . pls make it unique
Create Table Supplier
(Supplier_id Varchar(8) not null,
Name Varchar(15) not null,
Address Varchar (30) not null,
Email Varchar(30),
Constraint SSM10 Primary Key (Supplier_id)) ;
Insert into Supplier
values
('P101', 'James Hetfield', 'London', '');
Insert into Supplier
values
('P102', 'Ian M', 'London', '');
Insert into Supplier
values
('P103', 'Zeenat B', 'Cambridge', '');
Insert into Supplier
(Supplier_id, Name, Address)
values
('P104', 'Syed M', 'Cambridge');
Insert into Supplier
(Supplier_id, Name, Address)
values
('P105', 'Pawel C', 'Glasgow');
Insert into Supplier
(Supplier_id, Name, Address)
values
('P106', 'Ammar Z', 'London');
Insert into Supplier
values
('P107', 'Joshua N', 'Glasgow', '');
Insert into Supplier
values
('P108', 'Mike B', 'Cardiff', '');
Insert into Supplier
values
('P109', 'Shumi S', 'Oxford', '');
Create Table Depot
(Depot_Id Varchar(6) not null,
Location Varchar (20) not null,
Address Varchar(60),
Constraint DESM10 Primary Key (Depot_Id));
Insert into Depot
values
('DEP001','North London', 'Southgate-N12 2YN');
Insert into Depot
values
('DEP002','South London', 'Croydon-S11 7NN');
Insert into Depot
values
('DEP003','West London', 'Hyde Park Corner-W01 8YY');
Insert into Depot
values
('DEP004','East London', 'Docklands-E12 2BT');
Insert into Depot
values
('DEP005','Cambridge', 'C17 2BB');
Insert into Depot
values
('DEP006','Glasgow', 'Glasgow-G08 77T');
Insert into Depot
values
('DEP007','Chester', 'CH1 56U');
Insert into Depot
values
('DEP008','Kingston upon Hull', 'Kingston upon Hull12-KI9 R55');
Create Table Product
(Product_Id Varchar(6) not null,
Description Varchar(30),
Price Number(6,2) not null,
Supplier_id Varchar(4) not null,
Constraint PSM10 Primary Key (Product_Id),
Constraint PMS20 Foreign Key (Supplier_id) references Supplier (Supplier_id));
Insert into Product
values
('AB2101', 'PC-Z120', 500.00, 'P101');
Insert into Product
values
('AB2102','PC-P500', 900.00, 'P101');
Insert into Product
values
('AB2103', 'PC-T1', 1500.00, 'P101');
Insert into Product
values
('AB2104', 'Laptop-P051', 800.00, 'P102');
Insert into Product
values
('AB2105', 'Laptop-E6500', 1200.00, 'P102');
Insert into Product
values
('AB2106', 'Ultrabook-U100', 1000.00, 'P103');
Insert into Product
values
('AB2107', 'Ultrabook-U200', 1100.00, 'P103');
Insert into Product
values
('AB2108', 'Tablet-ER10', 400.00, 'P104');
Insert into Product
values
('AB2109', 'Tablet-ER11', 499.00, 'P104');
Insert into Product
(Product_Id, Price, Supplier_id)
values
('AB2110', 300.00, 'P105');
Insert into Product
(Product_Id, Price, Supplier_id)
values
('AB2111', 200.00, 'P106');