• imsld_imslds: This table is used to store all the units of learning. This is the high level in the hierarchy. Each IMS LD file loaded in .LRN will generate an entrance in this table. This table contains all the different units of learning. Each unit of learning will contain global information and also references to other tables for having all the required information of a unit of learning

  • imsld_id - identifier

  • version - version number

  • uri - uri of the imsld

  • level - A, B or C. It is the level of the IMS LD file that arrive

  • sequence_p - sequence used, true or false. True means simple sequencing is being used. Defaults to false

  • learning_objective_id - references imsld_learning_objectives

  • title

  • method_id - references imsld_methods

  • prerequisite_id - references imsld_itemmodel

  • component_id - references imsld_components

  • complete_unit_of_learning_id - references complete_unit_of_learning

• imsld_complete_unit_of_learning. This tables describes the actions to do when a unit of learning is completed

  • complete_unit_of_learning_id

  • when_property_value_is_set_id * - references imsld_when_property_value_is_set

• imsld_prerequisites. It has all the prerequisites of a unit of learning. These are the previous knolowdges that are required for doing the unit of learning

  • prerequisite_id

  • prerequisite_item - references imsld_items

• imsld_components: Used to store all the components of the IMS LD

  • component_id

  • role_id - references imsld_roles

  • activity_id - references imsld_activities

  • environment_id - references imsld_environments

  • property_id * - references imsld_properties

• imsld_roles. This table contains all the defined roles

  • role_id - references imsld_roles

  • role_types - references role_types_id

  • create_new_p - multopleoccurrences of this role may be created during runtime?

  • match_n_persons - exclusively-in-roles, not-esclusively

  • max_persons. Maximum number of persons for this role

  • min_persons. Minimum number of persons for this role

  • role_name. The name of the role

  • information_id - references imsld_items

  • role_parent_id. The parent role. This allows a hierarchy of roles. The root of the hierarchy are learner and stuff, which has not a parent role

• imsld_activities. This table defines the three types of activities in IMS LD: learning activities, support activities and structure activities. These three tables references to this table

  • activity_id

  • activity_structure_id - references imsld_activity_structures

• imsld_learning_activities. This table stores all the learning activities of IMS LD

  • learning_activity_id - references imsld_activities

  • title

  • isvisible_p - initial visibility attribute. Initial value: true

  • learning_obective_id - references imsld_learning_objectives

  • prerequisite_id - refereces imsld_itemmodel

  • parameter_id - references imsld_parameters

  • activity_description_id - references imsld_items

  • complete_activity_id - references complete_activities

  • on_completion_id * - references imsld_on_completions

• imsld_complete_activities. This is a table where for each entry is specified when an activity is considered completed

  • complete_activity_id

  • user_choice - the user specifies that this activity is completed

  • time_limit - references imsld_time_limits. The activity is completed when the time is completed

  • when_property_value_is_set_id * - references imsld_when_property_value_is_set

• imsld_learning_activity_environments_map This table maps learning activities with enviroments

  • learning_activity_id - references imsld_learning_activities

  • environment_id - references imsld_environments

• imsld_support_activities. This table stores all the support activities of IMS LD

  • support_activity_id - references imsld_activities

  • component_id - references imsld_components

  • isvisible_p - initial visibility attribute. Initial value: true

  • title. The name of the support activity

  • activity_description_id - references imsld_items

  • complete_activity_id - references imsld_complete_activities

  • on_completion_id - references imsld_on_completions

• imsld_support_activity_roles_map. This table maps a support role to an activity

  • support_activity_id - references imsld_support_activities

  • role_id - references imsld_roles

• imsld_support_activity_environments_map. This table maps support activities with enviroments

  • support_activity_id - references imsld_support_activities

  • environment_id - references imsld_environments

• imsld_activity_structures. This table contains all the activity structures of IMS LD. Each entry is one activity structure.

  • activity_structure_id - references imsld_activities

  • number_to_select - if not null, the activity structure is completed when the number of activities completed equals the number set

  • sort - possible values: as-is, visibility-order

  • structure_type - sequence or selection

  • title. The name of the activity structure

  • information_id - references imsld_items

• imsld_activity_structure_choices

  • choice_id

  • learning_activity_id - references imsld_learning_activities

  • support_activity_id - references imsld_support_atcivities

  • unit_of_learning_id - references imsld_imslds

  • activity_structure_id - references imsld_activity_structures

• imsld_activity_structure_choices_map

  • activity_structure_id - references imsld_activity_structures

  • choice_id - references imsld_activity_structure_choices

• imsld_activity_structure_environments_map

  • activity_structure_id - references imsld_activity_structures

  • environment_id - references imsld_environments

• imsld_environments

  • environment_id

• imsld_enviromnent_instances

  • enviroment_id - references imsld_environments

  • environmen_instance_id

  • title

• imsld_environment_instance_choices

  • choice_id

  • learning_object_id - references imsld_learning_objects

  • service_id - references imsld_services

  • environment_id - references imsld_environments

• imsld_environment_instances_environment_instance_choices_map

  • choice_id - references imsld_environment_instance_choices

  • environment_instance_id - references imsld_enviromnent_instances

• imsld_learning_objects

  • learning_object_id

  • class

  • isvisible_p - the user decides when the activity is completed?

  • parameter_id - references imsld_parameters

  • type - knowledge-object, tool-object, test-object, etc. (learning resource type from the IEEE LTSC LOM)

  • item_sequence_id - references ims_leanring_object_item_sequences

  • schema_sequence_id - references ims_learning_object_schema_sequences

  • item_id - references imsld_items

  • environment_id - references imsld_environments

• imsld_learning_object_item_sequences: First sequence of the learning objects

  • sequence_id

  • title

