er图转换成关系模型的例题,将ER图转换为关系模型

I know how to convert an entity set, relationship, etc. into the relational model but what i wonder is that what should we do when an entire diagram is given? How do we convert it? Do we create a separate table for each relationship, and for each entity set? For example, if we are given the following ER diagram:

My solution to this is like the following:

//this part includes the purchaser relationship and policies entity set

CREATE TABLE Policies (

policyid INTEGER,

cost REAL,

ssn CHAR(11) NOT NULL,

PRIMARY KEY (policyid).

FOREIGN KEY (ssn) REFERENCES Employees,

ON DELETE CASCADE)

//this part includes the dependents weak entity set and beneficiary relationship