J

@judyxtan

Employee and Department table

SQL
3 years ago
CREATE TABLE Department ( ID int(2) not null primary key, Name varchar(50) not null, Location varchar(50) not null); CREATE TABLE Employee ( ID int(4) not null, Name varchar(50) not null, Hiredate date, Salary decimal(10,2),

Employee and Department table

SQL
3 years ago
CREATE TABLE Department ( ID int(2) not null primary key, Name varchar(50) not null, Location varchar(50) not null); CREATE TABLE Employee ( ID int(4) not null, Name varchar(50) not null, Hiredate date, Salary decimal(10,2),