In this lab, you will design an Enhanced Entity Relationship (EER) diagram to improve on the database design that you have worked on in the previous weeks.

The new design will include additional improvements such as:

1. Inheritance Relationships
2. Constraints
3. Union Type

Topic of Database: Watermelons

Users of system: Any person or customer consuming / purchasing watermelons

4 requirements:

1. Seedless watermelons
2. Seeded watermelons
3. Miniature Watermelon
4. Orange / Yellow Watermelon

First entity: Seedless Watermelons

• 15 pounds Seedless watermelons average around the 15 pound mark
• White seeds Contains edible white seeds
• Potassium and Iron- Contains potassium and iron
• Red, Yellow, or orange flesh Seedless may have red, yellow, or orange flesh

Second entity: Seeded Watermelons

• 5-40 pounds Seeded watermelons can grow up to a max of 40 pounds
• Black seeds Contains larger black seeds that are not edible
• Minerals, Vitamins, proteins Seeded watermelons contain more minerals, vitamins and protein than others, given the seeds nutritional value

Third entity: Miniature Watermelons

• Thin Rind Mini watermelons have a thinner rind which is the green outside layer of the watermelon
• Small size Usually smaller in overall size and weight then the average type of watermelon

Fourth entity: Orange / Yellow watermelons

• Lack of lycopene Yellow and orange watermelons lack lycophene unlike red watermelons
• Black and White seeds Contains both black and white seeds
• Sweet Honey taste Yellow / orange watermelons tend to have some honey lingering within