Reference no: EM131376848
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.
|
Compute the companys income for the month of september
: Rank the company's fiscal quarters from most profitable to least profitable. Compute the company's income for the month of September. Compute the company's net income (or loss) for the first two months of third quarter.
|
|
Challenges of accurate data analysis
: Discuss the challenges of accurate data analysis upon accurate data modeling. Why would you want to use structured query language (SQL) for database design? What would be the benefits of using SQL to create and manipulate the data in the database?..
|
|
What are some of the current social factors that keep adult
: Scholars have identified many personal factors that might prevent a young adult from achieving individuation from his or her family. What are some of the current social or economic factors that might keep a young adult from achieving individuati..
|
|
Categorize the different dimensions ranking them from 1 to 5
: As a team, categorize the different dimensions ranking them from 1 to 5, with 1 indicating that the dimension offers the highest value and must be in your data mart and 5 indicating that the dimension offers the lowest value and does not need to b..
|
|
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..
|
|
How do the impact capacities of the new and old bars compare
: Assuming that stress concentration can be neglected (not very realistic), how do the impact capacities of the new and old bars compare?
|
|
Explain how netflix might use databases
: Explain how Netflix might use databases, data warehouses, and data marts to predict customer movie recommendations. Here are a few characteristics you might want to analyze to get you started:
|
|
Personal experience with a mobile device
: Everyone approaches technology with preconceptions based on experience. For example, if reading a magazine article on a hand-held device strains the eyes, users are instead likely to use a personal computer for the purpose.
|
|
How does impact loading differ from static loading
: Impact loads may be torsional and/or linear in nature. How does impact loading differ from static loading?
|