Michael and others,
I tried to use the database supplied in #90 by Michael to enter the sample record he proposed. I have included a few comments.
An example individual? Okay I will make one up --- An inhumation burial from the Early Iron Age settlement at Bornais. They have no radiocarbon date but are thought to be from 700-500 BC. They were placed in a circular pit, 1m x 1m x 0.5m. They were crouched on their left side, aligned N-S, and placed with a copper bead. They are a young adult male, aged 20-25. They have not been subject to isotopic or aDNA testing but would be a good candidate.
Fleshed out version:from post #46fleshed out the brackets below: An inhumation(deposittype) burial from the Early Iron Age(TimePeriod) settlement(siteType) at Bornais(Site).
They have no radiocarbon date(AMS_C14_Dates TABLE) but are thought to be from 700-500 BC(RelativeDate FIELD). They were placed in a circular pit(DepositContext), 1m x 1m x 0.5m (Dimensions) They were crouched on their left side (Position), aligned N-S(orientation), and placed with a copper bead(ArtefactType FIELD, AssociatedGoods TABLE). They are a young adult(AgeCategory FIELD, OsteoInfo TABLE) male(OsteoSex FIELD, OsteoInfo TABLE), aged 20-25(AgeRangeLow and AgeRangeHigh FIELDS, OsteoInfo TABLE). They have not been subject to isotopic(ScienceInfo) or aDNA(ScienceInfo) testing but would be a good candidate.
I realize we are still working to flesh out the model. When I tried, I could not find a way to enter all the data.
Implication,
-my process was incorrect or
-the form lacks certain options or
-the relationships do not support the sample or
-the sample may not be logically consistent or
- something else??
Some observations for consideration:
Perhaps RelativeDate should be a prepopulaed list of choices or you'll get mishmash
No access to DepositContexts
No access to OsteoIfo
No access to ScienceInfo
Perhaps it's time to define all tables and all fields for clarity
Aren't inhumation, cremation, disarticulated, partial-secondary and comingled all the subtypes of Deposit?
If so, seems an approach to designing data entry --at east for Deposit and subtypes
-define common fields for all deposit types along with source of FK fields
-define unique fields for inhumation
-define unique fields for cremation
-define unique fields for disarticulated
-define unique fields for partial_secondary
-define unique fields for comingled
The sources of info for each of the fields in Deposits and each subtype have to be available when entering data.
From a recording perspective, starting with frmSites seems logical.