Other examples
In the directory sample are two other examples too.
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 |
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 |