codejunkie Posted December 19, 2004 Share Posted December 19, 2004 Please could you Database/SQL Nuts please have a look at my database that will eventually hold the tweaks for my freely available tweak tool.Link to Database v1.00.00Link to Database v1.00.01 - Added Quiries as there where missing from the exported filePlease could you give me some pointers, as I am a novice when it comes to database design.I will be using VB.NET to interact with the database and also ASP.NETThere is no website as I want to build it around my database and I want to make shour I have covered everything I will need later on.I have got my database design in PowerDesign to only 5 Warnings ONLY from 30 and 6 Errors Link to comment Share on other sites More sharing options...
army20 Posted December 19, 2004 Share Posted December 19, 2004 Better view in relationship help me a lotExemple Here Link to comment Share on other sites More sharing options...
codejunkie Posted December 19, 2004 Author Share Posted December 19, 2004 At the moment I am trying out a tool called PowerDesigner 10, its very good, but I'm having to learn it the hard way, trial and error Im getting there now, I have found easier to use then MS Access, but I did the basic design in Access first and then imported it. Link to comment Share on other sites More sharing options...
rolfenstein Posted December 20, 2004 Share Posted December 20, 2004 @Junkie: I'm curious, do you need these ID-fields of the relations at all? It looks like you're referencing everything by name, etc. I prefer relations by absolutely unique IDs, because you won't ever get in trouble with duplicate records due to the fact that the system creates the primary key itself, I thinks that's pretty neat Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now