Not sure this is the right list for this, but I don't think I'm on a better one so I thought I'd try anyway.
OLAC (Online Audiovisual Catalogers) has been working on a project to investigate what it would mean to catalog moving image works and how that might be implemented in practical terms. In conjunction with this, a colleague of mine has volunteered to build a demo interface for a work-centric catalog and I have been preparing some sample data for this.
This started out simply, but once I got into the sample data, it was a little less clear-cut than my original basic idea. I have put the sample records in Access and tried to arrange the data and relationships in some sensible way.
I have also put up some documents related to this at https://ilocker.bsu.edu/users/kmcgrath/world_shared that I hope some of you will be willing to take a look at. The main one is called MIWDemoQuestions.doc and gives an overview of what I have done so far and some things that I am finding problematic. There is also a document called MIWDemoFields.doc that is just a brief explanation of the different fields (which are not intended to be comprehensive, but just enough to demonstrate the concept). There is also a file with example records using the sample data (MIWDemoExampleRecords.pdf) and a couple of examples I have extracted for a quick overview, one of a feature film and one of a nonfiction TV program (MIWDemoFeatureExample.pdf and MIWDemoTVexample.pdf)
Anyway, if anyone knows more about E-R modeling than I do and has some insight about how I might better approach this, I'd greatly appreciate it. I found this quite complicated and even worse to try to explain so please let me know if anything is unclear.
TIA!
Kelley McGrath
Chair, OLAC Moving Image Work-Level Records Task Force
kmcgrath_at_bsu.edu
Received on Tue Aug 11 2009 - 15:10:54 EDT