Morning all,


I have been given a small project at work to create a database from scratch which is basically to log incidents.

I have identified the information which I need to record but am struggling to break this down into the required tables and attributes.

Information to be stored.
Unique Incident Number
Year of incident
Month of incident
Day of incident (Mon, Tue etc)
Time of incident
Location of incident (there are 100 potential locations)
Severity of incident (Low / Medium / High)

All of the examples on 'how to create and ERD' always use the customer / order / product scenario which I understand, but i cant apply that model to this set of requirements.

Once created, I need to be able to say where the most events have occurred / where no events have occurred / on what month or day do most events occur etc.

Any help would be awesome....thanks.