2
MICROSOFT SQL SERVER
: Select, Insert, Update, Delete.
10
CREATE DATABASE DB_BOOKS
use DB_BOOKS
CREATE TABLE Authors(Code_author INT PRIMARY KEY, [name author] CHAR(30), Birthday DATETIME)
CREATE TABLE Publishing_house(Code_publish INT PRIMARY KEY, Publish CHAR(30), City CHAR(20))
CREATE TABLE Books(Code_book INT PRIMARY KEY, Title_book CHAR(40), Code_author INT FOREIGN KEY REFERENCES Authors(Code_author),Pages INT, Code_publish INT FOREIGN KEY REFERENCES Publishing_house(Code_publish))
CREATE TABLE Deliveries(Code_delivery INT PRIMARY KEY, Name_delivery CHAR(30), Name_company CHAR(20), Address VARCHAR(100), Phone BIGINT, INN CHAR(13))
CREATE TABLE Purchases(Code_purchase INT PRIMARY KEY, Code_book INT FOREIGN KEY REFERENCES Books(Code_book), Date_order SMALLDATETIME, Code_delivery INT FOREIGN KEY REFERENCES Deliveries(Code_delivery), [Type purchase] BIT, Cost FLOAT, Amount INT)
CREATE TABLE Sklad(Code_Sklada INT PRIMARY KEY,Code_book INT FOREIGN KEY REFERENCES Books(Code_book),nazvanie_sklada char(10))
Publishing_house , -
: Publish, City,
Code_publish.
SELECT Code_publish,Publish,City from Publishing_house
Authors , ,
( Name_ author), .
Select name_author From Authors Where name_author like '%'
( Title_book) Books,
: ..,
.., ..
select Title_book,[name author] from Books,Authors where[name author]in('','','')
( Code_author), (
Name_author), ( Code_author) 1 2 ( Pages) 120.
select Authors.Code_author,[name author],Books.Pages from Books,Authors where Authors.Code_author BETWEEN'1'and'2' and Pages ='120'
( Cost)
Sum_cost,
( Name_company).
Select Sum(Cost) As Sum_cost From Purchases,Deliveries Where Name_delivery='çîðè' and Deliveries.Code_delivery=Purchases.Code_delivery
- (
Name_company) ( Title_book), .
select Deliveries.Name_company,Books.Title_book from Deliveries,Books
( Name_author) Authors, .
|
|
select [name author] from Authors where [name author] like 'A%'