Home » Repository

Organisation and content

Submitted by carola.schauer on Wed, 2007-05-30 11:18.
Graphical represenation of the model: 
FGFrank-Website-DataModel_orga.jpg
Model Master Data
Overview: 

This data model represents the underlying structure of the database-oriented Web site of the research group Information Systems and Enterprise Modelling, University Duisburg-Essen.
The model on this page includes all concepts related to organisation including group membership and individual personal Web site contents.

Purpose: 

This model represents an abstraction of the tables and attributes of the database which serves as backend for managing the information provided on our research group's Web site.

The main reason for developing and implementing a specific data model (instead of using a general available content management system) was to support a high level of integration and, in this way, minimize redundancies and maintenance efforts. The concepts 'Person' and 'Topic' are exemplary for the high level of integration achieved by a common data model for the entire Web site.

Context/domain: 
The model represents relevant information of a University research group: group memberships, teaching issues (courses, exams, theses, etc.), and research issues (projects, publications, conferences, etc.).
Stakeholders and prospective users: 

Research group members and Web administrators, who intend to develop an information system to document the (public) teaching and research activities of a research group.

Assumptions: 
The corresponding information system for inserting and updating Web site information is intended for knowledgeable users. Certain modelling decisions were taken under this assumption allowing a more flexible system, e.g. the ability to represent advisors or lecturers, which are no members of the research group.
Transformation: 
The model is intended to be transformed into a database schema and might serve as basis for a respective software.
Relevant design decisions and discussion of possible alternatives: 
Since the objective was to implement the model with reasonable effort, some rather pragmatic modelling decisions were made. There are some elements which are deliberately not modelled in more detail in order to reduce the complexity of programming the insert, update and display functions (e.g. „Title“,"SeminarSupervisor“).
Relationships to other open models: 
Data model for research group web site
About
Name of model owner: 
carola.schauer
Juergen.Jung
Ulrich Frank
Affiliation of model owner: 

Research group Information Systems and Enterprise Modelling, University Duisburg-Essen

Modelling language: 
kind of ERM, similar to UML class diagrams (static, all models without operations, overview model without attributes)
Version of modelling language: 
-
Justification of modelling language: 
familiarity with ERM/UML
Modelling Tool(s) used: 
Visio
Model Layer: 
Type Level
Model Category: 
data model
Add a sub-model using free text: 
Add a sub-model using free text or using the model template
»