Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started