Case needs analysis determine the data requirements of

Question

1. 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?

2. 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.

Answer 1

This report discussed about Case Needs Analysis of Birchwood Lane schools data requirements and provided additional information which is required to complete requirement. This report proposed relational database model with all required entities & relationship mapping and logical database model based on the entities in the relational model. The relational and logical data model prepared in Ms access and report in Ms office and references are included as per APA format.

Answer 2

Please assess the case study and on the basis of the information provided, respond to the following in a detailed manner. 1) Case Needs Analysis: Find out the data requisites of the Birchwood Lane Schools. a) Illustrate what data from the scenario is required for the database and explain why? b) To what degree is additional information required to build up complete data requirements? 2) Relational Database Model a) On the basis of the requirements you have determined, suggest a relational database model. Ensure to comprise applicable entities and proper relationship mapping. b) Recommend a logical database model based on the entities represent in your visual conceptual database model.