Database design is a crucial phase during the database life cycle (DBLC).
John is the CEO of a company that produces large-scale online education
packages. The company has decided to start from scratch with a brand new database system. He has approached you to assist him specifically with the Conceptual Design. John has provided you access to their previous system and has set up interviews for you with multiple employees that use the system. John has also requested a visual representation of the data to help him get an overview. As a businessman, John must make important decisions based on reports generated by the system. A list of the required reports has been sent to you. John has also indicated that their data will be hosted across multiple sites due to the
large amounts of data that have to be stored.
Fully explain to John how you will approach the Conceptual Design stage.
Your answer must refer to the situation described above.
Step by step
Solved in 2 steps
