ER Modeling II - Q6

ORCHARD (OrchardID, Location, …)

SPECIES (SpeciesID, Name, OrchardID…)

DISEASE (DiseaseID, Symptoms, Treatment,…)

SPECIES_DISEASE (SpeciesDiseaseID, SpeciesID, DiseaseID, Date,…)*

CUSTOMER (CustomerID, …)

ORDER (OrderID, CustomerID, …)

ORDERDETAILS (OrderID, DetailID, SpeciesID,…)

All foreign keys not null.

* Optionally, use the combination of SpeciesID, DiseaseID and Date as primary key and remove SpeciesDiseaseID entirely.

Previous slide

Next slide

Back to first slide

View graphic version