Create database Videoteka3

use Videoteka3

Create table MovieStar(id_star int primary key, name_star varchar(30), gender char(1) not null, birthday date not null);

Create table Studio(id_studio int primary key, name_studio varchar(30) not null, adress_studio varchar(30) not null);

Create table MovieExec(id_prod int primary key, name_prod varchar(30) not null, adress_prod varchar(30) not null, networth numeric(9,2) not null);

Create table Movie(id_title int primary key, name_title varchar(30) not null, god_filma int not null, lenght int not null, mcolor varchar(7) not null, id_studio int foreign key references Studio(id_studio), id_prod int foreign key references MovieExec(id_prod));

Create table StarSLN(id_title int not null foreign key references Movie(id_title), id_star int foreign key references MovieStar(id_star) not null);

-------------------------------------------------------------------------------------------------------------------------------------

Create type id_int from int;

Create type bul from char(1);

Create type nazv from varchar(30);

----------------------------------------------------

Create index films on Movie(name_title);

Create index studia on Studio(name_studio);

Create index acter on MovieStar(name_star);

Create index god_filma on Movie(god_filma);

Create index adress_studii on Studio(adress_studio);

----------------------------------------------------

insert into Studio(id_studio,name_studio,adress_studio) values(1,'20th Centgury Fox','Columbia');

insert into Studio(id_studio,name_studio,adress_studio) values(2,'Columbia Pictgures','Hollywood');

insert into Studio(id_studio,name_studio,adress_studio) values(3,'Paramount Pictures','Hollywood');

insert into Studio(id_studio,name_studio,adress_studio) values(4,'Warner Bros.','Hollywood');

