I gang

Database system

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', [url removed, login to view], 'P101');

Insert into Product

values

('AB2102','PC-P500', [url removed, login to view], 'P101');

Insert into Product

values

('AB2103', 'PC-T1', [url removed, login to view], 'P101');

Insert into Product

values

('AB2104', 'Laptop-P051', [url removed, login to view], 'P102');

Insert into Product

values

('AB2105', 'Laptop-E6500', [url removed, login to view], 'P102');

Insert into Product

values

('AB2106', 'Ultrabook-U100', [url removed, login to view], 'P103');

Insert into Product

values

('AB2107', 'Ultrabook-U200', [url removed, login to view], 'P103');

Insert into Product

values

('AB2108', 'Tablet-ER10', [url removed, login to view], 'P104');

Insert into Product

values

('AB2109', 'Tablet-ER11', [url removed, login to view], 'P104');

Insert into Product

(Product_Id, Price, Supplier_id)

values

('AB2110', [url removed, login to view], 'P105');

Insert into Product

(Product_Id, Price, Supplier_id)

values

('AB2111', [url removed, login to view], 'P106');

Færdigheder: Database Administration, MySQL, Software Testning, SQL, Hjemmeside Testning

Se mere: sql create table price, product supplier database, park west, location testing, james park, joshua hull, oxford, oxford b, m park, joshua, glasgow, east london, database system, cardiff, ammar, foreign key, database system sql, n12 tablet, software tablet, laptop supplier, software product testing, testing product, null software, email already system, tablet database

Om arbejdsgiveren:
( 20 bedømmelser ) Limassol, Cyprus

Projekt-ID: #4112860

2 freelancere byder i gennemsnit €80 for dette job

winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

€110 EUR in 5 dage
(22 bedømmelser)
5.2
ultrasonicsoft

Hi, I could deliver you this. Thanks!

€50 EUR in 2 dage
(6 bedømmelser)
3.3