Description

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

requirements?

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.