Discuss the below:
We explored the two primary steps to database design - conceptual design and physical design. We discussed the importance of having representatives from all key stakeholders in the conceptual design to ensure the accuracy of the design. We analyzed who should facilitate the conceptual design and create the ER diagram.
Q1: Discuss the physical design step, who is involved and what the outcome is.
Q2: 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?