Here it a example of using the system. A school-book-databases was chosen, so that all qualities of the system can be shown. The step consequence corresponds possibly to the production by real DB-applications. First a ER-diagram of the system is constructed and is illustrated in relational schema. Then this schema is converted with the help of reverse engineering colleges of technology into a XML-Repository.

Relational schema

Accepted a databases-schema with the help of ER-model design. This schema gets 5 Entities. Besides, is specialized office workers to assistant and professor. With appointment it is about a Weak-Entity. It is here the modeling the Aggregation (better composition) from sets-attribute of the object. There is also different take from relations. Examine a connection(affair) the degree 3 with own attribute is a mark(note).

This ER-diagram is converted to a relational schema.
Angestellte   {PersNr,Name}
Professor     {PersNr,Rang,Raum}
Assistent     {PersNr,Rang,Raum,Professor}
Student       {MatrNr,Name,Semester}
Vorlesung     {VorlesungNr,Titel,SWS,PersNr}
hoeren        {MatrNr,VorlesungNr}
voraussetzten {VorgaengerNr,NachfolgerNr}
pruefen       {MatrNr},VorlesungNr,PersNr,Note}
Termin        {VorlesungNr,Wochentag,Zeit}
FileUnibank.sql In the directory sample of the program contains the SQL-instructions for MySql databases for the creation of the databases. To put on the databases one must first University databases create.


The MySql databases have to be installed on your system. It runs and you have to put on corresponding rights the databases and tables.

[User@localhost] mysql mysql 
Attach from tables
>cat sample/unibank.sql | mysql-u username university