Axborot tizimlarining matematik va dasturiy ta’minoti yo’nalishi

INSERT INTO `customers`( `family`, `name`, `phone_number`, `address`, 
`cars_idcars`, `cars_bus_stations_idbus_stations`) VALUES 
('Yusupov','Sarvarbek','[phone]',"Kattaqo'rg'on",8,4); 
 
CREATE TABLE staff (idstaff INT (5) NOT NULL PRIMARY KEY 
AUTO_INCREMENT, 
leader VARCHAR(50) NOT NULL, 
accountant VARCHAR(50) NOT NULL, 
the_guard VARCHAR(50) NOT NULL, 
bus_stations_idbus_stations INT (5) NOT NULL, 
income_and_expenditure_idincome_and_expenditure INT (5) NOT NULL); 
INSERT INTO `staff`( `leader`, `accountant`, `the_guard`, 
`bus_stations_idbus_stations`, 
`income_and_expenditure_idincome_and_expenditure`) VALUES

---

30 
('Asadov','Bahodirov','Bozorov',2,5), 
('Amirov','Shermatov','Davronov',1,3), 
('Otajonov','Egambediyev','Pavlonov',5,7), 
('Quljonov','Olimov','Bozorov',9,9), 
('Ergashev','Salimov','Shermatov',10,4), 
('Bozorov','Aminov','Axrorov',4,10), 
('Alimov','Faxridinov','Jumanov',3,1), 
('Asqarov','Zokirov','Akbarov',7,2), 
('Akbarjonova','Vahobov','Mardonov',5,6), 
('Akmalov','Salimov','Davonov',5,10); 
CREATE TABLE income_and_expenditure (dincome_and_expenditure INT
(5) NOT NULL PRIMARY KEY AUTO_INCREMENT, 
i_dream FLOAT NOT NULL, 
expenses FLOAT NOT NULL); 
INSERT INTO `income_and_expenditure`( `i_dream`, `expenses`) VALUES 
('100000.3','55000.5'); 
INSERT INTO `income_and_expenditure`( `i_dream`, `expenses`) VALUES 
('100085.8','65000.5'); 
INSERT INTO `income_and_expenditure`( `i_dream`, `expenses`) VALUES 
('500000.3','105000.5'); 
INSERT INTO `income_and_expenditure`( `i_dream`, `expenses`) VALUES 
('950000.3','46000.2');