S# P# J# QTY
S# SNAME STATUS CITY
S1 P1 J1 200
S1 Smith 20 London
S1 P1 J4 700
S2 Jones 10 Paris
S2 P3 J1 400
S3 Blake 30 Paris
S2 P3 J2 200
S4 Clark 20 London
S2 P3 J3 200
S5 Adams 30 Athens
S2 P3 J4 500
S2 P3 J5 600
S2 P3 J6 400
P# PNAME COLOR WEIGHT CITY
S2 P3 J7 800
P1 Nut Red 12.00 London
S2 P5 J2 100
P2 Bold Green 17.00 Paris
S3 P3 J1 200
P3 Screw Blue 17.00 Rome
S3 P4 J2 500
P4 Screw Red 14.00 London
S4 P6 J3 300
P5 Cam Blue 12.00 Paris
S4 P6 J7 300
P6 Cog Red 19.00 London
S5 P2 J2 200
S5 P2 J4 100
S5 P5 J5 500
J# JNAME CITY
S5 P5 J7 100
J1 Sorter Paris
S5 P6 J2 200
J2 Dispay Rome
S5 P1 J4 100
J3 OCR Athens
S5 P3 J4 200
J4 Console Athens
S5 P4 J4 800
J5 RAID London
S5 P5 J4 400
J6 EDS Oslo
S5 P6 J4 500
J7 Tape London
J
J# varchar(10)
JNAME varchar(100)
CITY varchar(100)
S
SPJ
S# varchar(10)
S# varchar(10)
SNAME varchar(100)
P# varchar(10)
STATUS int
J# varchar(10)
CITY varchar(100)
QTY int
P
P# varchar(10)
PNAME varchar(100)
COLOR varchar(100)
WEIGHT numeric(5,2)
CITY varchar(100)
Orders
Customers
OrderID int
CustomerID nchar(5)
CustomerID nchar(5)
CompanyName nvarchar(40)
EmployeeID int
ContactName nvarchar(30)
OrderDate datetime
ContactTitle nvarchar(30)
RequiredDate datetime
Address nvarchar(60)
ShippedDate datetime
City nvarchar(15)
ShipVia int
Region nvarchar(15)
Freight money
PostalCode nvarchar(10)
ShipName nvarchar(40)
Country nvarchar(15)
ShipAddress nvarchar(60)
Phone nvarchar(24)
ShipCity nvarchar(15)
Fax nvarchar(24)
ShipRegion nvarchar(15)
Shippers
ShipPostalCode nvarchar(10)
ShipperID int
ShipCountry nvarchar(15)
CompanyName nvarchar(40)
Phone nvarchar(24)
Employees
EmployeeID int
LastName nvarchar(20)
FirstName nvarchar(10)
Title nvarchar(30)
TitleOfCourtesy nvarchar(25)
BirthDate datetime
HireDate datetime
Order Details
Address nvarchar(60)
OrderID int
City nvarchar(15)
ProductID int
Region nvarchar(15)
UnitPrice money
PostalCode nvarchar(10)
Quantity smallint
Country nvarchar(15)
Discount real
HomePhone nvarchar(24)
Extension nvarchar(4)
Photo image
Notes ntext
ReportsTo int
PhotoPath nvarchar(255)
Products EmployeeTerritories CustomerCustomerDemo
ProductID int EmployeeID int CustomerID nchar(5)
ProductName nvarchar(40) TerritoryID nvarchar(20) CustomerTypeID nchar(10)
SupplierID int
CategoryID int
QuantityPerUnit nvarchar(20)
UnitPrice money
UnitsInStock smallint
Territories
UnitsOnOrder smallint
TerritoryID nvarchar(20)
ReorderLevel smallint
TerritoryDescription nchar(50)
Discontinued bit
RegionID int
Suppliers
SupplierID int
Categories
CompanyName nvarchar(40)
ContactName nvarchar(30) CategoryID int
ContactTitle nvarchar(30) CategoryName nvarchar(15)
Address nvarchar(60) Description ntext
CustomerDemographics
City nvarchar(15) Picture image
CustomerTypeID nchar(10)
Region nvarchar(15)
CustomerDesc ntext
PostalCode nvarchar(10)
Country nvarchar(15)
Phone nvarchar(24)
Fax nvarchar(24)
HomePage ntext
Region
RegionID int
RegionDescription nchar(50)