SQL Question:

The question requires an ER design, a conversion from an ER schema to a relational schema, and the sql code to create a database from the information.

EXERCISE # 1: E-R DESIGN - Design a database for paleontology research community. The community wants to store data about fossils prese museums. Fossils are characterized by the year of the name of the researcher that found the'fossil, the museum and room in which it is kept. rved in the -Each fossil can be associated with multiple s with a of confidence/probability. Each species can be described wi 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 EXERCISE # 1: NOTES - Findings e naming are made by paleontologists - Two species cannot have the same official name, even if the same name can be given to multiple species LOGICAL DESIGN - Design the logical schema for all previous exercises - Phases . E-R restructuring - Comversion to relational model: from restructured E-R schema to relational schema DATABASE SCHEMA - Provide the DDL for each of the logical schemas previously designed EXERCISE # 1: E-R DESIGN - Design a database for paleontology research community. The community wants to store data about fossils prese museums. Fossils are characterized by the year of the name of the researcher that found the'fossil, the museum and room in which it is kept. rved in the -Each fossil can be associated with multiple s with a of confidence/probability. Each species can be described wi 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 EXERCISE # 1: NOTES - Findings e naming are made by paleontologists - Two species cannot have the same official name, even if the same name can be given to multiple species LOGICAL DESIGN - Design the logical schema for all previous exercises - Phases . E-R restructuring - Comversion to relational model: from restructured E-R schema to relational schema DATABASE SCHEMA - Provide the DDL for each of the logical schemas previously designed