1. Use MySQL or other DBMS to create a table named performances with fields: id, hour process_id, unit_id, qty In this table, the id is the autoincrement; the hour is for unix hour, i.e., unix seconds / 3600, so every unique hour with some activity in your life can be tracked. The process_id is the id of the process to be tracked, and shown as a text. The unit_id is the id for the units used, and also shown as a text.

In order to show the records of these two fields as a text, we need 2 tables: processes and units, however, in order to know the units defined for each process, we need a mapping process_unit table, which allowed us to map process names with their units.

2. Create tables: processes, units, and process_unit.



Ad blocker interference detected!

Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.