Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE hardver;
- USE hardver;
- CREATE TABLE uvoznici(id INT(4) AUTO_INCREMENT NOT NULL,
- naziv VARCHAR(20) NOT NULL,
- mesto VARCHAR(20) NOT NULL,
- telefon VARCHAR(20) NOT NULL,
- adresa VARCHAR(100) NOT NULL,
- CONSTRAINT uvoznici_pk PRIMARY KEY(id));
- INSERT INTO uvoznici (id, naziv, mesto, telefon, adresa)
- VALUES (NULL, 'Samsung', 'Beograd', '+381667924635', 'Petra Deljanina 67'),
- (NULL, 'NVIDIA', 'Novi Sad', '+381642531976', 'Milosa Crnjanskog 71'),
- (NULL, 'Intel', 'Leskovac', '+381612473892', 'Prvomajska 23');
- CREATE TABLE komponente(id INT(4) AUTO_INCREMENT NOT NULL,
- naziv VARCHAR(20) NOT NULL,
- vrsta VARCHAR(20) NOT NULL,
- nabavna_cena INT NOT NULL,
- prodajna_cena INT NOT NULL,
- stanje INT NOT NULL,
- id_uvoznika INT(4) NOT NULL,
- CONSTRAINT komponente_pk PRIMARY KEY(id),
- CONSTRAINT uvoznici_komponente_fk FOREIGN KEY(id_uvoznika) REFERENCES uvoznici(id));
- INSERT INTO komponente (id, naziv, vrsta, nabavna_cena, prodajna_cena, stanje, id_uvoznika)
- VALUES (NULL, 'Galaxy S9', 'Telefon', '26000', '110000', '1000', '1'),
- (NULL, 'Note 8', 'Telefon', '18000', '90000', '340', '1'),
- (NULL, 'Galaxy A', 'Telefon', '15000', '35000', '600', '1'),
- (NULL, 'Galaxy J', 'Telefon', '12000', '45000', '250', '1'),
- (NULL, 'Galaxy S8', 'Telefon', '20000', '75000', '300', '1'),
- (NULL, 'GeForce GTX 1080Ti', 'Graficka', '30000', '140000', '570', '2'),
- (NULL, 'GeForce GTX 1070', 'Graficka', '12000', '65000', '300', '2'),
- (NULL, 'GeForce GTX 1060Ti', 'Graficka', '16000', '55000', '520', '2'),
- (NULL, 'GeForce GTX 1050', 'Graficka', '13000', '40000', '240', '2'),
- (NULL, 'GeForce TITAN XP', 'Graficka', '25000', '150000', '333', '2'),
- (NULL, 'Core i5-8600k', 'Procesor', '13000', '30000', '610', '3'),
- (NULL, 'Core i3-8300', 'Procesor', '6000', '18000', '225', '3'),
- (NULL, 'Core i9-7900x', 'Procesor', '30000', '130000', '650', '3'),
- (NULL, 'Core i7-7820X', 'Procesor', '20000', '70000', '210', '3'),
- (NULL, 'Core i7-8700K', 'Procesor', '6000', '44000', '632', '3');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement