create database pl3_svet
use pl3_svet
CREATE TABLE dbo.Artworks
(
ArtworkId BIGINT IDENTITY(1,1) CONSTRAINT
 PK_Artworks PRIMARY KEY,
Title VARCHAR(100) NULL,
Genre VARCHAR (50) NULL,
Tools VARCHAR (50) NULL,
AuthorId BIGINT NULL,
CreatDate DATE NULL,
Price MONEY NULL,
DepId INT NOT NULL,
count varchar(10) null
 );
CREATE TABLE dbo.Authors
(
AuthorId BIGINT IDENTITY(1,1) CONSTRAINT
 PK_Authors PRIMARY KEY,
Lastname VARCHAR(25) NOT NULL,
Firstname VARCHAR (25) NOT NULL,
Middlename VARCHAR (25) NULL,
DateOfBirth DATE NULL,
DateOfDeath DATE NULL,
Country VARCHAR(25) NULL
);

use pl3_svet
ALTER TABLE dbo.Artworks
ADD CONSTRAINT FK_Artw_Auth
FOREIGN KEY (AuthorId)
REFERENCES Authors (AuthorId);
ALTER TABLE dbo.Artworks
ADD CONSTRAINT FK_Artw_Dep
FOREIGN KEY (DepId)
REFERENCES Departments (DepId);
ALTER TABLE dbo.Employees
ADD CONSTRAINT FK_Emp_Dep
FOREIGN KEY (DepId)
REFERENCES Departments (DepId);

insert into dbo.Authors values ('Шевченко', 'Тарас', 'Григорійович', '1890-12-07', '', 'Україна' )
insert into dbo.Authors values ('Вишневський', 'Януш', '', '1977-09-12', '', 'Польща' )

select * from dbo.Authors

insert into dbo.Departments values ('Мрія')
insert into dbo.Departments values ('Свобода')
insert into dbo.Departments values ('Промінь')
select * from dbo.Departments

insert into dbo.Employees values ('Ковтун', 'Олександр', 'Миколайович', 'менеджер', '8900', '2020-12-07', '', 1 )
insert into dbo.Employees values ('Бабенко', 'Надія', 'Андріївна', 'бухгалтер', '10000', '2020-12-07', '', 1 )
select * from dbo.Employees

insert into dbo.Artworks values ('Терени', 'Роматичний', 'електронна', 1, 
'1890-12-07', '120', 2, 200 )
insert into dbo.Artworks values ('рррр', 'Роматичний', 'електронна', 1, 
'1890-12-07', '120', 2, 2 )