We explored the 2-primary steps to database design - conceptual design and physical design. We discussed importance of having representatives from all key stakeholders in conceptual design to ensure the accuracy of the design. We analyzed who should facilitate the conceptual design and create the ER diagram.

Next we discussed the physical design step, who is involved and what the outcome is..

As we wrap-up the week, who decides which employees will have access to data in a particular database? Why should the organization be careful when deciding who as read only access vs. read and update access to data?