Thursday 11 May 2017

ITM 5400 Chaper 9 Homework


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