The choice for this Schema is to use a document centered design rather than data centered. This approach tightly bundles the information without the complexity of resolving many-to-many relationships. Simple Dublin Core is included as part of the XMLSchema definition despite concerns as to visibility; it is best to make provisions for it as the technology improves. Note that I usually work offline so the include is to a local copy. Content unit is simply a block of text together with its audit trail and links. The basic data of the content unit is UnitId, Title, Topic, and UnitContent. It's audit trail is simple: Authors, EntryDate,and ModificationDate. Links relate the content unit to topics and/or specific other content units; the relationships are drawn from two common approaches: (1) response to from bulletin board technology and (2) parent, child, sibling, cousin from linguistic semantic webs. TopicLinks supports the linkages. Finally there is one element Approval" that indicates the current state of the content unit. If the state is approved for display, the person giving the approval and the date are captured as an audit trail. UnitId is a unique identifier key for the document CNTNTUnit. It is to system derived; XSLT generate-id() function is one possible method of derivation. Topic(s) are what create relationships among the content units. It is deliberate that there are no constraints on topic even though this may create difficulties because of misspellings, etc. A browse function integrated into the search page should minimize this problem. In topic links it serves as an alternative key - a key in a many to many relationship. ApprovedForDisplay is a boolean value set to no on the creation or modification of a content unit. Only an individual with editorial privileges can set it to yes. If the value is no, the content unit will not be displayed when requested by the user. Authors is the portion of the person audit trail which tracks the original creator(s) of a content unit. Author contains the name(s) of the creator of the UnitContent. Author is retrieved from the security data using the foreign key AuthorId. AuthorId is a foreign key to the security data. It is used to retrieve Author when the XML document is created through the web application. EntryDate is the date on which the Author(s) created the CNTNTUnit Editors is the audit trail which tracks the modification of content. Editor contains the name(s) of one who changes the content of UnitContent. Editor is retrieved from the security data using the foreign key EditorId. EditorId is a foreign key to the security data. It is used to retrieve Editor when the XML document is modified through the web application. EditingDate, if present, is the date on which the content of UnitContent was modified." Approvers is the audit trail for the release to public viewing. ApprovedBy is the UserId of the individual with editorial privileges who released the content unit for display (setting of ApprovedForDisplay to yes). ApproverId is a foreign key to the security data. It is used to retrieve ApprovedBy when the XML document is released for display through the web application. ApprovalDate serves as the time-stamp of the releasing of the content unit for display (setting of ApprovedForDisplay to yes). TitleFormat is a short description of the contents of the CNTNTUnit. TitleFormat with UnitId appended is the normal heading for the content unit. Two types of content units (exercises and prompts) have a set format for title. These are reflect by the choice option in the XML schema declaration. Title is a short description of the contents of the CNTNTUnit without constaints on its contents. FormattedTitle1 is a short description of the contents of the CNTNTUnit in which the initial portion of the title is in a fixed format. This format applies to writing exercise and prompt units. While no other formatted titles are currently planned, the name is numbered to allow for simple expansion of the concept should the need arise. TitleType identifies the formatted title as either exercise or prompt"> Series is simply a fixed value (the word "series") to identify the following integer to the user. SeriesId is used to group the content units most commonly by levels of difficulty."> Number is simply a fixed value (the word "number" to identify the following integer for the user." OccurenceNumber is simply an integer used by the system to select the exercise or writing prompt of the day."> Title is a short description of the contents of the CNTNTUnit without constaints on its contents. GOSelect is an element used to categorize elements for selection in the building of a graphic organizer for a poetic form. Form is a fixed value element identifying the document as describing some type of poetic element (line, stanza or poem) that is defined by specific restrictions. TypeFormClass defines a poetic form as base, additive, compound, topical, generative, adaptive, or variant. Note only forms are used in creating default graphic organizers. GOLineStanza is a description of the number of lines in each stanza. This is used to build a basic graphic organizer for the poem form - a base form. GOLineCalculation is a formula for modifying the basic GOLineStanza description as the result of integrating additive and compound forms into the base form. Figure is a fixed value element identifying the document the document as describing a rhetorical trope or schema in classical Western rhetoric. FigureName is the name of a particular trope or schema or other rhetorical device. School is a fixed value element identifying the document as describing a poetic school (aesthetic sense). SchoolName is the common name of the poetic school described by the document. Definition is a fixed value element identifying the document as defining a poetic element. DefinedItem is the name of the poetic element being defined. SeeItem is a cross-reference to the DefinedItem carrying the definition. For example, "Iambic" pointing to "Iam". Typographical is a fixed value element identifying the document as describing a particular typographical presentation of the poetic form. This usually modifies the calculation of the number of lines or indicates a split within the lines. TypographicalVariant is the name of the typographic variant described in the document. GOLineCalculation is a formula for modifying the basic GOLineStanza description as the result of integrating typographical considerations into the poetic form. Other is a fixed value element identifying the document as describing some element of poetry that is not included in the previous element groupings. OtherName is the name of the group to which the element described in the document belongs. For example: point of view, voice ... UnitContent is the primary descriptive section of information in the document. Content descriptive element names are not used because the multi-lingual and multi-cultural nature of the site does not permit the identification of an exhaustive list of elements. A single content block is not used because the technical implementation of such a block destroys most advantages of the XML database structure. Therefore, the simple elements are described by their presentation characteristics. Note that all elements are optional, unbounded and unsequenced." ExternalBuildRoutine is a tag to a specific routine in the Java which builds a form - exercise, prompt, graphic organizer, browse/search forms and user response are the primary users. TextFormat is the element which describes the presentation characteristics of the text content of the document. Text Content is the primary content of the document. Line returns are assumed to be preserved in presentation; if there is no line return the next content element is assumed to be inline. EmbedURL is the element that allows the inclusion of an external URL. Note that the named navigation links serve the function of internal URL's. AmazonURL is a URL which is wrapped in Amazon specific code so that this site receives a commission for purchases initiated on this site. MimeType is the element which identifies the type of information included in the following binary data. This is used primarily to allow the inclusion of jpeg elements. Note: I have samples to copy but have not yet entered the necessary inclusions of external schema. MimeItem is the unparsed binary element to be included in the document. Most frequently, this is a graphic element although audio and video are potential entries. MimeTitle is an optional label for the binary content. Bold is the indicator that the CellContent is to be shown in bold, usually an indication that the cell is either a column or row heading. CellNo is the position of the CellContent within the table in row-comma-column format. CellContent is the text which is to appear in the specified table cell. TopicLinks is the group item that supports the sequential (board-like) access as well as the web (WordNet-like) access. Some of these links are derived or set by the author but it is assumed that individuals with editorial status will take primary responsibility for the links. LinkRelation identifies the relationship between the content units. It is named in the direction from this CNTNTUnit to CNTNTUnit. It has been determined that it is logically improbable that all relationships can be identified in advance. Therefore, no enumeration restraint is defined although the input form can have a drop-down list of the most common values. Note that the LinkRelation is the secondary ordering item in the navigational menus. LinkClass identifies the classification of the relationship for the purpose of ordering and positioning of the related content units in the navigational menus. The values of this element are constrained to enumerating values. LinkTopic identifies the CNTNTUnit(s) that are linked to this comment unit. The access path is defined by LinkTopic=Topic. This is primarily used for web relationships. LinkUnitId identifies the CNTNTUnit that is linked the this comment unit. The access path is defined by LinkUnitId=UnitId. This is primarily used for sequential or hierarchical/tree relationships.