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:

Plant species
genusspeciefamilycommonname
ArdesiajaponicaMyrsinaceaeMarlberry
BeaucarnearecurvataAgavaceaePonytail
CentaureacinerariaAsteraceaeDusty Miller
CentaureagymnocarpaAsteraceaeDusty Miller
CentaureamontanaAsteraceae
DracaenadracoAgavaceaeDragon Tree
DracaenamarginataAgavaceae
EcheveriaelegansCrassulaceaeHen and Chicks
KalanchoebeharensisCrassulaceaeFelt Plant
KalanchoepinnataCrassulaceaeAir Plant
PseudosasajaponicaPoaceaeArrow Bamboo
SeneciocinerariaAsteraceaeDusty Miller

• Draw the relation scheme for this table as it is shown above. Identify the primary key.

• Draw the relation scheme for a lossless join decomposition of this table.