I'm beginning to work out the structure for the tables in the database for the Victorian Poetry database.
The primary unit in this database appears to be a published-poem.
Each published-poem has a relationship to a poem and to a periodical. Each poem has a relationship to an author.
There are some questions that I need MT to answer before I can continue.
1) Will there be any instances of a poem having more than one author?
2) Do we distinguish between a poem with no author and poem whose author is anonymous?
3) Do we have one anonymous author associated with all unattributed to poems, or do some unattributed poems get associated with one "anonymous" and other unattributed poems get associated with another "anonymous" (for example, if you have a collection of poems you know to be written by one unknown person and wish to distinguish that author from another unknown person who wrote another poem)
4) We've noted that authorship can be declared or can be inferred by the scholar, are there any other ways authorship is attributed? (We'll need to include a "authorship_determined_by" field to contain that information.)
5) We need to tighten up conventions on what information we capture about each person's name (and possible title or other identifiers) and how each of those is to be represented in the spreadsheet. The most common presentation of author name is Surname, FirstName, but a number of entries don't conform, for example these from DarkBlue.xls:
Ca(d)(l)verley, C.S.
see title
R.G.
Professor Sylvester
the late John Lyall
Leary (D.C.L.), T.H.L.
And these from DublinU:
M
M?
'Filia'
The London Hermit
Rev. Dr. MacMoreland
And these from PoetryIndex_1.docx
Edward Oxenford
We discussed having an "author-as-found" field and an "author-normalized" field.
6) Do we separate author surnames from given names e.g. for purposes of searching?
7) We also need to tighten up conventions on what information we capture about each published poem's title and how each of those is to be represented in the spreadsheet. Some of the "titles" appear to be titles, others appear to be the first line of the poem. Do we want to distinguish between those?
8) These are instances of titles that appear to contain more than just the title. Do we need to do anything with these other than reproduce the characters as found?
Tragedy (trans. from the German by Franz Huffer)
The Story of Europa (Hor. Od. III. Xxvii. 25.)
'Amour qui Sourit Caché'
One untitled poem opens and two close the author’s essay “Sketches of Travel in Germany”
9) This example of a title in DarkBlue appears to refer to a collection of poems.
Garden Poems (I.—The Garden, II.—Visions, III.—The Bird ...)
This example from DublinU also appears to refer to a collection, but is treated differently:
I [Happiest of happy feelings ‘tis to feel]
II [If gold could give us peace]
We have no structure right now for handling collections of poems. Should we? That is, do we want to treat an entire collection as one poem (what about collections whose poems are written by different authors) or do you want to treat each poem in a collection as a separate poem and then add a "collections" table and some way of relating each of the poems to the collection?
10)
In the poetryindex_1 file, a typical entry begins like this:
[January 1886]
No. 1, 129
(7)
Whereas, in DarkBlue the issue/page field looks like this:
1 (March 1871): 35
What does each piece of information in both types of entry identify? We'll need to normalize that.
Leaving early...
Met with SaraB of History and ErinC of finearts and Judy to discuss a small website to support the Early Modern Research Collective. They want something modelled on the Medieval Studies site, though only one level of navigation. They sent representative images and also suggested the use of images of plates or coins where medieval used shields. I told them that the resources HCMC could put in would be those we'd use to create the site using UVic templates. Judy wrote up the following notes. I've tasked her with creating a site based on the Medieval studies website, but simplified as appropriate.
Structure:
- visually similar to Medieval Studies website
- 1 layer (with "Global" logo on top right-side)
- no tables
- basically text and images
- repeating signature image (decide later, artist/budget required)
Tabs:
- coloured plates, round
- same size as MS shields
Banner:
UVic's EMRC on Banner
Navigation:
Left nav (balance with right side " Announcements")
Announcements:
on Current Events Page only
Pages: (ref further to your email received 10-07-10)
Home
Courses - list courses on one page only (Undergrad, Grad)
Current Events - leave on Home page only; need an Events page short
form; Events page separate page
Faculty - do 2 columns
Resources
Contact Us
Content:
- graphics; composition
- lists, text, paragraphs, headings
- don't need News Flash - change notice
- no audio or video requirements
Upcoming and Past Events on 1 Events page with most current at top
descending in date
Colour, Font:
- prefer light background (e.g. Faculty of Humanities website - white)
- prefer striking/simple, no blandness
Timeframe:
couple of weeks (mid November)
Summary:
- Color: TBA - they will choose according to selection of final images
- Images: Erin will send to Sara who will send to us; Sara will send
text to us
- Events Calendar: is the only urgent item
- Left nav: on each page with imbedded picture as repeated element on
each page
- Top banner: includes "Who We Are" symbol/text
- FONT: Arial; Helvetica