The basis for the data requirements and database:
When designing the database management, I would assign the Principal or Assistant Principal the ability
to access and modify all aspects of the database. The rest of the faculty would have areas that they
could add information pertaining to their individual classes that would allow them to keep a list of all
students’ information. The teachers could have a list of all parents’ phone numbers, email addresses,
etc. that would allow them to easily get in contact with parents as needed. Each teacher would only
have access to view information for the students that they have, that way teachers aren’t sharing
information with the entire school. They would be able to input grades and keep track of what areas of
the curriculum seem to give students difficulty so that they could adjust the teaching to focus on the
more difficult areas. The students would also have access to the system but their access would only be
limited to viewing grades the teachers have submitted and also materials that each teacher would
require for their class. The students could also view upcoming assignments ahead of time to help
prepare them if they would need extra help.
In this task, you will complete and submit an individual proposal. In your proposal, you should include
the first two elements of your final project: a case needs analysis and a relational database model.
Use what you have discussed in your collaborative groups to finalize your proposal. This will be
graded with the Milestone Three Rubric.
Specifically, the following critical elements must be addressed in your submission:
I. Case Needs Analysis: Determine the data requirements of Birchwood Lane Schools.
a. What data from the scenario is needed for the database and why?
b. To what extent is additional information needed to develop complete data
II. Relational Database Model
a. Based on the requirements you have determined, propose a relational database model.
Be sure to include applicable entities and proper relationship mapping.
b. Propose a logical database model based on the entities present in your visual
conceptual database model.
Guidelines for Submission: The proposal should follow these formatting guidelines: double spacing, 12-
point Time New Roman font, 1-inch margins, and discipline-appropriate citations (if required). The
proposal should be 2 to 3 pages in length.