Table Employees


Table Employees

Figure A.7. Schema for Table Employees.

graphics/apafig07.gif

Index Name

Fields

Clustered

Primary Key

PK_employees

EmployeeID

Y

Y

LastName

LastName

N

N

PostalCode

PostalCode

N

N

Foreign Key Name

Key Field

Related Table

Related Field

FK_Orders_Employees

EmployeeID

Orders

EmployeeID

FK_Employee

EmployeeID

Employee Territories

EmployeeID

Territories_Employees

 

 

 



XML and SQL Server 2000
XML and SQL Server 2000
ISBN: 0735711127
EAN: 2147483647
Year: 2005
Pages: 104
Authors: John Griffin

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net