-
Notifications
You must be signed in to change notification settings - Fork 0
illfyar/WPFHomeWork
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
CREATE TABLE [dbo].[Person]
(
[Id] INT NOT NULL PRIMARY KEY IDENTITY,
[LastName] NCHAR(100) NULL,
[FirstName] NCHAR(100) NULL,
[DateBorn] DATE NULL,
[Gender] NCHAR(1) NULL
)
CREATE TABLE [dbo].[Position]
(
[Id] INT NOT NULL PRIMARY KEY IDENTITY,
[Name] NCHAR(200) NULL
)
CREATE TABLE [dbo].[Department]
(
[Id] INT NOT NULL PRIMARY KEY IDENTITY,
[Name] NCHAR(200) NULL,
[Parent_id] INT NULL,
CONSTRAINT [FK_Department_Department] FOREIGN KEY ([Parent_id]) REFERENCES [Department]([Id])
)
CREATE TABLE [dbo].[Salary]
(
[Id] INT NOT NULL PRIMARY KEY IDENTITY,
[Name] NCHAR(100) NULL,
[Position_id] INT NULL,
[Department_id] INT NULL,
[Value] DECIMAL(18, 2) NULL,
CONSTRAINT [FK_Salary_Position] FOREIGN KEY ([Position_id]) REFERENCES [Position]([id]),
CONSTRAINT [FK_Salary_Department] FOREIGN KEY ([Department_id]) REFERENCES [Department]([id])
)
CREATE TABLE [dbo].[Employee]
(
[Id] INT NOT NULL PRIMARY KEY IDENTITY,
[Person_id] INT NULL,
[Position_id] INT NULL,
[Department_id] INT NULL,
[Salary_id] INT NULL,
CONSTRAINT [FK_Employee_Person] FOREIGN KEY ([Person_id]) REFERENCES [Person]([id]),
CONSTRAINT [FK_Employee_Position] FOREIGN KEY ([Position_id]) REFERENCES [Position]([id]),
CONSTRAINT [FK_Employee_Department] FOREIGN KEY ([Department_id]) REFERENCES [Department]([id]),
CONSTRAINT [FK_Employee_Salary] FOREIGN KEY ([Salary_id]) REFERENCES [Salary]([id])
)
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ1', N'Èìÿ1', N'1978-06-12', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ2', N'Èìÿ2', N'1972-04-08', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ3', N'Èìÿ3', N'2000-12-27', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ4', N'Èìÿ4', N'1968-03-06', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ5', N'Èìÿ5', N'1994-11-23', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ6', N'Èìÿ6', N'1974-05-10', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ7', N'Èìÿ7', N'1989-09-20', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ8', N'Èìÿ8', N'1991-10-21', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ9', N'Èìÿ9', N'1973-04-09', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ10', N'Èìÿ10', N'1975-05-11', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ11', N'Èìÿ11', N'1997-12-25', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ12', N'Èìÿ12', N'1963-01-03', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ13', N'Èìÿ13', N'1962-01-02', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ14', N'Èìÿ14', N'1991-10-22', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ15', N'Èìÿ15', N'1969-03-07', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ16', N'Èìÿ16', N'1973-05-10', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ17', N'Èìÿ17', N'1997-11-25', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ18', N'Èìÿ18', N'1976-05-11', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ19', N'Èìÿ19', N'1972-04-09', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ20', N'Èìÿ20', N'1989-09-20', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ21', N'Èìÿ21', N'1990-09-21', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ22', N'Èìÿ22', N'1997-11-25', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ23', N'Èìÿ23', N'1962-01-02', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ24', N'Èìÿ24', N'1967-03-06', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ25', N'Èìÿ25', N'1969-03-07', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ26', N'Èìÿ26', N'1980-07-14', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ27', N'Èìÿ27', N'1981-07-14', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ28', N'Èìÿ28', N'1973-04-09', N'Ì')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ29', N'Èìÿ29', N'1991-10-22', N'Æ')
INSERT INTO [dbo].[Person] ([LastName], [FirstName], [DateBorn], [Gender]) VALUES (N'Ôàìèëèÿ30', N'Èìÿ30', N'2000-03-02', N'Æ')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü1')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü2')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü3')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü4')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü5')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü6')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü7')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü8')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü9')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü10')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü11')
INSERT INTO [dbo].[Position] ([Name] ) VALUES (N'Äîëæîñòü12')
INSERT INTO [dbo].[Department] ([Name],[Parent_id]) VALUES (N'Ïîäðàçäåëåíèå1',null)
INSERT INTO [dbo].[Department] ([Name],[Parent_id] ) VALUES (N'Ïîäðàçäåëåíèå2',1)
INSERT INTO [dbo].[Department] ([Name],[Parent_id] ) VALUES (N'Ïîäðàçäåëåíèå3',1)
INSERT INTO [dbo].[Department] ([Name],[Parent_id] ) VALUES (N'Ïîäðàçäåëåíèå4',2)
INSERT INTO [dbo].[Department] ([Name],[Parent_id] ) VALUES (N'Ïîäðàçäåëåíèå5',3)
INSERT INTO [dbo].[Department] ([Name],[Parent_id] ) VALUES (N'Ïîäðàçäåëåíèå6',4)
INSERT INTO [dbo].[Department] ([Name],[Parent_id] ) VALUES (N'Ïîäðàçäåëåíèå7',5)
INSERT INTO [dbo].[Department] ([Name],[Parent_id] ) VALUES (N'Ïîäðàçäåëåíèå8',5)
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ1', 1, NULL, CAST(350000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ2', 2, NULL, CAST(157000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ3', 3, NULL, CAST(116000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ4', 4, NULL, CAST(162000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ5', 5, NULL, CAST(136000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ6', 6, NULL, CAST(62000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ7', 7, NULL, CAST(169000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ8', 8, NULL, CAST(143000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ9', 9, NULL, CAST(81000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ10', 10, NULL, CAST(60000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ11', 11, NULL, CAST(236000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Salary] ([Name], [Position_id], [Department_id], [Value]) VALUES (N'ÔÎÒ12', 12, NULL, CAST(183000 AS Decimal(18, 2)))
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (1, 1, 1, 1)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (2, 11, 8, 11)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (3, 8, 5, 8)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (4, 10, 7, 10)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (5, 5, 4, 5)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (6, 7, 5, 7)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (7, 8, 5, 8)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (8, 7, 5, 7)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (9, 3, 1, 3)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (10, 10, 7, 10)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (11, 12, 8, 12)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (12, 11, 7, 11)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (13, 5, 1, 5)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (14, 5, 3, 5)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (15, 9, 6, 9)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (16, 11, 7, 11)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (17, 10, 7, 10)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (18, 6, 4, 6)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (19, 9, 6, 9)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (20, 4, 3, 4)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (21, 5, 4, 5)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (22, 10, 1, 10)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (23, 5, 3, 5)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (24, 11, 7, 11)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (25, 10, 7, 10)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (26, 4, 3, 4)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (27, 6, 4, 6)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (28, 5, 3, 5)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (29, 2, 2, 2)
INSERT INTO [dbo].[Employee] ([Person_id], [Position_id], [Department_id], [Salary_id]) VALUES (30, 9, 6, 9)About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published