Road Accident 43


Road Accident 43 :

Special Complex Conditions: (a) Universe's predefined conditions (UPC): At least one type of veh. In Acc, Description (Des): All accidents in which a vehicle of type given in the user prompt is involved, Definition (Def): DIMENSION_VEHICLE2.VEHICLE_TYPE in @Prompt('Choose vehicle type involved in the accident', 'A', 'Vehicle type', MULTI, CONSTRAINED); (b) UPC: 1-2: At least one group of veh. In Acc, Des: All accidents in which a vehicle of group given in the user prompt is involved, Def: fact_accident.accident_key in (select fact_accident.accident_key from fact_accident, dimension_vehicle where Vehicle Group in @Prompt('01-factChoose vehicle group involved in the accident ', 'A', 'Vehicle Group', MULTI, CONSTRAINED) and fact_accident.dim_vehicle_key = dimension_vehicle.dim_vehicle_key); (c) UPC: 3-5: At least one pedestrian, Des: All accidents in which only one pedestrian is involved!, Def: DIMENSION_VEHICLE2.VEHICLE_TYPE = 'pedestrian'; (d) UPC: 6-10: Without pedestrian, Des: All accidents in which no pedestrian is involved!, Def: fact_accident.accident_key not in (select fact_accident.accident_key from fact_accident, dimension_person_1 where dimension_person_1.person_class = 'pedestrian' and fact_accident.dim_person_1_key = dimension_person_1.dim_person_1_key )

No records Found
afaatim.com copyright © April 2016 Dr.K.R.Kamaal. All rights reserved