7Un0qhQ4

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 VIEW Team.TeamListView
86AS
87SELECT a.Team_name, a.Team_num
88FROM Team.TeamsList as a
89ON a.Team_num < 3;
90GO
91
92
93CREATE TABLE Names
94(
95 idName int IDENTITY(1,1) PRIMARY KEY, 
96 vcName varchar(50)
97)
98
99CREATE TABLE Phones
100(
101 idUserName int  PRIMARY KEY ,
102 vcPhone varchar(10), 
103 CONSTRAINT FK_idName FOREIGN KEY (idUserName)
104   REFERENCES Names (idName)
105   ON DELETE CASCADE
106   ON UPDATE CASCADE
107)
108
109INSERT INTO Names(vcName) 
110VALUES('Петров')
111
112INSERT INTO Names(vcName) 
113VALUES('Иванов')
114
115INSERT INTO Names(vcName) 
116VALUES('Сидоров')
117
118
119INSERT INTO Phones
120           ([idUserName]
121           ,[vcPhone])
122     VALUES
123           (1
124           ,123456789)
125GO
126
127INSERT INTO Phones
128           ([idUserName]
129           ,[vcPhone])
130     VALUES
131           (2
132           ,223456789)
133GO
134
135INSERT INTO Phones
136           ([idUserName]
137           ,[vcPhone])
138     VALUES
139           (3
140           ,323456789)
141GO