Log in
Register
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
News
Members
Current visitors
New profile posts
Search profile posts
Features
Log in
Register
Search
Search titles only
By:
Search titles only
By:
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Home
Forums
Off Topic
The Basement
Database software/applications?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="Stuart Høgg" data-source="post: 15423" data-attributes="member: 148"><p>Re: Database software/applications?</p><p></p><p>One key thing to work out is whether you need information in one table (or data set) to relate to data in another. </p><p></p><p></p><p></p><p>For example, you could have a table of players (with names, instruments, contact details, preferred monitor settings etc. ) and a table of bands. The band table, instead of having player information in it directly, would link to the info in the player table. The big advantage of this is that if you have one player who is a member of multiple bands, you only need to update his info in one place. </p><p></p><p></p><p></p><p>If you go ''relational'' like this it can rule out some of the more basic software options. However it does mean you are able to build something much more powerful and ultimately more useful. </p><p></p><p></p><p></p><p>If there's one thing I have learnt from the dabbling I have done with databases over the years, it is to try and plan as much as possible. All too often my tendency is to get stuck into building something, only to later realise that I've painted myself into a corner. </p><p></p><p></p><p></p><p>Edit: typos</p></blockquote><p></p>
[QUOTE="Stuart Høgg, post: 15423, member: 148"] Re: Database software/applications? One key thing to work out is whether you need information in one table (or data set) to relate to data in another. For example, you could have a table of players (with names, instruments, contact details, preferred monitor settings etc. ) and a table of bands. The band table, instead of having player information in it directly, would link to the info in the player table. The big advantage of this is that if you have one player who is a member of multiple bands, you only need to update his info in one place. If you go ''relational'' like this it can rule out some of the more basic software options. However it does mean you are able to build something much more powerful and ultimately more useful. If there's one thing I have learnt from the dabbling I have done with databases over the years, it is to try and plan as much as possible. All too often my tendency is to get stuck into building something, only to later realise that I've painted myself into a corner. Edit: typos [/QUOTE]
Insert quotes…
Verification
Post reply
Home
Forums
Off Topic
The Basement
Database software/applications?
Top
Bottom
Sign-up
or
log in
to join the discussion today!