Databases: Entity Relationship Diagram

Databases: Entity Relationship Diagram

di Mario G Magno -
Numero di risposte: 9

Can anyone point me to an existing ERD for the moodle database? Thanks,

Mario

Media dei voti:  -
In riposta a Mario G Magno

Re: Databases: Entity Relationship Diagram

di Howard Miller -
Immagine Core developers Immagine Documentation writers Immagine Particularly helpful Moodlers Immagine Peer reviewers Immagine Plugin developers
I don't believe such a thing exists. I'd be interested to know why you want one?
In riposta a Howard Miller

Re: Databases: Entity Relationship Diagram

di Fohsap Muimi -

Who wouldn't want one? ;>

In riposta a Fohsap Muimi

Re: Databases: Entity Relationship Diagram

di Howard Miller -
Immagine Core developers Immagine Documentation writers Immagine Particularly helpful Moodlers Immagine Peer reviewers Immagine Plugin developers
Me!

Only computer science students think they are a good idea grande sorriso
In riposta a Howard Miller

Re: Databases: Entity Relationship Diagram

di Marcus Green -
Immagine Core developers Immagine Particularly helpful Moodlers Immagine Plugin developers Immagine Testers

Shirley you jest Howard, the ER diagram is second only to the flow chart as a diagram that illustrates things that need diagramming. I love them so much I have created a wide and varied assortment of both the entire Moodle (2.0) database and the various components and uploaded it as .png files to this here site. See the links pointing off

http://docs.moodle.org/en/Development:Database_schema_introduction

Particularly the big one at the bottom entitled

ER Diagram of the installed system

Note that the value may be impaired by the bits where the tables are not in a relational structure (e.g. multi valued fields), but it should be a whole bunch better than no diagram.

You will also see the fine work of Mr T. Hunt which are much nicer than mine.

p.s. IANACS

In riposta a Marcus Green

Re: Databases: Entity Relationship Diagram

di Howard Miller -
Immagine Core developers Immagine Documentation writers Immagine Particularly helpful Moodlers Immagine Peer reviewers Immagine Plugin developers
Well partly... I suspect we are (again) in the grips of somebody's programming assignment in this case.

I don't have any problem with proper documentation for stuff but I'm generally too lazy to learn what all the little symbols mean. UML diagrams are even worse. I'm generally just wary of mindless adherence to some methodology. Sorry - just an old rebel grande sorriso