I've made the ER model above. But am not sure how to go on to make a relational model from here.

Derive a Relational Model from the ER-model above. List all the relations derived from the entity types of the ERD, and their initial attributes.

2. For each relationship type in the ERD justify whether it leads to a new relation, a new attribute in a relation derived from an entity type, or to a merger of two relations derived from two entity types.

3. List all the relations in the final relational model, and all their attributes

4. List all the constraints included in the conceptual schema in addition to the relevant primary keys and foreign keys.

An example format is provided.

Deriving Entity types

RELATION (attribute, attribute, attribute)

RELATION (attribute, attribute, attribute)

Deriving Relationship types

RELATIONSHIP NAME was derived by adding RELATION with attribute and attribute as foreign keys to link with RELATION and RELATION because of MULTIPLICITY and/or PARENT/CHILD

RELATIONSHIP NAME was derived by merging RELATION and RELATION because of MULTIPLICITY and/or PARENT/CHILD

RELATIONSHIP NAME was derived by adding attribute to RELATION as a foreign key to link with RELATION because of MULTIPLICITY and/or PARENT/CHILD

Relational Model

RELATION (attribute, attribute, attribute)

RELATION (attribute, attribute, attribute)

RELATION (attribute, attribute, attribute)

RELATION (attribute, attribute, attribute)

RELATION (attribute, attribute, attribute)

Foreign Keys

Relation (attribute) is dependent on Relation (attribute).

Relation (attribute) is dependent on Relation (attribute).

Other Constraints

The X attribute of the Y relation can only be from 1000 to 9999.