Need help with 2 database questions. Thank you! Scenario: You will be developing
ID: 356904 • Letter: N
Question
Need help with 2 database questions. Thank you!
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?
Explanation / Answer
Answer:
Information should be included in the new database solution to address the current state: The following information should be added in the new database so hat the database looks good to have right kind of information which will be useful for its concern people and officers who use to get this information along with a good database for the school usage as well.
All these information is useful to add in the database, so that the database looks complete and people can visit the site and database to use the data for their general use. The addition is important because this will create ease of doing work in the school, environment by helping to get quick and correct data for the people.
Additional information is needed to complete the business case data requirements and achieve the desired future state:
Following additional data and information needed are as below