ITM 5400 Chaper 9 Homework
1 and 2: Winfield Public Transit
Authority System ERD with cardinality
Click Link Below To Buy:
Contact
Us:
Hwcoursehelp@gmail.com
3. Identify fields for the tables. The following fields will be helpful to
allow the WPTA to identify where each bus is in the city and who is driving
it:
|
BUS_ID
|
|
|
VIN
|
|
|
MODEL
|
|
|
MANUFACTURER
|
|
|
DEALER
|
|
|
STORAGE_LOCATION
|
|
|
CURRENT_LOCATION
|
|
|
INSPECTION_DATE
|
|
|
EMPLOYEE_ID
|
|
|
LAST_NAME
|
|
|
FIRST_NAME
|
|
|
LICENSE_NO
|
|
|
LICENSE_STATE
|
|
|
EXP_DATE
|
|
|
ROUTE_ID
|
|
|
ROUTE_DESCRIPTION
|
|
|
STOP_ID
|
|
|
STOP_DESCRIPTION
|
|
|
STOP_DIRECTION
|
|
4. Shown in 3NF, a BUS_SYSTEM table would look
as such:
No comments:
Post a Comment