Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data Concepts, Theories, And Applications

Authors: Shui Yu, Song Guo

1st Edition

3319277634, 9783319277639

More Books

Students also viewed these Databases questions

Question

What is electric dipole explain with example

Answered: 1 week ago

Question

What is polarization? Describe it with examples.

Answered: 1 week ago

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago