Exercise: plant species
You are working on a database for a company that grows and sells plants. One important table contains a list of the plant species that they grow, which are identified botanically by their genus and specie name, family, and common name. Even if you have never heard of these terms, you can analyze the table by looking at the data given below:
| Ardesia | japonica | Myrsinaceae | Marlberry |
| Beaucarnea | recurvata | Agavaceae | Ponytail |
| Centaurea | cineraria | Asteraceae | Dusty Miller |
| Centaurea | gymnocarpa | Asteraceae | Dusty Miller |
| Centaurea | montana | Asteraceae | |
| Dracaena | draco | Agavaceae | Dragon Tree |
| Dracaena | marginata | Agavaceae | |
| Echeveria | elegans | Crassulaceae | Hen and Chicks |
| Kalanchoe | beharensis | Crassulaceae | Felt Plant |
| Kalanchoe | pinnata | Crassulaceae | Air Plant |
| Pseudosasa | japonica | Poaceae | Arrow Bamboo |
| Senecio | cineraria | Asteraceae | Dusty Miller |
- Draw the relation scheme for this table as it is shown above. Identify the primary key and any functional dependencies. Follow the example Contacts relation scheme to denote the FDs.
- Apply the process to remove redundancy due to subkeys and draw the relation scheme that results from this process. Be sure that the result has the lossless join property.
