Question: EXERCISE #1: E-R DESIGN Design a database for paleontology research community. The community wants to store data about fossils preserved in museums. Fossils are characterized

 EXERCISE #1: E-R DESIGN Design a database for paleontology research community.

The community wants to store data about fossils preserved in museums. Fossils

are characterized by: the year of the finding, the name of the

EXERCISE #1: E-R DESIGN Design a database for paleontology research community. The community wants to store data about fossils preserved in museums. Fossils are characterized by: the year of the finding, the name of the researcher that found the fossil, the museum and room in which it is kept. - Each fossil can be associated with multiple species, with a degree of confidence/probability. Each species can be described witlh multiple names (researchers may disagree: use different names for the same species, or use the same name for different species): in such case, the official name is the oldest. - Each museum is characterized by rooms, researchers affiliated with it, and a director. The latter can be a paleontologist or a researcher of some other area) - The E-R schema must include cardinalities for relationships, and attributes (where applicable), and identifiers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!