ITM 5400 Chaper 9 Homework
1 and 2: Winfield Public Transit Authority System ERD with cardinality
Click Link Below To Buy:
http://hwcampus.com/shop/itm-5400-chaper-9-homework/
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:
ITM 5400 Chaper 9 Homework
1 and 2: Winfield Public Transit Authority System ERD with cardinality
Click Link Below To Buy:
http://hwcampus.com/shop/itm-5400-chaper-9-homework/
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:
ITM 5400 Chaper 9 Homework
1 and 2: Winfield Public Transit Authority System ERD with cardinality
Click Link Below To Buy:
http://hwcampus.com/shop/itm-5400-chaper-9-homework/
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...