Home Work

Hi Everyone,
Ok this is my home work.. but i am not gona ask you guys to do it..

It is for the database class... I have modeled a Entity Relation Diagram (ER Diagram) for a given problem for which a database has to be created... I want to get the model right before i proceed to the next step.. i have created a model which i think is ok.. but i would like you guys to have a look and recommend any modifications which might improve the model.. or a better way of doing it..


thanx in advance
bye
Vasanth

Well your double ended relationships seem wrong (and confusing)

For example

Code:

---

+============+                  +============+
|            | 1              + |            |
|  Site    |-------------------| Grid Ref  |
|            |                  |            |
+============+                  +============+

---

A site is composed of many grid references
A grid reference belongs to one site

Depending on what your local conventions are on multiplicity, you might consider
{m,n} - between m and n
{m,} - at least m
{,n} - at most n
* - zero or more, same as {0,}
+ - one or more, same as {1,}


For me, I would remove Species_Ref_No from Site_record (a site record will contain many species, so it can't really be here), and remove SiteID from Site_Species_Record, and replace it with a Site_record (so you can easily get date and recorder).

So it would read
A Site has many Site Records
A Site Record has many Site Species Records

thanks... for the valuable response.. i am working on that now.. I think a grid reference can belong to more than one site since sites overlap..

any way will post the new model.. hope to get some review again..

thanks