ucG4u2DF

1USE master
2
3CREATE DATABASE lab__6
4ON (NAME = lab__6_dat, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\lab__6.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5)
5LOG ON ( NAME = lab__6_log, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\lab__6.ldf',SIZE = 5, MAXSIZE = 25, FILEGROWTH = 5);
6GO
7
8USE lab__6;
9GO
10
11DROP TABLE IF EXISTS Trigonometry
12GO
13 
14CREATE TABLE Trigonometry
15(
16	Angel_id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
17	Angel float DEFAULT (0),
18	Angel_cos_value int DEFAULT(COS(0)),
19	Angel_sin_value int DEFAULT(SIN(0)),
20	CHECK(ABS(Angel_cos_value)<=1 AND ABS(Angel_sin_value)<=1)
21)
22GO
23
24INSERT INTO Trigonometry
25           (Angel,
26			Angel_cos_value,
27			Angel_sin_value)
28     VALUES
29           (1,1,1)
30GO
31
32INSERT INTO Trigonometry
33           (Angel,
34			Angel_cos_value,
35			Angel_sin_value)
36     VALUES
37           (1,1,1)
38GO
39
40INSERT INTO Trigonometry
41           (Angel,
42			Angel_cos_value,
43			Angel_sin_value)
44     VALUES
45           (1,1,1)
46GO
47
48SELECT SCOPE_IDENTITY()
49GO
50
51DROP TABLE IF EXISTS Uniquee
52GO
53
54CREATE TABLE Uniquee
55(
56	UniqueColumn UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY,
57	Characters VARCHAR(10) 
58)
59GO
60
61CREATE SCHEMA Team;
62GO
63
64CREATE SEQUENCE Team.IndexMembers  
65    START WITH 1  
66    INCREMENT BY 1
67;
68
69CREATE SEQUENCE Team.Divide  
70    START WITH 1  
71    INCREMENT BY 1  
72    MINVALUE 1  
73    MAXVALUE 5  
74    CYCLE 
75; 
76
77CREATE TABLE Team.TeamsList
78(
79	Angel_id int PRIMARY KEY CLUSTERED DEFAULT (NEXT VALUE FOR Team.IndexMembers),
80	Team_num int DEFAULT (NEXT VALUE FOR Team.Divide),
81	Member_name VARCHAR(20) NOT NULL 
82)
83GO
84
85CREATE TABLE Names
86(
87 idName int IDENTITY(1,1) PRIMARY KEY, 
88 vcName varchar(50)
89)
90
91CREATE TABLE Phones
92(
93 idUserName int  PRIMARY KEY ,
94 vcPhone varchar(10), 
95 CONSTRAINT FK_idName FOREIGN KEY (idUserName)
96   REFERENCES Names (idName)
97   ON DELETE CASCADE
98   ON UPDATE CASCADE
99)
100
101INSERT INTO Names(vcName) 
102VALUES('Петров')
103
104INSERT INTO Names(vcName) 
105VALUES('Иванов')
106
107INSERT INTO Names(vcName) 
108VALUES('Сидоров')
109
110
111INSERT INTO Phones
112           ([idUserName]
113           ,[vcPhone])
114     VALUES
115           (1
116           ,123456789)
117GO
118
119INSERT INTO Phones
120           ([idUserName]
121           ,[vcPhone])
122     VALUES
123           (2
124           ,223456789)
125GO
126
127INSERT INTO Phones
128           ([idUserName]
129           ,[vcPhone])
130     VALUES
131           (3
132           ,323456789)
133GO