数据库思路-数据源

DROP TABLE IF EXISTS departments;
CREATE TABLE departments (
deptid INT(10) PRIMARY KEY,
deptname VARCHAR(20) NOT NULL -- 部门名称
);
INSERT INTO departments VALUES ('1001', '市场部');
INSERT INTO departments VALUES ('1002', '测试部');
INSERT INTO departments VALUES ('1003', '开发部');

DROP TABLE IF EXISTS employees;
CREATE TABLE employees (
empid INT(10) PRIMARY KEY,
empname VARCHAR(20) NOT NULL, -- 姓名
sex VARCHAR(4) DEFAULT NULL, -- 性别
deptid INT(20) DEFAULT NULL, -- 部门编号
jobs VARCHAR(20) DEFAULT NULL, -- 岗位
politicalstatus VARCHAR(20) DEFAULT NULL, -- 政治面貌
leader INT(10) DEFAULT NULL
);
INSERT INTO employees VALUES ('1', '王昭君', '女', '1003', '开发', '群众', '9');
INSERT INTO employees VALUES ('2', '诸葛亮', '男', '1003', '开发经理', '群众', NULL);
INSERT INTO employees VALUES ('3', '张飞', '男', '1002', '测试', '团员', '4');
INSERT INTO employees VALUES ('4', '白起', '男', '1002', '测试经理', '党员', NULL);
INSERT INTO employees VALUES ('5', '大乔', '女', '1002', '测试', '党员', '4');
INSERT INTO employees VALUES ('6', '孙尚香', '女', '1001', '市场', '党员', '12');
INSERT INTO employees VALUES ('7', '百里玄策', '男', '1001', '市场', '团员', '12');
INSERT INTO employees VALUES ('8', '小乔', '女', '1002', '测试', '群众', '4');
INSERT INTO employees VALUES ('9', '百里守约', '男', '1003', '开发', '党员', '9');
 
INSERT INTO employees VALUES ('10', '妲己', '女', '1003', '开发', '团员', '9');
INSERT INTO employees VALUES ('11', '李白', '男', '1002', '测试', '团员', '4');
INSERT INTO employees VALUES ('12', '孙膑', '男', '1001', '市场经理', '党员', NULL);

DROP TABLE IF EXISTS salary;
CREATE TABLE salary (
sid INT(10) PRIMARY KEY,
empid INT(10) NOT NULL,
salary INT(10) NOT NULL -- 工资
);
INSERT INTO salary VALUES ('1', '7', '2100');
INSERT INTO salary VALUES ('2', '6', '2000');
INSERT INTO salary VALUES ('3', '12', '5000');
INSERT INTO salary VALUES ('4', '9', '1999');
INSERT INTO salary VALUES ('5', '10', '1900');
INSERT INTO salary VALUES ('6', '1', '3000');
INSERT INTO salary VALUES ('7', '2', '5500');
INSERT INTO salary VALUES ('8', '5', '2000');
INSERT INTO salary VALUES ('9', '3', '1500');
INSERT INTO salary VALUES ('10', '8', '4000');
INSERT INTO salary VALUES ('11', '11', '2600');
INSERT INTO salary VALUES ('12', '4', '5300');
#数据库面经#