Databases: Entity Relationship Diagram

Databases: Entity Relationship Diagram

Mario G Magno - દ્વારા
Number of replies: 9

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

Mario

In reply to Mario G Magno

Re: Databases: Entity Relationship Diagram

Howard Miller - દ્વારા
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
I don't believe such a thing exists. I'd be interested to know why you want one?
In reply to Howard Miller

Re: Databases: Entity Relationship Diagram

Fohsap Muimi - દ્વારા
In reply to Fohsap Muimi

Re: Databases: Entity Relationship Diagram

Howard Miller - દ્વારા
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Me!

Only computer science students think they are a good idea big grin
In reply to Howard Miller

Re: Databases: Entity Relationship Diagram

Marcus Green - દ્વારા
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of 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 reply to Marcus Green

Re: Databases: Entity Relationship Diagram

Howard Miller - દ્વારા
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of 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 big grin
In reply to Howard Miller

Re: Databases: Entity Relationship Diagram

Marcus Green - દ્વારા
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

At least there is really only 1 type of ER diagram. UML has 14 different types.

http://en.wikipedia.org/wiki/Unified_Modeling_Language

I use my own Moodle ER diagrams to illustrate how complex "real" systems can get.

In reply to Howard Miller

Re: Databases: Entity Relationship Diagram

Fohsap Muimi - દ્વારા