Statistics department of a particular educational institute in India is studying the following:

$($i$)$ Average accidents per year by states

$($ii$)$ Age group of victims

$($iii$)$ Type of vehicle that caused maximum accidents

$($iv$)$ Time $($Morning$,$ Noon, Evening or Night$)$ of the day when maximum accidents happened

$($v$)$ Age group of drivers.

Can you show the design with example

a$)$ A row format database with tables to record the raw data

b$)$ A column format database with tables to calculate the above said values