.
3.1 T-SQL-
SQL-, . , .
, .
CREATE VIEW infoklient /* */
AS
SELECT /*, */
Marina.., Marina.., Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, .
CREATE VIEW infosotr /* */
AS
SELECT /*, */
Marina..,Marina.., Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, .
CREATE VIEW infosA /* */
AS
SELECT /*, */
Marina..,Marina..,
Marina.., Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, .
CREATE VIEW infokl /* */
AS
SELECT /*, */
Marina..,Marina..,Marina.., Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, .
CREATE VIEW infoimyakl /* */
AS
SELECT /*, */
Marina..,Marina..,Marina.., Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, .
CREATE VIEW infosotrimya /* */
AS
SELECT /*, */
Marina..,Marina..,
Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, 1-3
CREATE VIEW Otdeli /* */
AS
SELECT /* */
Marina.._,Marina.._, Marina..,
Marina..,Marina..
|
|
FROM /* , , .*/
Marina. INNER JOIN Marina. ON Marina.._ = Marina.._
WHERE Marina.._ BETWEEN 1 AND 3 /* , 10 13*/
, 1 10
CREATE VIEW zapis
AS
SELECT /* */
Marina..,Marina.., Marina..,
Marina.._,Marina.._
FROM /* , , .*/
Marina. INNER JOIN Marina. ON Marina.._ = Marina.._
WHERE Marina.._ BETWEEN 1 AND 10 /* , 1 10*/
, 10 20
CREATE VIEW pers
AS
SELECT /* */
Marina.._,Marina.._, Marina..,
Marina..,Marina..
FROM /* , , .*/
Marina. INNER JOIN Marina. ON Marina.._ = Marina.._
WHERE Marina.._ BETWEEN 10 AND 20 /* , 10 20*/
, 1 20, .
CREATE VIEW personal
AS
SELECT /* */
__._, __._,.,
.,.
FROM /* , , .*/
__ INNER JOIN ON __._ = ._
WHERE ._ BETWEEN 1 AND 20 /* , 1 20*/
, ʻ.
CREATE VIEW infoklientFIO /* */
AS
SELECT /*, */
Marina.., Marina.., Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, л.
CREATE VIEW infosotrFIO /* */
AS
SELECT /*, */
Marina..,Marina.., Marina..
FROM Marina. /* */
WHERE Marina.. LIKE '%'
, = 8.
CREATE VIEW infoklientNOMER /* */
AS
SELECT /*, */
Marina.., Marina.., Marina..
FROM Marina. /* */
WHERE Marina.._ LIKE '8%'
, = 11.
|
|
CREATE VIEW infosotrNomer /* */
AS
SELECT /*, */
Marina..,Marina..,
Marina..
FROM Marina. /* */
WHERE Marina.._ LIKE '11%'
3.2 T-SQL-
, : , .
, , :
CREATE TRIGGER udalenie_klienta /* */
ON /* , */
FOR DELETE /* , . ( )*/
AS
IF (SELECT count(*) /**/
from /* */
where ._ is not null)>0 /* .
AND (CURRENT_USER <> 'dbo') /* , */
BEGIN
PRINT ' ' /* */
ROLLBACK TRANSACTION /* () */
END
, :
CREATE TRIGGER dobavlenie_klienta
ON
FOR INSERT
AS
DECLARE @@f int /* */
Set @@f=01 /* */
IF NOT EXISTS (SELECT * FROM , inserted
WHERE ._ = inserted._)
Set @@f=0
IF EXISTS (SELECT * FROM , inserted
WHERE inserted._>33 OR inserted._<01) /* >14 <10, */
Set @@f=0 /* */
If @@f=0 /* f=0, */
BEGIN
PRINT ' '
ROLLBACK TRANSACTION /* () */
END
:
CREATE TABLE UpdatedKlients
(
[_] [int] NOT NULL,
[] [varchar] (25) NULL,
[] [varchar] (25) NULL,
[] [varchar] (25) NULL,
[] [int] NULL,
[_] [varchar] (50) NULL,
[_] [datetime] NULL
) ON [PRIMARY]
CREATE TRIGGER infoUpdateKlient
ON /* */
FOR UPDATE
AS
INSERT INTO infoUpdateKlient (_, /*, */
,,,,_,_)
SELECT _,,,,, /* */
SYSTEM_USER, /* */
getdate()/* */
FROM updated/*updated , */
:
CREATE TRIGGER udalenie_personala/* */
ON /* , */
FOR DELETE /* , . ( )*/
AS
IF exists(select*from where
CURRENT_USER <> 'Marina') /* , */
BEGIN
PRINT ' ' /* */
ROLLBACK TRANSACTION /* () */
END
:
CREATE TRIGGER dobavlenie_personala
ON
FOR INSERT
AS
DECLARE @@f int /* */
Set @@f=10 /* */
IF NOT EXISTS (SELECT * FROM , inserted
WHERE ._ = inserted._)
Set @@f=0
IF EXISTS (SELECT * FROM , inserted
WHERE inserted._>30 OR inserted._<10) /* */
|
|
Set @@f=0 /* */
If @@f=0 /* f=0, */
BEGIN
PRINT ' '
ROLLBACK TRANSACTION /* () */
END
:
CREATE TABLE UpdatedOtdeli
(
[_] [int] NOT NULL,
[_] [varchar] (25) NULL,
[_] [varchar] (25) NULL,
[_] [varchar] (50) NULL,
[_] [datetime] NULL
) ON [PRIMARY]
CREATE TRIGGER infoUpdateOtdel
ON /* */
FOR UPDATE
AS
INSERT INTO UpdatedOtdeli (_, /*, */
_, _, _,
_)
SELECT _, _,_, /* */
SYSTEM_USER, /* */
getdate()
FROM deleted /*updated , */
3.3 T-SQL-
.
CREATE PROCEDURE KolDolgn /* */
AS SELECT COUNT (DISTINCT .) /* */
FROM /* */
, =27.
Create procedure vybor /* */
as select ., . /* */
From /* */
Where ._=27 /* */
.
CREATE PROCEDURE NewKlient
@Nomer int,
@F varchar(20),
@I varchar(20),
@O varchar(20), /* */
@Tel int
AS /*, , */
IF EXISTS (SELECT * FROM WHERE _=@Nomer)
RETURN 0 /* , */
INSERT INTO /* , */
VALUES (@Nomer,@F,@I,@O,@Tel) /* */
.
CREATE PROCEDURE NewPersonal
@TABNomer int,
@F varchar(20),
@I varchar(20),
@O varchar(20),
@D varchar(20), /* */
@nomOT int
AS
IF EXISTS (SELECT * FROM WHERE _=@TABNomer)
RETURN 0 /* , */
INSERT INTO /* , */
VALUES (@TABNomer,@F,@I,@O,@D,@nomOT) /* */
.
CREATE PROCEDURE Udalenieklienta
@nom int /* */
AS /*, , , .*/
IF not EXISTS (SELECT * FROM WHERE _=@nom)
DELETE /* */
FROM /* , */
WHERE /* , _ */
_=@nom
.
CREATE PROCEDURE UdaleniePersonala
@nom int /* */
AS /*, , , .*/
IF EXISTS (SELECT * FROM WHERE _<>@nom)
DELETE /* */
FROM /* , */
WHERE /* , _ */
|
|
_=@nom
.
CREATE PROCEDURE NewOtdel
@Nomer int,
@Naz varchar(20),
@FIO varchar(20) /* */
AS
IF EXISTS (SELECT * FROM WHERE _=@Nomer)
RETURN 0 /* , */
INSERT INTO /* , */
VALUES (@Nomer,@Naz,@FIO) /* */
, .
CREATE PROCEDURE UdalenieOtdela
@nom int /* */
AS /*, , , .*/
IF not EXISTS (SELECT * FROM WHERE _=@nom)
DELETE /* */
FROM /* , */
WHERE /* , _ */
_=@nom
.
CREATE PROCEDURE RedaktirowanieKlienta
@Nomer int, /* */
@Tel varchar(20)
AS
IF EXISTS (SELECT * FROM /*, ,*/
WHERE _ = @Nomer) /* */
UPDATE /* */
SET = @Tel
WHERE _ = @Nomer /* */
.
CREATE PROCEDURE RedaktirowanieOtela
@Nomer int,
@Naz varchar (20) /* */
AS
IF EXISTS (SELECT * FROM /*, */
WHERE _ = @Nomer) /* */
UPDATE /* */
SET _ = @Naz
WHERE _ = @Nomer /* */
, , .
CREATE PROCEDURE yslygi
@a int,
AS
SELECT /* , */
.,.,.,.
FROM /* */
,
WHERE /* */
(._=@a)
, . = 19.
Create procedure vyborpersonala /* */
as select ., . /* , */
From /* */
Where ._=19 /* */
, , .
CREATE PROCEDURE klient
@a int,
AS
SELECT /* , */
._, ., ., .
FROM /* */
,
WHERE /* */
(._=@a) and (._=@a)
, .
CREATE PROCEDURE yslygiklienta
@a int
AS
SELECT /* , */
.,._,.,.
FROM /* */
,
WHERE (._=@a) /* */
, , .
CREATE PROCEDURE stoimostmaster
@a int
AS
SELECT /* , */
., ., ._, ., ., ._
FROM /* */
,
WHERE /* */
(.=@a)
, .
CREATE PROCEDURE parikmaxer
@a int
AS
SELECT /* , */
., ._, ., .
FROM /* */
,
WHERE /* */
(._=@a)and(._= . _)
|
|
3.4
, .
, 17.
17
. . , . 18.
18
.
( 19).
19
( 20).
20
4
, .
:
- Intel(R) Core(TM) i5 CPU;
- NVIDIA GeForce 310M;
- 3Gb;
- 320Gb.
- , , 21.
21
, .
, , , 22.
22
, , , , . , ʻ. 23.
23
, 24.
24
. ( 25).
25
, , , . . 26.
26
. , , . 27.
27
( 28).
28
5 -
, .
:
- ;
- ;
- LCD ;
- .
. 15%. . . , 30 % , . , , - .
, .
3 :
- , ;
- ;
- , , , , , 50% ;
- 3 , ( 1), ;
- , 60000 ;
- , 40000 ;
- , , 6 .
1 ,
, | , | ||||
, | , | , . | 8- | 12- | |
20000 | 1500 | 2,0 | |||
40000 | 3000 | 4,0 | |||
60000 | 4000 | 6,0 |
, ( 1).
, . .
, , , .
100%, .
. 400.
, ,
n = /(8-t), (1)
, ;
=104,2 ;
t ,
, .
t =70 =7,6 ,
= n t, (2)
;
=(W-W)1560,00, (3)
W , ;
W ;
W = 0,40 ;
W = 0,16 .
=17,70*(0,400,16)*1560,00=6626,88 .
. .
C++Builder 6 SQL Server. , , .