Database class

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 with 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