Assignment #3 -- Recycled Tractor ERD/Table
Ryan Fobart // TR 2:00 - 3:20
| LEAD |
|
|
|
|
|
|
| Lead_ID |
Lead_Name |
Lead_Address |
Lead_Bank |
Lead_Phone |
Tracker_Name |
Tracker_Phone |
| 104 |
Billy Madison |
548 S. Sunset Bkvd |
Walkoverya |
610-489-2386 |
Jeff Bezos |
815-658-4567 |
| 109 |
George Jefferson |
2220 Space Oddesy Way |
Interplanetary |
586-124-6458 |
Marsha Brady |
245-884-0237 |
| TRACTOR |
|
|
|
|
|
|
|
| Tractor_ID |
Lead_ID (FK) |
Manfuactor |
Model_Name |
Year_Built |
Tractor_Address |
Asking_Price |
Amt_Paid |
| 7458 |
104 |
John Beer |
Fram Wrecker 5000 |
1985 |
2315 S. Side Rd |
24586 |
22300 |
| 7495 |
109 |
DeWalt |
Gonna Drillya |
1993 |
845 Continuity Street |
42599 |
40000 |
| EVALUATOR |
|
|
|
|
| Eval_Name |
Tractor_ID (FK) |
Lead_ID (FK) |
Eval_Cellnum |
Eval_Bid |
| Sir Wally |
7458 |
104 |
457-652-2458 |
22000 |
| Nate Than |
7495 |
109 |
457-652-2548 |
41000 |
Back | E-mail