CREATE DATABASE BusinessTripsUNF

CREATE TABLE BusinessTripsUNF.dbo.ResearcherConference
(
	rNo VARCHAR(50) NOT NULL,
	confName VARCHAR(50) NOT NULL,
	rName VARCHAR(50),
	confCity VARCHAR(50),
	confStart DATE,
	confFinish DATE,
	confSubject VARCHAR(50),
	orgNo VARCHAR(50),
	orgName VARCHAR(50),
	CONSTRAINT PK_rNo_confName PRIMARY KEY (rNo, confName)
)

INSERT INTO BusinessTripsUNF.dbo.ResearcherConference VALUES
('CR76', 'YM', 'Raymond Boyce', 'Nov', '2018-11-1', '2018-11-7', 'CS', 'C040', 'ICT'),
('CR76', 'Joker', 'Raymond Boyce', 'SPb', '2016-11-11', '2016-11-14', 'Java', 'C093', 'JUG.ru'),
('CR56', 'YM', 'Edgar Codd', 'Nov', '2017-11-2', '2017-11-8', 'CS', 'C040', 'ICT'),
('CR56', 'Joker', 'Edgar Codd', 'SPb', '2017-11-10', '2017-11-13', 'Java', 'C093', 'JUG.ru'),
('CR56', 'SmartData', 'Edgar Codd', 'Nov', '2017-04-05', '2017-04-08', 'Data Science', 'C093', 'JUG.ru')