interesting MS SQL does allow to store coordinates like GPS and reporting services i think can do reports by maps ..... cant quite remember where i read that ... Any ways you can pull reports on a map that show in which location which types of accidents happen ...inturn it will help traffic police to put up proper road signs (dont any one burst my bubble) and maybe shre you data with car GPS systems provider like Garmin and people can be aware of the danger spots (i think the black spot warning sign that usually is knocked down dont do much good )GG
On Tue, Oct 25, 2011 at 10:17 PM, [ Brainiac ] <arebacollins@gmail.com> wrote:@peter, the logic of structuring categories as entries in a table is one very sound one, If i were you i would not ignore it (unless this piece of software is what my peeps call <hit and run >, design the system with future needs in mind, create a table for categories, give them a unique id and in your query do a count where category id is used to deal with duplicates.
--On Tue, Oct 25, 2011 at 8:24 PM, <mwirigic@gmail.com> wrote:You can always add categories later if you come across an unhandled category.
For the question of an accident being in more than one category, you can introduce a table to map accidents to a category resulting in 3 tables
1. Accident - contains the accident details, time, location... Blah blah blah
2. Categories - contains ur accidents defination
3. AccidentMappings - maps an accident to a catrgory, contains 2 foreign keys categoryID, AccidentID . Add a unique key on (categoryID,AccidentID)
Sent from my BlackBerry®
-----Original Message-----
From: Peter Karunyu <pkarunyu@gmail.com>
Sender: skunkworks-bounces@lists.my.co.ke
Date: Tue, 25 Oct 2011 11:40:02
To: Shadrack Mwaniki<shadrack_mwaniki@yahoo.com>; Skunkworks Mailing List<skunkworks@lists.my.co.ke>
Reply-To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Database design question
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
“The twentieth century has been characterized by three developments of great political importance: the growth of democracy, the growth of corporate power, and the growth of corporate propaganda as a means of protecting corporate power against democracy” ~ Alex Carey ~
Tel No: 0x2af23696
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke--
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke