Prompt You will be developing your project and its critical elements based on the following scenario Birchwood Lane Schools currently records Schools must implement an application system that records all student, instructor, and course data electronically ll student, instructor, and course data on paper. To meet state and federal requirements, Birchwood Lane You will design a relational database and develop a strategy for implementation, which you will fully document in a compr Current data requirements include the following 1. Student data (full name, full address, phone, email, birthdate, enrollment date, graduation date, courses taken, courses currently enrolled) 2. Instructor data (full name, full address, phone, email, birthdate, hire date, courses taught, courses currently assigned) 3. Course data (course name, course start date, course end date, course category, instructor, students) Each student and instructor may have multiple addresses and may be enrolled in multiple courses during a term. Each instructor may teach multiple courses during a term. Specifically, the following critical elements must be addressed in your submission: 1 Introduction: Based on the given scenario you were provided A. Summarize the data and information requirements of the business case and client needs using appropriate data and information management terminology B. Briefly explain the purpose of the database management system (DBMS) used and the importance of a database in meeting the requirements. 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 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? A. IlI. Relational Database Model: Based on the scenario and the information from your introduction and your analysis: A. Design a basic relational database visual diagram with entities, attributes, and relationships based on the requirements you have identified. Be B. Create a conceptual data model visual diagram and a logical data model visual diagram based on the entities present in your visual conceptual hwood Lane Schools sure to include proper relationship mapping. database Database Selection: Select an appropriate DBMS (Note: Refer to Milestone Four to help you with this area) to recommend for Birc Oracle, IBM DB2, MS sQL Server, or an open-source database) and explain IV. A. Why did you choose this DBMS? Be sure to lists all uses, benefits, and limitations for each of the following: data size limits, purchase cost, administration, operating system/hardware requirements, features, and performance/scalability