Untitled

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')