Jump to content

table for year/quarter data?


Bobfmf

This topic is 6568 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm skethching out an ERD for a solution in which multiple (at least 2) tables, will need to reference a value for a specific quarter and year, e.g., "2006 summer", "2006 fall", etc., for the purpose of creating join tables where instructors and educational specialists are linked to occurrences of instructional 'courses'.

My plan is to create a value list for the data (e.g., "2006 summer; 2006 fall", etc.). The value list needs to exist in some table; since more than one table will be referencing it, shall make a table for this data, and relate it to the tables that will need to reference it? Thanks.

Edited by Guest
Link to comment
Share on other sites

Thanks, that is what I was leaning toward. Since more than one table will need access to it, I'm not sure which table to place it in. SInce the tables are related, I suppose it doesn't matter technically -- it's more an issue of placing it in a table that sort of makes sense.

Bob

Link to comment
Share on other sites

Instructors work with technical employees to create learning resources. We want a record of these creations, including the instructor and tech employee involved with the creation of each resource, which year and quarter it was created (e.g., 2006_Spring), as well as the instructor and tech employee currently responsible for each resource. Resources are often linked with (used by) current course sections (there are many sections per course). This linkage is represented by a join entity (table), which includes the year and quarter of each resource usage by the sections.

Bob

Edited by Guest
I removed the ERD, which turns out is not relevant (the next reply clears everything up).
Link to comment
Share on other sites

Are you asking how to create a relationship using the Year & Quarter, or are you asking how to create a value list to hold the possible values of Year & Quarter?

For a custom value list, the values are simply entered in the value list definition. They are not tied to a specific table, and all tables in the file have access to it. Other files can also access the value list by selecting the option to "Use value list from another file..."

Link to comment
Share on other sites

My bad... I was thinking about having multiple files and having to associate the Value List to a particular file -- but my solution will be one file, many tables, so, as you write, there is no table association. Thanks for straightening me out on that -- it makes the everything much easier.

Bob

Link to comment
Share on other sites

This topic is 6568 days old. Please don't post here. Open a new topic instead.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.