· 6 years ago · Apr 29, 2019, 09:14 AM
1CREATE TABLE IF NOT EXISTS `DEPARTMENT` (
2 `id` int(6) unsigned NOT NULL,
3 `name` varchar(200) NOT NULL,
4 PRIMARY KEY (`id`)
5) DEFAULT CHARSET=utf8;
6INSERT INTO `DEPARTMENT` (`id`, `name`) VALUES
7 (1, 'IT Ops'),
8 (2, 'DevOps'),
9 (3, 'Marketing'),
10 (4, 'Accounting'),
11 (5, 'Development');
12
13CREATE TABLE IF NOT EXISTS `PROFESSOR` (
14 `id` int(6) unsigned NOT NULL,
15 `dep_id` int(3) unsigned NOT NULL,
16 `name` varchar(200) NOT NULL,
17 `salary` int(3) unsigned NOT NULL,
18 PRIMARY KEY (`id`)
19) DEFAULT CHARSET=utf8;
20INSERT INTO `PROFESSOR` (`id`, `dep_id`, `name`, `salary`) VALUES
21 (1, 1, 'Alex', 900),
22 (2, 2, 'Peter', 1000),
23 (3, 2, 'Ivan', 950),
24 (4, 3, 'Ben', 900),
25 (5, 4, 'John', 950),
26 (6, 5, 'Maya', 1000),
27 (7, 5, 'Sean', 900);