Scenario:

You will be developing your submissions (a relational database model, and plan for implementation) around the following scenario: Birchwood Lane Schools currently records all student, instructor, and course data on paper. To meet state and federal requirements, Birchwood Lane Schools must implement an application system that records all student, course, and instructor data electronically. You will design a DBMS model and develop a strategy for implementation, which you will flesh out in a comprehensive written report.

Current data needs 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)

Questions:

II. 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:

A. What information should be included in the new database solution to address the current state? Why?

B. What additional information is needed to complete the business case data requirements and achieve the desired future state?