CS448/Ramez Elmasri, Shamkant Navathe - Fundamentals of Database Systems, Seventh Edition [7th Ed] (Instructor's Edu Resource 1 of 2, Complete Solution Manual with Lab Solutions)-Pearson (2015)/Lab/ch4/company/dept_locations.sql

DROP TABLE dept_locations;
CREATE TABLE dept_locations (
  dnumber   integer(4),
  dlocation varchar(15), 
  primary key (dnumber,dlocation),
  foreign key (dnumber) references department(dnumber)
);