Question: trip_start_actual and trip_end_actual format. USING SQL: COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 TRIP_ID NUMBER (6,0) NO (null) 2 TRIP_START DATE No (null) 3 TRIP_END DATE No

 trip_start_actual and trip_end_actual format. USING SQL: COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1

trip_start_actual and trip_end_actual format.

TRIP_ID NUMBER (6,0) NO (null) 2 TRIP_START DATE No (null) 3 TRIP_END

USING SQL:

DATE No (null) 4 TRIP_START_ACTUAL DATE Yes (null) 5 TRIP_END_ACTUAL DATE Yes

COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 TRIP_ID NUMBER (6,0) NO (null) 2 TRIP_START DATE No (null) 3 TRIP_END DATE No (null) 4 TRIP_START_ACTUAL DATE Yes (null) 5 TRIP_END_ACTUAL DATE Yes (null) 6 TRIP_START_KM NUMBER (6,0) Yes (null) 7 TRIP_END_KM NUMBER (6,0) Yes (null) 8 TRIP_PASSENGERS NUMBER (2,0) (null) 9 VEH_VIN CHAR(17 BYTE) NO (null) 10 LOCATION_ID_FROM NUMBER (6,0) (null) 11 LOCATION_ID_TO NUMBER (6,0) No (null) 12 OFF_OLYMPIC_ID CHAR (8 BYTE) No (null) 13 DRIVER_ID NUMBER (4,0) No (null) COLUMN_ID COMMENTS 1 Unique identifier for a trip 2 Date and time the trip is booked to start 3 Date and time the trip is booked to end 4 Date and time the booked trip actually starts 5 Date and time the booked trip actually ends 6 The odometer reading at the start of the trip 7 The odometer reading at the end of the trip 8 The odometer reading at the end of the trip 9 Vehicle identification number 10 Location identification number of pickup location of the trip 11 Location identification number of drop off location of the trip 12 Official olympic id 13 Unique identifier for a driver No No 08/Feb/2022 08:15:45', 'dd/mon/yyyy hh24:mi:38'), 08/Feb/2022 09:29:12', 'dd/mon/yyyy hh24:mi:55'), OLS wishes to record the actual trip duration for each completed trip (the duration of each completed trip must be rounded to whole minutes). Modify the database structure and update the appropriate trip data to implement this requirement

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!