|
Database Assignment 1
|
Table--
Participants |
Table--
V-tel Sites |
Table--
Tech Coordinators |
 |
Participant ID (PK)
|
|
|
V-Tel ID (PK)
|
|
| Tech
ID (PK)
|
|
|
First Name
|
|
|
V-tel City
|
|
| Tech
City
|
|
|
Middle Name
|
|
| V-tel
Location
|
|
| V-tel
ID (Fk)
|
|
|
Last Name
|
|
|
V-tel Address
|
|
| Tech
Address
|
|
|
Address
|
|
|
V-tel Phone
|
|
| Tech
Phone
|
|
|
City
|
|
| V-tel Assistant
|
|
| Tech
E-Mail
|
|
|
State
|
|
|
|
|
Zip
|
|
|
|
|
Phone
|
|
|
|
|
e-mail
|
|
|
|
|
V-Tel ID (FK)
|
|
|
|
|
Participant Type
|
|
|
|
| home page
|
|
|
|
| Tech
ID (FK)
|
|
|
|
|