------------------------------------------------------------------------------------------------------------

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(1,'Neil LaBute','Hollywood', 900000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(2,'David Mamet','New York', 1300000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(3,'Marlowe Fawcett','Hollywood', 756000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(4,'Woody Allen','Hollywood', 800000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(5,'Darren Lynn Bousman','New York', 1000000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(6,'Nancy Meyers','Hollywood', 1240000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(7,'Robert Zemeckis','Dallas', 2500000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(8,'Russel Mulcahy','Hollywood', 700000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(9,'John Polson','Hollywood', 600000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(10,'Rogegr Michell','Detroit', 600000);

insert into MovieExec(id_prod,name_prod,adress_prod, networth) values(11,'Shawn Levy','Hollywood', 1800000);

------------------------------------------------------------------------------------------------------------

insert into MovieStar(id_star,name_star,gender, birthday) values(1,'Alec Baldwin','M', '1967.12.12');

insert into MovieStar(id_star,name_star,gender, birthday) values(2,'Angus

MacFadyen','M', '1969.07.04');

insert into MovieStar(id_star,name_star,gender, birthday) values(3,'Ben Stgiller','M', '1970.09.25');

insert into MovieStar(id_star,name_star,gender, birthday) values(4,'Bob Hoskins','M', '1975.01.30');

insert into MovieStar(id_star,name_star,gender, birthday) values(5,'Cameron Diaz','F', '1973.12.31');

insert into MovieStar(id_star,name_star,gender, birthday) values(6,'Charles Durning','M', '1964.07.04');

insert into MovieStar(id_star,name_star,gender, birthday) values(7,'Christopher Lloyd','M', '1978.01.31');

insert into MovieStar(id_star,name_star,gender, birthday) values(8,'Ellen Burstyn','F', '1967.12.13');

insert into MovieStar(id_star,name_star,gender, birthday) values(9,'F. Murray Abraham','M', '1979.01.30');

insert into MovieStar(id_star,name_star,gender, birthday) values(10,'Gilian Kearney','F', '1974.09.25');

insert into MovieStar(id_star,name_star,gender, birthday) values(11,'Hugh Grant','M', '1980.11.17');

insert into MovieStar(id_star,name_star,gender, birthday) values(12,'Jesse Bradford','F', '1967.07.04');

insert into MovieStar(id_star,name_star,gender, birthday) values(13,'Joanna Cassidy','F', '1967.12.29');

insert into MovieStar(id_star,name_star,gender, birthday) values(14,'John Lone','M', '1980.12.18');

insert into MovieStar(id_star,name_star,gender, birthday) values(15,'Jonothan Broke','M', '1977.01.30');

insert into MovieStar(id_star,name_star,gender, birthday) values(16,'Jude Law','F', '1977.09.25');

insert into MovieStar(id_star,name_star,gender, birthday) values(17,'Julia Robertgs','F', '1980.12.18');

insert into MovieStar(id_star,name_star,gender, birthday) values(18,'Kate Winslet','F', '1979.10.15');

insert into MovieStar(id_star,name_star,gender, birthday) values(19,'Molly Parker','M', '1974.01.20');

insert into MovieStar(id_star,name_star,gender, birthday) values(20,'Nicolas Cage','M', '1969.03.04');

insert into MovieStar(id_star,name_star,gender, birthday) values(21,'Penelope Ann Miller','F', '1970.09.25');

insert into MovieStar(id_star,name_star,gender, birthday) values(22,'Robin Williams','M', '1980.12.18');

insert into MovieStar(id_star,name_star,gender, birthday) values(23,'Shiri Appleby','F', '1969.07.04');

insert into MovieStar(id_star,name_star,gender, birthday) values(24,'Tobin Bell','M', '1983.12.14');

insert into MovieStar(id_star,name_star,gender, birthday) values(25,'Vinnie Jones','M', '1981.11.18');

insert into MovieStar(id_star,name_star,gender, birthday) values(26,'Woody Allen','M', '1968.07.09');

-------------------------------------------------------------------------------------------------------

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(1,'Mighty Afrodite','1995', 95, 'true', 1,4);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(2,'Night atg the Museum','2006', 104, 'true',2,11);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(3,'Notting Hill','1999', 115, 'true',1,10);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(4,'Saw III','2006', 112, 'true',4,5);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(5,'Statge and Main','2000', 101, 'true',3,2);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(6,'Swimfan','2002', 84, 'true',4,9);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(7,'The Holiday','2006', 132, 'true',2,6);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(8,'The Other Half','2006', 96, 'true',4,3);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio,

id_prod) values(9,'The Shadow','1994', 102, 'true',1,8);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(10,'The Wicker Man','2006', 97, 'true',2,1);

insert into Movie(id_title,name_title, god_filma, lenght, mcolor, id_studio, id_prod) values(11,'Who Framed Rogggger Rabbit','1988', 99, 'true',4,7);

-----------------------------------------------------

insert into StarSLN(id_title,id_star) values (7, 5);

insert into StarSLN(id_title,id_star) values (7, 18);

insert into StarSLN(id_title,id_star) values (7, 16);

insert into StarSLN(id_title,id_star) values (5, 1);

insert into StarSLN(id_title,id_star) values (5, 6);

insert into StarSLN(id_title,id_star) values (2, 3);

insert into StarSLN(id_title,id_star) values (2, 22);

insert into StarSLN(id_title,id_star) values (3, 17);

insert into StarSLN(id_title,id_star) values (3, 11);

insert into StarSLN(id_title,id_star) values (1, 26);

insert into StarSLN(id_title,id_star) values (1, 9);

insert into StarSLN(id_title,id_star) values (6, 12);

insert into StarSLN(id_title,id_star) values (6, 23);

insert into StarSLN(id_title,id_star) values (9, 1);

insert into StarSLN(id_title,id_star) values (9, 14);

insert into StarSLN(id_title,id_star) values (9, 21);

insert into StarSLN(id_title,id_star) values (8, 25);

insert into StarSLN(id_title,id_star) values (8, 10);

insert into StarSLN(id_title,id_star) values (4, 24);

insert into StarSLN(id_title,id_star) values (4, 2);

-----------------------------------------

/*Vizualinoe Predstgavlenie*/

Create view Kin4iki as

select id_title,name_title,lenght

from Movie

select * from Kin4iki

Create view Akteri as

select id_star,Name_star,Birthday

from MovieStar

select * from Akteri

Create view Studia as

select Name_Studio,Adress_Studio

from Studio

select * from Studia

------------------------------------------

select name_title Film_s_etim_akterom

From Movie, MovieStar, StarSLN

Where Movie.id_title=StarSLN.id_title and MovieStar.id_star=StarSLN.id_star and name_star ='Tobin Bell'

-----------------------

drop table Movie

drop table MovieStar

drop table Studio

drop table StarSLN

drop table MovieExec

-----------------------

select * from Movie

select * from MovieStar

select * from Studio

select * from StarSLN

select * from MovieExec

----------------------

select name_star,birthday

From Movie, MovieStar, StarSLN

Where Movie.id_title=StarSLN.id_title and MovieStar.id_star=StarSLN.id_star and movie.god_filma >'1950'

E.R Видиотека:

QR:

create database sea_battles

use sea_battles

create table classes(idClass int primary key,nameClass varchar(30),type varchar(2),Country varchar(30),numguns int, bore int, displaceme int)

create table battles(idBattle int primary key,nameBattle varchar(30),dates date,datee date)

create table ship(idShip int primary key, nameShip varchar(30),idClass int foreign key references classes,launched int)

create table outcomes(idShip int foreign key references ship, idBattle int foreign key references battles, result varchar(30))

---

insert into classes values (1,'bismark','bb','germany',8,15,42000)

insert into classes values (2,'lowa','bb','usa',9,16,46000)

insert into classes values (3,'kongo','bc','japan',8,14,32000)

insert into classes values (4,'northCalifornia','bb','usa',9,16,37000)

insert into classes values (5,'renown','bc','gtBritain',6,15,32000)

insert into classes values (6,'revenge','bb','gtBritain',8,15,29000)

insert into classes values (7,'tenessee','bb','usa',12,14,32000)

insert into classes values (8,'yamato','bb','japan',9,18,65000)

---

insert into battles values (1,'northAntlactic','1941-05-24','1941-05-27')

insert into battles values (2,'guadalcanal','1942-11-15','1942-11-15')

insert into battles values (3,'northCape','1943-12-26','1943-12-26')

insert into battles values (4,'surigaoStrait','1944-10-25','1944-10-25')

---

insert into ship values (1,'bismarc',1,1919)

insert into ship values (2,'california',7,1921)

insert into ship values (3,'dukeOfYork',1,1911)

insert into ship values (4,'fuso',8,1921)

insert into ship values (5,'haruna',3,1915)

insert into ship values (6,'hiei',3,1914)

insert into ship values (7,'hood',1,1932)

insert into ship values (8,'lowa',2,1940)

insert into ship values (9,'kingGeorgeV',7,1933)

insert into ship values (10,'kirishima',3,1915)

---

insert into outcomes values (1,1,'sunk')

insert into outcomes values (2,4,'ok')

insert into outcomes values (3,3,'ok')

insert into outcomes values (4,4,'sunk')

insert into outcomes values (7,1,'sunk')

insert into outcomes values (9,1,'ok')

insert into outcomes values (10,2,'sunk')

Select NameShip,Numguns

from classes,battles,ship,outcomes

where (classes.idClass=ship.idClass)and(ship.idShip=outcomes.idShip)and

(battles.idBattle=outcomes.idBattle) and (battles.nameBattle='SurigaoStrait') and

(outcomes.result='sunk')

E.R SeeBattles

Q.R. SeeBattles:

create database AZS22

use AZS22

CREATE TYPE strk FROM varCHAR(30) not null

create type num from numeric(4,1) not null

create type sInt from smallint not null

create table Spravka(CodT sint, Marka strk, Prisez num, Koef num, primary key(CodT))

create table Smena (CodS int, Nums sInt, DateSM date, primary key(CodS))

create TABLE Rashod(CodT sint, KolR sInt, DateR date, FOREIGN KEY (CodT) REFERENCES Spravka(CodT))

create table Prihod(CodS int, CodT sint, KolP int,FOREIGN KEY (CodT) REFERENCES Spravka(CodT), FOREIGN KEY (CodS) REFERENCES Smena(CodS))

create table Peresmenka(CodS int, CodT sint, KtNs int, KtKs int, FOREIGN KEY (CodT) REFERENCES Spravka(CodT), FOREIGN KEY (CodT) REFERENCES Spravka(CodT), FOREIGN KEY (CodS) REFERENCES Smena(CodS))

-------------------------------------------------------------------------------

insert into Spravka(CodT, Marka, Prisez, Koef) values (10,'ai-72',6.10,1.30);

insert into Spravka(CodT, Marka, Prisez, Koef) values (11,'ai-76',6.20,1.30);

insert into Spravka(CodT, Marka, Prisez, Koef) values (12,'ai-80',6.30,1.30);

insert into Spravka(CodT, Marka, Prisez, Koef) values (13,'ai-92',7.20,1.40);

insert into Spravka(CodT, Marka, Prisez, Koef) values (14,'ai-95',8.00,1.40);

insert into Spravka(CodT, Marka, Prisez, Koef) values (15,'ai-98',8.20,1.50);

insert into Spravka(CodT, Marka, Prisez, Koef) values (16,'ai-99',8.50,1.60);

insert into Spravka(CodT, Marka, Prisez, Koef) values (17,'ai-100',9.00,1.70);

insert into Spravka(CodT, Marka, Prisez, Koef) values (18,'Diesel',7.30,1.50);

insert into Spravka(CodT, Marka, Prisez, Koef) values (19,'propan',7.50,1.40);

insert into Smena(CodS,Nums,DateSM) values (1001,1,'2007-09-25');

insert into Smena(CodS,Nums,DateSM) values (1002,2,'2007-09-26');

insert into Smena(CodS,Nums,DateSM) values (1003,1,'2007-09-27');

insert into Smena(CodS,Nums,DateSM) values (1004,2,'2007-09-28');

insert into Smena(CodS,Nums,DateSM) values (1005,1,'2007-09-29');

insert into Smena(CodS,Nums,DateSM) values (1006,2,'2007-09-30');

insert into Smena(CodS,Nums,DateSM) values (1007,1,'2007-10-01');

insert into Smena(CodS,Nums,DateSM) values (1008,2,'2007-10-02');

insert into Smena(CodS,Nums,DateSM) values (1009,1,'2007-10-03');

insert into Smena(CodS,Nums,DateSM) values (1010,2,'2007-10-04');

insert into Rashod(CodT,KolR,DateR) values (11,20,'2007-09-25');

insert into Rashod(CodT,KolR,DateR) values (13,25,'2007-09-25');

insert into Rashod(CodT,KolR,DateR) values (13,20,'2007-09-25');

insert into Rashod(CodT,KolR,DateR) values (14,30,'2007-09-27');

insert into Rashod(CodT,KolR,DateR) values (11,30,'2007-09-25');

insert into Rashod(CodT,KolR,DateR) values (11,25,'2007-09-25');

insert into Rashod(CodT,KolR,DateR) values (11,15,'2007-09-25');

insert into Rashod(CodT,KolR,DateR) values (11,20,'2007-09-25');

insert into prihod(cods,codt,kolp) values(1001,11,200);

insert into prihod(cods,codt,kolp) values(1001,13,500);

insert into prihod(cods,codt,kolp) values(1002,13,500);

insert into prihod(cods,codt,kolp) values(1003,13,500);

insert into prihod(cods,codt,kolp) values(1001,14,700);

insert into prihod(cods,codt,kolp) values(1002,14,700);

insert into prihod(cods,codt,kolp) values(1003,14,700);

insert into prihod(cods,codt,kolp) values(1001,15,1000);

insert into prihod(cods,codt,kolp) values(1002,15,1000);

insert into prihod(cods,codt,kolp) values(1003,15,1000);

insert into prihod(cods,codt,kolp) values(1001,18,1000);

insert into prihod(cods,codt,kolp) values(1002,18,1000);

insert into prihod(cods,codt,kolp) values(1003,20,300);

insert into prihod(cods,codt,kolp) values(1002,21,300);

insert into Peresmenka(cods,codt,ktns,ktks) values (1001,13,500,300);

insert into Peresmenka(cods,codt,ktns,ktks) values (1001,14,650,200);

insert into Peresmenka(cods,codt,ktns,ktks) values (1002,15,600,200);

insert into

Peresmenka(cods,codt,ktns,ktks) values (1002,13,500,200);

insert into Peresmenka(cods,codt,ktns,ktks) values (1002,14,400,200);

insert into Peresmenka(cods,codt,ktns,ktks) values (1002,15,400,200);

insert into Peresmenka(cods,codt,ktns,ktks) values (1003,18,200,200);

insert into Peresmenka(cods,codt,ktns,ktks) values (1003,14,200,100);

insert into Peresmenka(cods,codt,ktns,ktks) values (1003,15,200,200);

insert into Peresmenka(cods,codt,ktns,ktks) values (1004,16,200,100);

insert into Peresmenka(cods,codt,ktns,ktks) values (1005,14,200,100);

insert into Peresmenka(cods,codt,ktns,ktks) values (1005,15,200,100);

insert into Peresmenka(cods,codt,ktns,ktks) values (1006,16,500,100);

insert into Peresmenka(cods,codt,ktns,ktks) values (1006,18,200,200);

insert into Peresmenka(cods,codt,ktns,ktks) values (1001,19,300,300);

-------------------------------------------------------------------------------

update Spravka set Koef = Koef+0.1 where Prisez <17

update Spravka set Prisez= Prisez-1 where Koef >1.5

update Rashod set KolR= KolR+5 where month(DateR)=MONTH (getdate());

SELECT * from Rashod

delete from Rashod where DateR= '2007-09-25'

delete from Rashod where DAY (DateR)=22;

delete from Rashod where year (DateR)=2014;

insert into Rashod values (14,30,GETDATE());

select day (dater)from rashod where CodT=14;

-----------------------

select * from Peresmenka

select * from Prihod

select * from Rashod

select * from Smena

select * from Spravka

----------------------------------------------------------------------------

create view Spravka_VIEW1 as

select marka,Prisez,CodT,Koef

from Spravka

select * from Spravka_VIEW1

insert into Spravka_VIEW1(CodT,marka,prisez,Koef)values(211,'Gas',9.20,1.3)

update Spravka_VIEW1 set koef=1.6 where marka='gas'

delete from Spravka_VIEW1

where Marka='gas'

E.R Azs

Q.R. AZS

create database cafe;

use cafe;

create type cod from int not null;

create type stroka from varchar[30] not null;

create table Bliuda(cod_bl cod primary key, name_bl stroka, cod_tipa cod foreign key references from Tipbl, gramaj int not null, prise int not null, sostav stroka default='?');

create table Meniu(datam date not null, cod_bl cod foreign key references from bliuda);

create table Zacaz(n_sciota cod, dataz date not null, cad_bl cod foreign key references from bliuda, col_pr smallint);

create table tipbl(cod_tipa cod primary key, name_tipa stroka);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',10,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1002,'Канапе с красной икрой',10,400,27);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1004,'Осетрина с лимоном',10,250,120);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1006,'Сельдь с маслинами',10,400,60);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1008,'Ассорти из свежих овощей',11,400,51);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1101,'От шеф-повора',11,400,25);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1104,'Крабовый',11,400,25);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1105,'Греческий',11,300,29);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1207,'Изсвежих овощей',11,300,24);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1201,'Жульен из птицы',12,200,35);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1202,'Жульен из куриной печени',12,200,38);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1204,'Жульен из грибов',12,200,38);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1301,'Зама из птицы',13,200,25);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1303,'Суп вегетарианский',13,200,36);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1304,'Окрошка',13,200,20);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1401,'Осетрина на гратаре',14,200,48);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1404,'Шашлык из свинины',14,200,48);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1405,'Филе куриное на глатаре',14,200,45);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1406,'Шашлык из птицы',14,200,50);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1501,'Филе судака в фольге',15,200,35);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1502,'Филе судака жареное',15,200,35);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1601,'Говядина с грибами',16,200,38);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1602,'Стэйк с вишей',16,200,38);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1603,'Стэйк закопченный сыром',16,200,20);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',17,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',18,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',19,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',20,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',21,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',22,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',23,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',24,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',25,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',26,250,42);

insert into bliuda(cod_bl,name_bl,cod_tipa, gramaj, price) values (1001,'Канапе с черной икрой',27,250,42);

insert into Meniu (datam,cad_bl) values(16.11.2007,1001);

insert into Meniu (datam,cad_bl) values(16.11.2007,1101);

insert into Meniu (datam,cad_bl) values(16.11.2007,1201);

insert into Meniu (datam,cad_bl) values(16.11.2007,1301);

insert into Meniu (datam,cad_bl) values(16.11.2007,1401);

insert into Meniu (datam,cad_bl) values(17.11.2007,1501);

insert into Meniu (datam,cad_bl) values(17.11.2007,1601);

insert into Meniu (datam,cad_bl) values(17.11.2007,1701);

insert into Meniu (datam,cad_bl) values(17.11.2007,1801);

insert into Meniu (datam,cad_bl) values(17.11.2007,1901);

insert into Meniu (datam,cad_bl) values(17.11.2007,2001);

insert into Meniu (datam,cad_bl) values(18.11.2007,2101);

insert into Meniu (datam,cad_bl) values(18.11.2007,2201);

insert into Meniu (datam,cad_bl) values(18.11.2007,2301);

insert into Meniu (datam,cad_bl) values(18.11.2007,2401);

insert into Meniu (datam,cad_bl) values(19.11.2007,2501);

insert into Meniu (datam,cad_bl) values(19.11.2007,2601);

insert into Meniu (datam,cad_bl) values(19.11.2007,2701);

insert into tipbl(cod_tipa,name_tipa) values(10,'Холодные блюда и закуски');

insert into tipbl(cod_tipa,name_tipa) values(11,'Салаты');

insert into tipbl(cod_tipa,name_tipa) values(12,'Горячие закуски');

insert into tipbl(cod_tipa,name_tipa) values(13,'Супы');

insert into tipbl(cod_tipa,name_tipa) values(14,'Гратарные блюда');

insert into tipbl(cod_tipa,name_tipa) values(15,'Блюда из рыбы');

insert into tipbl(cod_tipa,name_tipa) values(16,'Блюда из говядины');

insert into tipbl(cod_tipa,name_tipa) values(17,'Блюда из свинины');

insert into tipbl(cod_tipa,name_tipa) values(18,'Блюда из птицы');

insert into tipbl(cod_tipa,name_tipa) values(19,'Блюда из яиц');

insert into tipbl(cod_tipa,name_tipa) values(20,'Мучные блюда');

insert into tipbl(cod_tipa,name_tipa) values(21,'Блюда из овощей');

insert into tipbl(cod_tipa,name_tipa) values(22,'Гарниры');

insert into tipbl(cod_tipa,name_tipa) values(23,'Сладкие блюда');

insert into tipbl(cod_tipa,name_tipa) values(24,'Горячие напитки');

insert into tipbl(cod_tipa,name_tipa) values(25,'Коктейли');

insert into tipbl(cod_tipa,name_tipa) values(26,'Спиртное');

insert into tipbl(cod_tipa,name_tipa) values(27,'Шоколад');

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1001001,16.11.2007,1001,2);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1004002,16.11.2007,1002,2);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1101003,16.11.2007,1101,2);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1103004,16.11.2007,1103,2);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1301005,16.11.2007,1301,2);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1302006,17.11.2007,1302,2);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1402007,17.11.2007,1402,4);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1502008,17.11.2007,1502,4);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(1601009,17.11.2007,1601,4);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(2001010,18.11.2007,2001,1);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(2102011,18.11.2007,2102,1);

insert into zakaz(n_sciota, dataz, cod_bl, col_pr) values(2401012,18.11.2007,2401,2);

Create view zakazik

Select name_bl,zakaz

From Bliuda,zakaz

E.R. Kafe

Q.r. Kafe

create database pc

create type ch from varchar(10)

create table product(maker char(1) not null, idmodel int not null, type1 ch not null)

create table pc(idmodel int not null, speed numeric(2,1) not null, ram numeric(1) not null,hd int not null, dvd varchar(3) not null, price int not null);

create table laptop(idmodel int not null, speed numeric(2,1) not null, ram numeric(1) not null,hd int not null, display varchar(3) not null, price int not null);

create table printer(idmodel int not null,free_in_1 ch not null, type ch not null, price int not null)

create index idModel on product(idmodel)

insert into product values('A',4001,'pc')

insert into product values('A',4002,'pc')

insert into product values('A',4003,'pc')

insert into product values('B',4004,'pc')

insert into product values('B',4006,'pc')

insert into product values('B',6002,'printer')

insert into product values('B',6004,'printer')

insert into product values('C',4005,'pc')

insert into product values('C',4007,'pc')

insert into product values('D',4008,'pc')

insert into product values('D',4009,'pc')

insert into product values('D',4010,'pc')

insert into product values('D',5001,'laptop')

insert into product values('D',5002,'laptop')

insert into product values('D',5003,'laptop')

insert into product values('D',6001,'printer')

insert into product values('D',6003,'printer')

insert into product values('E',5004,'laptop')

insert into product values('E',5008,'laptop')

insert into product values('F',5005,'laptop')

insert into product values('G',5006,'laptop')

insert into product values('G',5007,'laptop')

insert into product values('H',6005,'printer')

insert into product values('I',6006,'printer')

insert into pc values(4001,5.4,4,500,'16x', 550)

insert into pc values(4002,5.2,2,300,'16x', 500)

insert into pc values(4003,5.6,4,1000,'16x',650)

insert into pc values(4004,5.6,2,500,'16x', 600)

insert into pc values(4005,5.6,1,500,'8x', 500)

insert into pc values(4006,6.0,2,300,'16x', 600)

insert into pc values(4007,6.0,2,500,'8x', 600)

insert into pc values(4008,5.8,4,500,'16x', 600)

insert into pc values(4009,6.0,4,1000,'16x',750)

insert into pc values(4010,5.6,1,250,'16x', 480)

insert into laptop values(5001,2.2,1,80, '9"', 500)

insert into laptop values(5002,2.4,1,250,'10"',600)

insert into laptop values(5003,2.4,1,250,'11"',700)

insert into laptop values(5004,2.6,2,500,'12"',750)

insert into laptop values(5005,2.6,2,250,'10"',650)

insert into laptop values(5006,2.8,2,250,'10"',650)

insert into laptop values(5007,3.0,2,500,'12"',800)

insert into laptop values(5008,2.8,2,250,'11"',700)

insert into printer values(6001,'true','ink-jet',125)

insert into printer values(6001,'true','ink-jet',130)

insert into printer values(6001,'false','laser',170)

insert into printer values(6001,'false','laser',180)

insert into printer values(6001,'false','ink-jet',150)

insert into printer values(6001,'true','dry',250)

Дата добавления: 2015-08-29; просмотров: 26 | Нарушение авторских прав

<== предыдущая лекция	\|	следующая лекция ==>
общеобразовательная школа №1»	\|	к положению о системе оценок, формах и порядке промежуточной аттестации обучающихся начальной ступени образования в ГОУ школе №459

mybiblioteka.su - 2015-2024 год. (0.088 сек.)