Convert ERDs into relational models:

Be sure to convert each many-to-many relationship into a table.

Do not convert (0,1)-to-many relationship to a table. That is, do not convert optional 1-to-many relationships.

Note: The result of conversion is a collection of CREATE TABLE commands or simplified commands (Please show both ways for learning expirence)

1. Home HomelD Street City State Owner lp NoBedrms NoBaths SqFt OwnOccupied Commission SalesPrice SSN Name SpouseName Profession SpouseProfession -Owns Lists Office Agent AgentlD Name Phone OfficelD -WorksAtH-MgrName Phone Address 2. Part Contain:s Account Decomposed Acctid AcctName Balance PartNo PartDesc Color