Jump to content

Unnecessary complexity? Advice requested


rogerpearson

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

Recommended Posts

  • Newbies

Hi all,

I'd like some advice on a solution I'm working on.

The database i'm creating has the following elements:

Artefacts: these can be e.g. podcasts, e-tutorials, books etc

Artefacts are grouped by module, i'e a module has a number of artefacts:

Projects and tasks: this part (Left of graph) is straight from the Filemaker solution.

I originally started with Artefacts purely for tracking production and have subsequently joined it to the Projects and Tasks.

The purpose of the database:

I wish to allocate users tasks and join the artefacts with the tasks. This can be done individually or by module. I used the table Task Artefact Join to accomplish this

One regular task is to create a new cohort on our VLE. Each cohort will have a different name; I created Tasks Module join for this purpose. It is essentially a checklist for each module that is uploaded to the VLE.

I also wish to track progress of each artefact's production, e.g. who wrote it and when, who is editing it, who voiceover etc.

Tables: Ignoring the left of the graph, the tables i originally created were Modules, Artefacts, Artefact types, Task artefact join, Task Module join. Some of the TOs on the graph are for hierarchical dropdown menus.

So far so good - the database did what i wanted it to.

I then realised that I needed to create versions of each Artefact for amendments, corrections, updates etc. (V1, V2 etc).

I then created a copy of the Artefacts table: Artefacts Versions as one Artefact can have many versions. I also removed many of the fields in Artefacts to avoid duplication.

This is where my problem lies: I think that the table Task artefact join may be now superfluous and that Artefacts Versions could be used as the many to many link between Artefacts and Tasks. Or have I got the solution completely wrong?

I be very grateful if someone could point me in the right direction.

Roger

 

Screen Shot 2015-09-10 at 10.34.20.png

Edited by rogerpearson
Additional information
Link to comment
Share on other sites

This topic is 3095 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.