Level B extends the table email_data and add: username_property_id and email_property_id * Next is shown the E-R diagram for these tables

• imsld_properties (add a reference to properties from imsld_components and time_limits *)

  • property_id

• imsld_loc_locpers_locrole_properties: Combined table for the loc, locpers and locrole properties

  • property_id - references imsld_properties

  • title. The name of the property

  • datatype - references imsld_datatypes

  • initial_value

• imsld_globpers_glob_property: Combined table for the glob and globpers properties

  • property_id - references imsld_properties

  • global_definition_id - references imsld_global_definitions

  • existing

• imsld_global_definitions

  • property_id - references imsld_properties

  • uri

  • title

  • global_definition

  • datatype_id

  • initial_value

• imsld_property_groups

  • property_group_id

  • property_id - references imsld_properties

  • title

• imsld_group_property_coices

  • choice_id

  • property_id - references imsld_properties

  • proerty_group_id - references imsld_property_groups

• imsld_restrictions

  • restriction_id

  • restriction_type - minExclusive, minInclusive, maxExclusive, maxInclusive, totalDigits, fractionDigits, length, minLength, maxLength, enumeration, whiteSpace, pattern

  • restriction

• imsld_property_restrictions_map

  • restriction_id - references imsld_restrictions

  • property_id - references imsld_properties

• imsld_datatypes

  • datatype_id

  • datatype - string, boolean, integer, uri, datetime, file, real, tet, duration, other

• imsld_when_property_value_is_set (add a reference to this table from the tables: complete_activities, complete_act, complete_play and complete_unit_of_learning *)

  • when_property_value_is_set_id

  • property_id - references imsld_properties

  • property_value_id - references property_values

• imsld_property_values

  • property_value_id

  • langstirng

  • calculate_id - references imsld_calculates

  • property_id - references imsld_properties

• imsld_change_property_values: A reference to this table must be added from the imsld_on_completion table in level A

  • change_property_value_id

  • property_id - references imsld_properties

  • property_vaue_id - references property_values

• imsld_monitors

  • monitor_id

  • serivce_id - references imsld_services

  • monitor_choice_id - references imsld_monitor_choices

• imsld_monitor_choices

  • choice_id

  • role_id - references imsld_roles

  • self - references imsld_roles

• imsld_conditions: A reference to this table must be added fom the table imsld_methods in level A

  • condition_id

  • title

• imsld_sequences

  • sequence_id

  • condition_id - references imsld_conditions

  • sequence_sort - to know how to evaluate the condition

  • if_id - references imsld_ifs

• imsld_then_model

  • then_model_id

  • show_id - references imsld_show_hide

  • hide_id - references imsld_show_hide

  • change_property_value

• imsld_ifs

  • if_id

  • expression_id - references imsld_expressions

  • true_thenmodel_id - 'then', evaluated if the expression is true. References imsld_then_model

  • false_thenmodel_id - 'else', evaluated if the expresison is false. References imsld_then_model

• imsld_expressions - table holding the expressions. Instead of makin a table for each type of expression, we store the expression_type and according to that value we know what other attributes in the table have to be stored in order to use them

  • expression_id

  • expression_type - is-member-of-role, is, is-not, and, or, sum, substract, multiply, divide, greater-than, less-than, users-in-role, no-vaue, time-unit-of-learning-started, datetime-activity-started, current-datetime, complete, not

  • expression_id - references imsld_expressions

  • calculate_id - references imsld_calculates

  • expression_one_id - references imsld_expressions

  • expression_two_id - references imsld_expressions

  • role_id - references imsld_roles

  • property_id - references imsld_properties

  • time_unit_of_learning_started

  • datetime_activity_started

  • current_datetime

• imsld_calculates

  • calculate_id

  • right_operand - references imsld_operands

  • left_operand - references imsld_operands

• imsld_operands

  • operand_id

  • property_id - references imsld_properties

  • property_value - references imsld_property_values

  • expression_id - refernces imsld_expressions

• imsld_when_condition_true (add a reference from the imsld_complete_acts table *)

  • when_condition_true_id

  • role_id - references imsld_roles

  • expression_id - references imsld_expressions

• imsld_show_hide

  • show_hide_id

  • class

  • item_id - references imsld_items

  • environment_id - references imsld_environments

  • learning_activity_id - references imsld_learning_activities

  • support_activity_id - references imsld_support_atctivities

  • activity_structure_id - references imsld_activity_structures

  • play_id - references imsld_plays

  • unit_of_learning_id - references imsld_imslds

• imsld_global_elements

  • global_element_id

  • view_set_property_id - references view_set_properties

• imsld_view_set_properties

  • view_set_property_id

  • type - view-property, view-property-group, set-property, set-property-group

  • href

  • property_of - self or supporter-person

  • ref

  • view - value or title-value

  • max_transactions

  • transaction_type

  • notification_id - references imsld_notifications **