S#

P#

J#

QTY

S1

P1

J1

200

S1

P1

J4

700

S2

P3

J1

400

S2

P3

J2

200

S2

P3

J3

200

S2

P3

J4

500

S2

P3

J5

600

S2

P3

J6

400

S2

P3

J7

800

S2

P5

J2

100

S3

P3

J1

200

S3

P4

J2

500

S4

P6

J3

300

S4

P6

J7

300

S5

P2

J2

200

S5

P2

J4

100

S5

P5

J5

500

S5

P5

J7

100

S5

P6

J2

200

S5

P1

J4

100

S5

P3

J4

200

S5

P4

J4

800

S5

P5

J4

400

S5

P6

J4

500

S#

SNAME

STATUS

CITY

S1

Smith

20 London

S2

Jones

10 Paris

S3

Blake

30 Paris

S4

Clark

20 London

S5

Adams

30 Athens

P#

PNAME

COLOR

WEIGHT

CITY

P1

Nut

Red

12.00

London

P2

Bold

Green

17.00

Paris

P3

Screw

Blue

17.00

Rome

P4

Screw

Red

14.00

London

P5

Cam

Blue

12.00

Paris

P6

Cog

Red

19.00

London

J#

JNAME

CITY

J1

Sorter

Paris

J2

Dispay

Rome

J3

OCR

Athens

J4

Console

Athens

J5

RAID

London

J6

EDS

Oslo

J7

Tape

London

J

J#
JNAME
CITY

varchar(10)
varchar(100)
varchar(100)

<pk>

P

P#
PNAME
COLOR
WEIGHT
CITY

varchar(10)
varchar(100)
varchar(100)
numeric(5,2)
varchar(100)

<pk>

S

S#
SNAME
STATUS
CITY

varchar(10)
varchar(100)
int
varchar(100)

<pk>

SPJ

S#
P#
J#
QTY

varchar(10)
varchar(10)
varchar(10)
int

<fk3>
<fk2>
<fk1>

Categories

CategoryID
CategoryName
Description
Picture

int
nvarchar(15)
ntext
image

<pk>

CustomerCustomerDemo

CustomerID
CustomerTypeID

nchar(5)
nchar(10)

<pk,fk2>
<pk,fk1>

CustomerDemographics

CustomerTypeID
CustomerDesc

nchar(10)
ntext

<pk>

Customers

CustomerID
CompanyName
ContactName
ContactTitle
Address
City
Region
PostalCode
Country
Phone
Fax

nchar(5)
nvarchar(40)
nvarchar(30)
nvarchar(30)
nvarchar(60)
nvarchar(15)
nvarchar(15)
nvarchar(10)
nvarchar(15)
nvarchar(24)
nvarchar(24)

<pk>

Employees

EmployeeID
LastName
FirstName
Title
TitleOfCourtesy
BirthDate
HireDate
Address
City
Region
PostalCode
Country
HomePhone
Extension
Photo
Notes
ReportsTo
PhotoPath

int
nvarchar(20)
nvarchar(10)
nvarchar(30)
nvarchar(25)
datetime
datetime
nvarchar(60)
nvarchar(15)
nvarchar(15)
nvarchar(10)
nvarchar(15)
nvarchar(24)
nvarchar(4)
image
ntext
int
nvarchar(255)

<pk>

<fk>

EmployeeTerritories

EmployeeID
TerritoryID

int
nvarchar(20)

<pk,fk1>
<pk,fk2>

Order Details

OrderID
ProductID
UnitPrice
Quantity
Discount

int
int
money
smallint
real

<pk,fk1>
<pk,fk2>

Orders

OrderID
CustomerID
EmployeeID
OrderDate
RequiredDate
ShippedDate
ShipVia
Freight
ShipName
ShipAddress
ShipCity
ShipRegion
ShipPostalCode
ShipCountry

int
nchar(5)
int
datetime
datetime
datetime
int
money
nvarchar(40)
nvarchar(60)
nvarchar(15)
nvarchar(15)
nvarchar(10)
nvarchar(15)

<pk>
<fk1>
<fk2>

<fk3>

Products

ProductID
ProductName
SupplierID
CategoryID
QuantityPerUnit
UnitPrice
UnitsInStock
UnitsOnOrder
ReorderLevel
Discontinued

int
nvarchar(40)
int
int
nvarchar(20)
money
smallint
smallint
smallint
bit

<pk>

<fk2>
<fk1>

Region

RegionID
RegionDescription

int
nchar(50)

<pk>

Shippers

ShipperID
CompanyName
Phone

int
nvarchar(40)
nvarchar(24)

<pk>

Suppliers

SupplierID
CompanyName
ContactName
ContactTitle
Address
City
Region
PostalCode
Country
Phone
Fax
HomePage

int
nvarchar(40)
nvarchar(30)
nvarchar(30)
nvarchar(60)
nvarchar(15)
nvarchar(15)
nvarchar(10)
nvarchar(15)
nvarchar(24)
nvarchar(24)
ntext

<pk>

Territories

TerritoryID
TerritoryDescription
RegionID

nvarchar(20)
nchar(50)
int

<pk>

<fk>