Answer
See the explanation
Work Step by Step
To design a relational database for fruits, colors, and the season of their availability, we can create three tables: `fruits`, `colors`, and `availability`. Here's a basic outline of how these tables could be structured:
1. `fruits` table:
- Columns: fruit_id (Primary Key), fruit_name
2. `colors` table:
- Columns: color_id (Primary Key), color_name
3. `availability` table:
- Columns: availability_id (Primary Key), fruit_id (Foreign Key referencing `fruits` table), color_id (Foreign Key referencing `colors` table), season
In this schema, the `fruits` table stores information about fruits, the `colors` table stores information about colors, and the `availability` table links fruits with their available colors and the season they are available in.
This schema avoids redundancies by keeping each type of information in a separate table and using foreign keys to establish relationships between them.
