UniverseUniversity


Home Projects Jobs Clientele Contact

uu


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

First portion of data structure to start from



Person to Course relation:
  Type: many to many
  Fields:
    type (student/apprentice/author)

Topic to Required Topics relation:
  Type: one to many
  Fields:
    type (optional/mandatory)

Person to Topic relation
  Type: many to many
  Fields:
    type (assigned,study,competed,apprentice,teacher)

Keyword to Topic relation
  Type: one to many
  Fields:
    keyword

Explanation to Topic relation
  Type: one to many

Explanation to Person relation
  Type: one to many

Explanation
  Fields:
    name,
    reference to source,
    text

Person
  Fields:
    first name,
    last name,
    address,
    email

Topic
  Property of: course
  Fields:
    title,
    summary,
    problem

Course
  Property of: author(s)
  Fields:
    name,
    description


--
Alexey Parshin,
http://www.sptk.net

Authoright © Total Knowledge: 2001-2008