Business Case and Gap Analysis: Analyze the client needs and how the project will address them. This type of analysis identifies the difference between a current condition and future state $($i$.$e$.,$ gap analysis$).$ Based on the scenario showing the current system that the school has in place to collect data:

What information should be included in the new database solution to address the current state? Why?What additional information is needed to complete the business case data requirements and achieve the desired future state?

Relational Database Model: Based on the scenario and the information from your introduction and your analysis:

Design a basic relational database visual diagram with entities, attributes, and relationships based on the requirements you have identified. Be sure to include proper relationship mapping.Create a conceptual data model visual diagram and a logical data model visual diagram based on the entities present in your visual conceptual database.