▲ | reactordev 4 days ago | |
>Note also that the order of columns matters! We need to clearly understand which ID is the manager and which ID is the team member. If it were true 6NF than no, you don’t need to order, you need to make sure your naming conventions are on point. `id` is good. `manager_id` is good. `parent_id` a little less so but still practical when abstracting away the business vernacular from the logical problem. Other than that, everything was good. Attributes vs links trip up even the most seasoned devs. If you have a grouping of 3 or more attributes that relate, consider making it a link and splitting it off into its own table, normalizing your data further. |