Development Best Approach Question 1

[peciam]

Hello to all,

I am at a developers block or just stuck, or maybe just stupid.

With that said I have a question(s)on best approach method.

Users have a collective bargaining agreement(CBA) database. It lists info about the CBA, years covered, who CBA covers, type, etc. They now want to add a salary database that only applys to CBA(s) that have certain members, if it has those members covered under the CBA they want to imput salary data to span the years covered by the CBA, in one year groups.

My question is should I put the salary form as part of the main CBA form? Have a pop-up form to enter salary data. The salary data spans year to year, so one CBA form many span 5 years, therefore the salary data database will have 5 years data, one recond for each year. A one to many relation, I think. I want to make sure I maintain a proper relation model.

Any examples out there I would be real interested in viewing. Always welcome comments or suggestions.

Thank you!

 

[lespaul]

have you read the fundamentals document linked below?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[peciam]

Yes, I have it on my desk now and have read it and continue to refer to it.

 

[lespaul]

ok good! that simplifies things alot!

what kind of "salary" information do they want to store? is it for a person or a job classification? Is it a salary range or something measured on a specific date?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[peciam]

Hi Leslie,

Salary data will be by job title, teaching assistant for instance. Minimum salary, maximum, years to max, and if field if the contract only have a starting salary. Each year convered by the contract will have the salary data.

 

[lespaul]

Ok, then I would have a table for the salary information, a FK to the CBA agreement that it relates to and store all the information there.

Leslie

 

[peciam]

Hi,

Thanks, I have done that so far. What is a FK?

 

[PHV]

FK = Foreign Key
PK = Primary Key
Usually a FK references a PK in another table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886