• ims_learning_object_schema_sequences: Second sequence of the learning objects

  • sequence_id

  • schema

  • schemaversion

• imsld_learning_object_item_sequence_items_map

  • sequence_id - references imsld_learning_object_item_sequences

  • item_id - references imsld_items

• imsld_parameters: Table for holding the parameter values. This table will possible dissapear, depending if in the development phase there is the need of storing more information about the parameters

  • parameter_id

  • parameter_value

• imsld_services. It contains all the services

  • service_id

  • class

  • identifier

  • isvisible_p

  • parameter_id

  • email_service - (send_mail) references imsld_email_services

  • conference_service_id - references imsld_conference_services

  • index_search_id - refernces imsld_index_search_services

• imsld_email_services. It describes all the email services

  • email_id - references imsld_services

  • select - all-persons-in-role, persons-in-role

  • title

• imsld_email_data

  • email_data_id

  • role_id - references imsld_roles

  • email_property_id - references imsld_properties *

  • username_property_id - references imsld_properties *

• imsld_email_service_email_data_map

  • email_id - references imsld_email_services

  • email_data_id - references imsld_email_data

• imsld_conference_services

  • conference_id

  • conference_type - synchronous, asynchronos or announcement

  • title

  • conference_manager_id - references imsld_roles

  • moderator_id - references imsld_roles

  • item_id - references imsld_items

• imsld_conference_participants_or_observers_map

  • conference_id - references imsld_conference_services

  • role_id - references imsld_roles

• imsld_index_search_services

  • search_service_id

  • title

  • index_class - this element selects the clss to make the index on

  • index_element - this element selects the element to make the index on

  • index_type_of_element - type of element to index on

  • search - how a user can access the indexed entities

  • search_type - type of search facility that is expected at runtime: free-text-search, index-with-reference, index-without-reference

• imsld_learning_objectives. This table contains all the different objectives of the different unit of learning and activities. Each entry of this table is a set of objectives. A set of objectives is symbolized by an itemmodel_id

  • learning_objective_id

  • itemmodel_id - references imsld_itemmodels

• imsld_methods

  • method_id

  • time_limit_id - references imsld_time_limits. If not null, the mehod is completed when this time has been completed, otherwise, the method is completed when all the plays mapped to this method through the imsld_plays_to_complete_method are completed

  • on_completion_id - references imsld_on_completions

  • condition_id * - references imsld_conditions

• imsld_plays_to_complete_method. It contains all the plays that has a method. Each play can be selected in parallel by an user during the delivering of a unit of learning

  • method_id

  • play_id

• imsld_plays

  • play_id

  • isvisible_p - the user decides when the activity is completed?

  • title

  • complete_play_id - references imsld_complete_play

  • on_completion_id - references imsld_on_completions

• imsld_complete_play

  • complete_play_id

  • when_last_act_completed - references imsld_acts. The play is completed when this act is completed

  • time_limit_id - references imsld_time_limits. The play is completed when this time is completed

  • when_property_value_is_set_id * - references imsld_when_property_value_is_set

• imsld_method_plays_map

  • method_id - references imsld_methods

  • play_id - references imsld_plays

• imsld_play_acts_map

  • play_id - references imsld_plays

  • act_id - references imsld_acts

• imsld_acts

  • act_id

  • title

  • complete_act_id - refrences imsld_complete_acts

  • on_completion_id - references on_completion

  • when_condition_true * - references imsld_when_condition_true

• imsld_complete_acts

  • complete_act_id

  • time_limit_id - references imsld_complete_acts. When not null, the act is completed when this time has been completed, otherwise, the act is completed until all role parts mapped to this complete_act_id trhoug the imsld_act_role_parts are completed

  • when_property_value_is_set_id * - references imsld_when_property_value_is_set

• imsld_act_role_parts

  • complete_act_id - references imsld_acts

  • role_part_id - references imsld_part_id

• imsld_act_role_parts_map

  • role_part_id - references imsld_role_parts

  • act_id - references imsld_acts

• imsld_role_part_choices

  • choice_id

  • learning_activity_id - references imsld_learning_activities

  • support_activity_id - references imsld_support_activities

  • unit_of_learning_id - references imsld_imslds

  • activity_structure_id - references imsld_activity_strutcures

  • environment_id - references imsld_environments

• imsld_role_parts - mapping table between acts and roles

  • role_part_id

  • title

  • role_id - references imsld_roles

  • choice_id - references imsld_role_part_choices

• imsld_on_completion

  • on_completion_id

  • feedback_description_id - references imsld_itemmodels

  • change_property_value_id * - references imsld_change_property_value

  • notification_id - references imsld_notifications **

• imsld_itemmodels. This is a table that contains a text and an id. In conjuction with the tables imsld_itemmodel and imsld_itemmodel_items_map allow to associate several items to the same itemmodel.

  • title

  • itemmodel_id

• imsld_itemmodel_items_map

  • item_id - references imsld_items

  • itemmodel_id - references imsld_itemmodels

• imsld_items. Items are used for multiple purporses in other tables. For example it can describe objectives, prerequisites, references to files, etc.

  • item_id

  • identifier. Unique identifier for the IMS LD

  • identifierref. It references the IMS CP

  • isvisible_p.

  • parameter_id

  • title: A text that can represent a prerrequisite, an objective, the name of a file, etc.

  • parent_item - references imsld_items. An item can reference to another item, wich is a sub-item or child of the one referencing it.

• imsld_time_limits

  • time_limit_id

  • time_limit - amount of time in a specific format

  • property_id * - references imsld_properties

Next, the tables necessary for Level A are drawn in the form of an E-R diagram