exam_1_problems_engelmanj

.docx

School

University Of Arizona *

*We aren’t endorsed by this school

Course

420

Subject

Mechanical Engineering

Date

Apr 3, 2024

Type

docx

Pages

4

Uploaded by BarristerHerringMaster551

Report
GIST 420 Exam 1 Section 2 Problem Sets Part 1 – Database Normalization arboretum ( noun, \ˌär-bə-ˈrē-təm\ ) -- a place where trees, shrubs, and herbaceous plants are cultivated for scientific and educational purposes A major university has established an arboretum on its campus for educational and research purposes. The arboretum committee has collected data on the plant specimens that are included in the arboretum. In order to manage the plant specimens within the arboretum, the committee has collected data on the plant specimens . These data include the individual plant specimen number, the genus and species of the plant, the value of the particular specimen, the origins of the species, and the forms that the species can occur in. This information has been placed in an un-normalized spreadsheet. A few rows of the spreadsheet are show below: Specimen# Genus Species Value Origin 1 Origin 2 Lifeform 1 Lifeform 2 1 Ligustrum lucidum outstanding China Japan tree shrub 2 Agave americana outstanding tropics succulent 3 Ficus cariaca heritage Mediter. tree 4 Lagerstroemia indica none Asia Australia tree shrub 5 Fouquieria columnaris heritage Mexico tree 6 Xylosma congestum none tropics tree shrub 7 Agave americana mutated tropics succulent 8 Ficus pumila none Asia Australia vine You will be decomposing this un-normalized relation into a series of normalized relations to be used in a relational database management system. To complete the following sections, consider the following assumptions about the data in the spreadsheet: Specimen# (specimen number) refers to an occurrence of an individual plant on the campus There may be more than one plant of a given taxon ( genus and species ) on campus, but each individual is a unique occurrence and receives a unique specimen#. (taxon = genus + species) There can be multiple species of one genus among the specimens Value refers to the primary type of special value (if any) of an individual plant specimen (not the taxon) Each individual specimen can have only one Value Origin1 and Origin2 refer to the historical distribution of the taxon in the world; some taxa have more than one distribution origin. Lifeform1 and Lifeform2 refers to the structure of the taxon; plants of these taxa would not have more than two lifeforms (succulent, vine, tree, shrub) There is no order or importance implied by the column names Origin1 and Origin2 There is no order or importance implied by the column names Lifeform1 and Lifeform2 There are more rows in the spreadsheet than are shown above Genus does not determine species Diagram the functional dependencies (9 pts) On the header below please indicate the functional dependencies in the arboretum spreadsheet. Draw arrows to the dependent attribute from the determining attribute, e.g. A B would indicate that B is functionally dependent on A. Specimen# Genus Species Value Origin 1 Origin 2 Lifeform 1 Lifeform 2 Joseph Engelman
GIST 420 Exam 1 Section 2 Problem Sets Circle the letter of the BEST normalized database scheme solution from the diagram sets below: (18 pts.) A) Specimens (Specimen# , Genus, Species, Value, Origin1, Origin2, Lifeform1, Lifeform2) B) Specimens (Specimen# , Genus, Species, Value) Lifeforms (Lifeform_ID, Genus, Species , Lifeform) Origins (Genus, Species, Origin ) C) Specimens (Specimen# , GS_ID) Taxon (GS_ID , Genus, Species, Value) Lifeforms ( GS_ID , Lifeform ) Origins (GS_ID, Origin ) D) Specimens (Specimen#, GS_ID, Value) Taxon (GS_ID , Genus, Species) Lifeforms (GS_ID, Lifeform ) Origins (GS_ID, Origin ) Joseph Engelman
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help