Comments by Member 14999025 (Top 2 by date)

Member 14999025 21-Nov-20 18:42pm View

Thanks for the Answer Rick, the only issue is that the link seems faulty, could you send it again please? Thanks again.

Member 14999025 21-Nov-20 11:29am View

Thanks for the answer Gerry, what i was trying to explain with the "entity" and "attribute" was the structure of the tables i thought about for the scenario.

The bigger explanation you talk about could be the scenario that was given? If so, i was looking for a set of tables with their respective attributes such that:

Season is 20 weeks long, and each week is identified by a number.
Yachts are identified by their unique name and their length.
Different groups of people may book a boat for a week. Each group has at least two people (1 skipper, and at least 1 crew member), but the skipper could not be a skipper in a different week, whereas the crew could be in a several groups.
Each member needs to provide contact info, which are Name, Age and finally email.
Each group is entitled to some extras, which are identified by a unique name and a price.

I need to extract a set of entities and attributes in a tabular way, which i tried to represent using arrows, unfortunately not that effectively. Any advice on how to work from here?