SqlServer Script

create.sql

--Employees
CREATE TABLE Employees(
	Id int not null,
	LastName nvarchar(50) not null,
	MiddleName nvarchar(50),
	FirstName nvarchar(50) not null,
	primary key(Id)
)
GO

--Customers
CREATE TABLE Customers(
	Id int not null,
	CustomerIdentifier nvarchar(50) not null,
	LastName nvarchar(50) not null,
	MiddleName nvarchar(50),
	FirstName nvarchar(50) not null,
	Line1 nvarchar(100) not null,
	Line2 nvarchar(100) not null,
	ZipCode nvarchar(10) not null,
	City nvarchar(50) not null,
	State nchar(2) not null,
	primary key(Id)
)
GO

--Orders
CREATE TABLE Orders(
	Id int not null,
	CustomerId int not null,
	EmployeeId int not null,
	OrderDate datetime not null,
	OrderTotal money not null,
	primary key(Id),
	constraint FK_Orders_Customers foreign key (CustomerId) references Customers(Id),
	constraint FK_Orders_Employees foreign key (EmployeeId) references Employees(Id)
)
GO