www.themutepoint.com Forum Index www.themutepoint.com
Leicesters Games Soc Site
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Anyone know anything about databases?

 
Post new topic   Reply to topic    www.themutepoint.com Forum Index -> General
View previous topic :: View next topic  
Author Message
Mad Dwarf



Joined: 09 Oct 2003
Posts: 1556

PostPosted: Fri Aug 31, 2007 9:14 am    Post subject: Anyone know anything about databases? Reply with quote

Not exactly "online", but PC based question.
I am trying to build a database (Using MS Access) to keep track of our Characters, and possibly for use in-game for determining skill-checks etc.
Due to my newbie-ness with databases I am struggling to figure how to build the right tables and relationships.
Has anyone done this before?
Can anyone advise me how this should be done?
_________________
Looking for Inspirational Apps?
https://play.google.com/store/apps/developer?id=Mad+Dwarf+Productions
Looking for computer help in Leicestershire?
http://www.thepcwizarduk.com
Looking for Art, Crafts or Gift Ideas?
http://www.thecrystalwizard.co.uk
Back to top
View user's profile Send private message Visit poster's website
antiwiggle



Joined: 02 Oct 2003
Posts: 522
Location: Frankenstein's other lab

PostPosted: Fri Aug 31, 2007 11:09 am    Post subject: Reply with quote

A lot of it depends on how you plan to use the data. Work out what you want to do and try and design you tables accordingly.

Usually there is no one right answer to DB design.

One simple design would be:

CHARACTER TABLE
CHAR_ID <-- Primary key
NAME <-- Character name

SKILL TABLE
SKILL_ID <-- Primary key
SKILL_NAME

ITEM TABLE
ITEM_ID <-- Primary key
ITEM_NAME

These would be fairly static, you would probably change them only rarely. Of course to be useful these tables would have to include more information .

HAS_SKILLS TABLE
CHAR_ID <-- Foreign key from CHARACTER table
SKILL_ID <-- Foreign key from SKILL table
SKILL_LEVEL <-- Some additional data

OWNS_ITEMS TABLE
CHAR_ID <-- Foreign key from CHARACTER table
ITEM_ID <-- Foreign key from ITEM table

These would be more dynamic, changing when a character gains or loses and item or skill.

This is one way to do it, there are many others.
Back to top
View user's profile Send private message
Mad Dwarf



Joined: 09 Oct 2003
Posts: 1556

PostPosted: Sat Sep 01, 2007 6:54 pm    Post subject: Reply with quote

Thanks. Simple is good Smile
I now have the basic tables I need (although there must be a better way of building them .. had to enter some data multiple times ... )
Now to find a useful way of pulling certain types of data ...
Say I want to have a Task Sheet, where I can have, for example, a set of drop-down lists:
1) Character
2) Stat
3) Skill
so I can choose who will do the task, and their competence in the area. Preferably with it both displaying the individual results (stat level, skill level) and the total (For Exalted, a simple stat-level+skill-level). Adding the dice-roller is a task for another day 8o)

If you know of any decent tutorials that might help, please let me know Smile
_________________
Looking for Inspirational Apps?
https://play.google.com/store/apps/developer?id=Mad+Dwarf+Productions
Looking for computer help in Leicestershire?
http://www.thepcwizarduk.com
Looking for Art, Crafts or Gift Ideas?
http://www.thecrystalwizard.co.uk
Back to top
View user's profile Send private message Visit poster's website
antiwiggle



Joined: 02 Oct 2003
Posts: 522
Location: Frankenstein's other lab

PostPosted: Mon Sep 03, 2007 8:56 am    Post subject: Reply with quote

Mad Dwarf wrote:

I now have the basic tables I need (although there must be a better way of building them .. had to enter some data multiple times ... )


It has been several years since I last used MS Access but as far as I can remember creating tables was quite straight forward.

If you are filling in character data more than once you probably have a problem with your design (not fully normalised to use DB speak).

Mad Dwarf wrote:

If you know of any decent tutorials that might help, please let me know Smile


I don't, it's been a while since I used it.
Back to top
View user's profile Send private message
I-KP



Joined: 25 Sep 2003
Posts: 3770
Location: Iddheim

PostPosted: Mon Sep 03, 2007 11:01 am    Post subject: Reply with quote

Phil,

Google is your friend. I taught myself Access, Transact-SQL and SQL Server DBA using naught but t'internet. Although, I would avoid using the MS website - there are far better instructional resources available.
_________________
Elements of the past and future combining to make something not quite as good as either.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    www.themutepoint.com Forum Index -> General All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group