use a103500230;

DROP TABLE IF EXISTS dept;

CREATE TABLE dept (
  deptno INT NOT NULL,
  dname VARCHAR(16) NOT NULL,
  location VARCHAR(16),
  PRIMARY KEY (deptno)
);