Data Dictonary (Functional Design)

[jan]

Referring to an older post, here: http://php.brickhost.com/forums/index.php?topic=3763.0

Hi nick and all,

Yes, a data dictionary showing relations between the tables would be helpfull, someone has a document like this?

Currently i am (before programming anything) making a Functional Design of the needs of a large school. It has:
- more then one schedule,
- every schedule has its own Admin and own resources.
- A schedule-admin sees only it's own resources.
- Only admins make reservations (for students).
- resources must be in grouped (example: recording devices, display devices)
- One reservation can contain more then one resource (cannot be solved with accessoiries)

Anyone has made similar revisions/implemetations? Is there a way to share or work together?

regards, jan

[jan]

Here it is: DB relationships between the tables (partial). First how it is now in schedule-it 1.2, and secondly in the same doc the implementation we want. Is it correct? Can you advise on how to do our version? Starting with more then one database would that be a good option? Or more recoding. Thanks in advance for some advise! regards, Jan
http://www.larka.nl/schedultitDOC/DB-schema-UK.pdf

[Nick]

Looks like it should work.  Will you just have a many-to-many between reservations and resources?  This change will ripple through much of the code since there are a lot of assumptions that a reservation is only for a single resource.

Starting with a new database isn't a bad option.  That makes it easy to compare the changes or roll something back.