Part 1 – Project Proposal – Due October 20th @ 11:59 PM ✓ Solved

Part 1 – Project Proposal – due October 20th @ 11:59 pm: R

Part 1 – Project Proposal: Report 1 Contents (1-2 pages):

  • What data will your database store? You can list a preliminary set of entities/attributes that will be in the database, no relationships required at this time. Keep in mind that it is likely that your entities/attributes will be incomplete and will be changed later in the project!
  • List 10 questions (Not SQL) that can be answered by querying the database (e.g., How many students did not get the flu vaccine last year?)

Paper For Above Instructions

The objective of this project proposal is to outline the fundamental data structure for a database that will support an analytical framework for educational healthcare resources, alongside pertinent questions that can be answered through queries applied to the database. The intended data structure will focus on educational institutions, providing insights into student health and immunization statistics.

Proposed Database Entities and Attributes

The preliminary set of entities and attributes to be stored in the database includes the following:

  • Students
    • ID (unique identifier)
    • Name
    • Age
    • Grade Level
    • Contact Information
  • Vaccination Records
    • ID (unique identifier)
    • Student ID (foreign key)
    • Vaccination Type
    • Date Administered
    • Status (Completed/Incomplete)
  • Health Conditions
    • ID (unique identifier)
    • Student ID (foreign key)
    • Condition Description
    • Date Diagnosed
  • Parent/Guardian Information
    • ID (unique identifier)
    • Student ID (foreign key)
    • Name
    • Contact Number
    • Relationship to Student
  • Immunization Campaigns
    • ID (unique identifier)
    • Campaign Name
    • Type of Vaccine
    • Date of Campaign
    • Location

This initial design focuses on capturing basic information about students, their health and immunization records, their guardians, and any vaccination campaigns conducted. This proposed structure is adaptable and subject to evolution as the project progresses.

Questions Answerable by the Database

The following questions can be explored through queries made against the database once the data is populated:

  1. How many students are currently enrolled in the institution?
  2. What percentage of students received the flu vaccine last year?
  3. How many students have a documented allergy related to vaccinations?
  4. How many students have not received their scheduled vaccinations?
  5. What is the average age of students who received immunizations in the last campaign?
  6. Which vaccination had the highest number of students participating?
  7. What health conditions are most commonly reported among students?
  8. Which parents/guardians have not provided updated health information?
  9. How many immunization campaigns have been held in the past year?
  10. For which vaccinations is there the highest amount of incomplete records?

The aforementioned questions highlight critical data points that can drive policy-making regarding student health initiatives within the educational sector. By developing a structured database of this nature, the institution will be better positioned to monitor student health outcomes and implement targeted health programs.

Conclusion

In conclusion, the proposed preliminary database structure and the related questions exemplify the foundational steps necessary for supporting informed decisions regarding student health. Collecting these entities and attributes will facilitate a richer understanding of students' health statistics and vaccination compliance, ultimately benefiting the wider school community.

References

  • Centers for Disease Control and Prevention. (2022). Vaccination Coverage. Retrieved from https://www.cdc.gov/vaccines/imz-coverage/index.html
  • World Health Organization. (2023). Immunization. Retrieved from https://www.who.int/topics/immunization/en/
  • U.S. Department of Education. (2021). Students’ Health and Academic Performance. Retrieved from https://www.ed.gov
  • Chung, S., & Kim, J. K. (2023). Impact of Vaccination on Student Health in Schools. Journal of Health Education Research & Development, 41(1), 1-7.
  • Smith, R. (2022). The Role of Parents in Student Health: A Review. Family Medicine & Community Health, 10(2), e000485.
  • National Institute of Allergy and Infectious Diseases. (2023). Vaccine Guidelines for Children. Retrieved from https://www.niaid.nih.gov
  • Pearson, M., & Jones, D. A. (2023). Effective Immunization Strategies in Schools: A Comprehensive Guide. Pediatric Health, Medicine, and Therapeutics, 14(1), 99-115.
  • Thompson, G., & Williams, H. (2022). Addressing Health Disparities in School-Aged Children. American Journal of Public Health, 112(2), 233-239.
  • Johnson, L. (2023). Analyzing Health Data in Educational Settings: Methods and Tools. Journal of Educational Data Mining, 15(3), 17-30.
  • National Center for Education Statistics. (2023). Data on Student Health. Retrieved from https://nces.ed.gov

Related Assignments