Ingredients

7 APPLICATION PAGES:

• 3 Administration Pages

  • Manage Journals

  • Create Journal

  • Edit Journal

• 4 User Pages

  • View Journal

  • Journal Publisher

  • Journal Editor

  • Archive

1 DATA SOURCE:

• 1 database with:

  • 2 tables

    • Journals Includes records for all journals including fields for the ID, the journal name, its owner, a description, the archive period, and the start date.

    • JournalEntries Stores data concerning individual journal entries with fields for the ID, the related journal, the author, a title, the date and time of entry, and the journal text.

  • 1 view

    • JournalArchiveDates A virtual table that derives data from the JournalEntries table.