1. represent each ENTITY as a TABLE
2. select the PRIMARY KEY
3. assign entity ATTRIBUTES to FIELDS
4. represent an ONE-TO-MANY relation by a FOREIGN KEY in the MANY table.
5. represent MANY-TO MANY relations as a NEW TABLE. Use FOREIGN KEYS to identify entities involved. The combination of foreign keys is the PRIMARY KEY of the new table. Assign the common attributes to fields.