Click here to Skip to main content
15,921,941 members
Home / Discussions / Database
   

Database

 
Generalweird Oracle problem Pin
pankajdaga27-Jun-04 1:57
pankajdaga27-Jun-04 1:57 
GeneralRe: weird Oracle problem Pin
ThomasH119-Jul-04 12:27
ThomasH119-Jul-04 12:27 
GeneralHelp with SQL query Pin
brdavid26-Jun-04 9:52
brdavid26-Jun-04 9:52 
GeneralRe: Help with SQL query Pin
Michael Potter28-Jun-04 7:07
Michael Potter28-Jun-04 7:07 
GeneralRe: Help with SQL query Pin
brdavid28-Jun-04 9:11
brdavid28-Jun-04 9:11 
GeneralRe: Help with SQL query Pin
Michael Potter28-Jun-04 10:37
Michael Potter28-Jun-04 10:37 
GeneralRe: Help with SQL query Pin
brdavid28-Jun-04 12:04
brdavid28-Jun-04 12:04 
GeneralRe: Help with SQL query Pin
Michael Potter29-Jun-04 8:55
Michael Potter29-Jun-04 8:55 
I am assuming the ERACODE and AGECODE are Primary Keys that are never displayed to the user. If this is the case then your time-spans are defined correctly. You are not storing any sequence information but, that might not be important for you application.

Currently, you have 11 AGES records. If the count is not going to be enourmous (100+), I would just load them all into memory and use RegEx to do any fancy searches. I always try to never store calculated data - it can make your edit code more difficult. You can also create a query in Access that handles the calculation on the fly and query against that.

Currently, I would only remove ERACODE from the SKILLSINAGES since AGES already contains a link to it. It is unnecessary duplication. Of course, you will have to back it up with a unique constraint on the EARCODE + AGES.DESCRIPTION Columns. You don't want your users defining two AGES within the same ERAS that have the same DESCRIPTION.


Your next chain looks like this:

GROUPS
|----CATEGORIES
     |----SKILLS
          |----SUBSKILLS  


Knowing the SUBSKILLS you should be able to get the SKILLS, CATEGORIES and GROUPS without a problem. There is no need to duplicate this information within each table.

Your SKILLSINAGES table becomes.
SKILLSINAGES
=================
SkillInAgesId - Primary Key
AgeCode
SubSkillCode


Some people would use AgeCode + SubSkillCode as the primary key. I have always liked PK's that have no meaning other than to uniquely identify the row. There are good arguements on both sides of the issue.
GeneralRe: Help with SQL query Pin
brdavid30-Jun-04 2:37
brdavid30-Jun-04 2:37 
GeneralRe: Help with SQL query Pin
Grimolfr28-Jun-04 9:58
Grimolfr28-Jun-04 9:58 
GeneralInserting Rows... Pin
Sai197125-Jun-04 19:59
Sai197125-Jun-04 19:59 
GeneralRe: Inserting Rows... Pin
Rein Hillmann26-Jun-04 22:11
Rein Hillmann26-Jun-04 22:11 
QuestionHow Can I Join more than two tables in SQL Pin
JawedVikia8024-Jun-04 21:40
JawedVikia8024-Jun-04 21:40 
AnswerRe: How Can I Join more than two tables in SQL Pin
Colin Angus Mackay24-Jun-04 22:03
Colin Angus Mackay24-Jun-04 22:03 
AnswerRe: How Can I Join more than two tables in SQL Pin
wgdesigner25-Jun-04 1:38
wgdesigner25-Jun-04 1:38 
GeneralConcurrency Pin
IamADotNetGuy24-Jun-04 10:04
IamADotNetGuy24-Jun-04 10:04 
GeneralRe: Concurrency Pin
Rein Hillmann26-Jun-04 22:13
Rein Hillmann26-Jun-04 22:13 
GeneralRe: Concurrency Pin
Grimolfr28-Jun-04 7:56
Grimolfr28-Jun-04 7:56 
GeneralRe: Concurrency Pin
IamADotNetGuy28-Jun-04 8:07
IamADotNetGuy28-Jun-04 8:07 
GeneralSQL Query Pin
Guinness4Strength24-Jun-04 9:39
Guinness4Strength24-Jun-04 9:39 
GeneralRe: SQL Query Pin
Michael Potter25-Jun-04 3:32
Michael Potter25-Jun-04 3:32 
Generalproblem: records appear twice in dataset Pin
sharonz24-Jun-04 6:30
sharonz24-Jun-04 6:30 
GeneralRe: problem: records appear twice in dataset Pin
IamADotNetGuy28-Jun-04 10:43
IamADotNetGuy28-Jun-04 10:43 
GeneralVery easy question Pin
Guinness4Strength24-Jun-04 5:57
Guinness4Strength24-Jun-04 5:57 
GeneralRe: Very easy question Pin
Colin Angus Mackay24-Jun-04 6:14
Colin Angus Mackay24-Jun-04 6:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.