Other examples

In the directory sample are two other examples too.

  1. An example from publication: Roger H.L.Chiang; Terence M.Barron; Veda C.Storey. Reverse engineering of relational databases: Extraction of in EER model from a relational database. Data and Knowledge engineering 12. Elsevier. in 1994. Pages 107-142. Under the nameBussines . It is a databases schema of a hypothetical firm. There are the following files.

    Business-ER.dia ER-diagram of the databases in format of a GNOME of program DIA
    Bussines-er.eps ER-diagram as a PostScript file
    Bussines.sql create tables Sql-instructions for mySQL database
    Bussines.xmldbschema Repository of the schema
    Bussines.xmlforms Forms

  2. An example of a course-databases. It is offered different course-types. The realization of a course (entity Kurs) is named offer (with date) (entity Angebot). The courses are structured hierarchically. Untertypes A1 A2 A3 belong also to course type A, etc. . To every course a predecessor (can be named vice versa(conversely) successor). Z. B the participation in the course B sets in front the earlier participation in the course to A (B is deepening A).

    Course-er.dia ER-diagram of the databases in format of a GNOME of program DIA
    Course-er.eps ER-diagram as a PostScript file
    Kurs.sql create tables Sql-instructions for mySQL database
    Kurs.xmldbschema Repository of the schema
    Kurs.xmlforms Forms