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 draw in the form of an E-R diagram
