Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE employees
- (
- employee_id int NOT NULL CONSTRAINT pk_employees PRIMARY KEY,
- employee_name nvarchar(128) NOT NULL CONSTRAINT uk_employees_employee_name UNIQUE
- );
- CREATE TABLE departments
- (
- department_id int NOT NULL PRIMARY KEY,
- department_name nvarchar(128) NOT NULL CONSTRAINT uk_departments_department_name UNIQUE
- );
- CREATE TABLE department_employees
- (
- department_id int NOT NULL CONSTRAINT fk_department_employees_departments REFERENCES departments(department_id),
- employee_id int NOT NULL CONSTRAINT fk_departement_employees_employees REFERENCES employees(employee_id),
- CONSTRAINT pk_deparment_employees PRIMARY KEY (department_id, employee_id)
- )
Add Comment
Please, Sign In to add comment