need help can somebody help me with this what would the answer be

my digram is about basketball keeping the teams organize their teams roster, coaches, and games

help please

Our second part is designing the database. All you need to do for this part is to provide an ER

model for your database and then convert it into relations (tables).

Draw an ER diagram using DIA: This ER diagram should reflect the proposal you have submitted. You should start with the same relations you described in your proposal, and then add (or modify) more entities if required. You need to identify the entities, their attributes and how those are related (relationships). For this project, you are only allowed to use Chen Notation. Model the entities, attributes, and relationships. Find if few of these entities are weak. Is there any class hierarchy in your ER diagram? If yes, model those as is-a relations. Provide the cardinality, total participation, and (min, max) constraint for each entity (for each relation). Write your assumptions. Save the ER diagram. We will use it later for further tuning. (12 pts)

Convert your ER diagram into relations: Once the ER diagram is ready, you need to convert the ER model into relations. Your report should have the following components:

2.1. A list of relations and their attributes (10 pts)

Indicate the primary key and foreign keys (if any) for each relation. Justify your choice.

Write the detailed description of each attribute (for each table), its purpose and datatype.

Indicate each attributes default value (if any) or if the attribute can be set to null.

Explain the actions taken on any foreign key when the primary key (that the foreign

key refers to) is deleted (For example: no action, delete cascade, set null, set default). 2.2. A mapping from the ER diagram to the Relations. (6 pts)

For each relation (table), provide the correspondence between the relation and the entity and/or relationship in the ER diagram that the relation is derived from. Justify your decision.