intelligence db ideas

redoktober · Post by **redoktober** » Sun Sep 06, 2009 4:18 am

hey all!
now, before reading this post, i guess it's a good idea to check out the following links:

http://en.wikipedia.org/wiki/A-Space
http://en.wikipedia.org/wiki/UK-USA_Security_Agreement

okay.
now, i'm planning to design a web-based portal, to cater to need for a collaborative workspace for the 5 agencies mentioned in the second article.
the thing is, i'm a little stuck with the part about designing the database.
like, what all tables should be there, columns etc.
for now, i've decidedd on something like:

Code: Select all

Table-->Data_Snippets
Fields--->Snippet_ID, Snippet_Originator, Snippet_Description, Snippet_Concerns

Table-->Members
Fields-->Member_ID, Member_Name and so on.

obviously, this is way too small, and way too incomplete.
i'd be grateful for some help here.

thanks!