In this lab, you will start designing the database for the system that you have chosen and wrote a SCOPE/Requirements Document.

Lab Steps

1. Define the entities of your system, given the system requirements that you have specified in the SCOPE document.
2. Define the attributes for each entity.
3. Define the relations between the different entities.
4. Draw an ER diagram to show your database design.
5. Put the output of steps 1 to 4 in a Word document. You can also use a PowerPoint presentation instead if you find it easier to draw the ER diagram using PowerPoint shapes

Hello, if possible could you help me with just #4? Im having trouble starting the ER diagram. my topic is watermelons with its entities being

Seedless watermelons

1. Seeded watermelons
2. Miniature Watermelon
3. 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