Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

St. Marys Academy is one of the two Schools in St. Kitts that offers high and elementary schools education. It was established in 1812 by

St. Marys Academy is one of the two Schools in St. Kitts that offers high and elementary schools education. It was established in 1812 by nuns from England and Canada who came to St. Kitts to work at the church. They established this school because they saw the need for a catholic education. Now 200 years later St. Marys High School has over 600 students and about 40 staff. The current principal of the school is Dr. Austin Bridgewater and the vice principal is Mrs. Lauren Anderson. In 2009, a fire broke out in the old wooden building where many records and important files about students and staff were lost. Unfortunately St. Marys High School still uses the traditional filing method, so after the fire and the building were restored many files were mixed up. Many of the teachers were not being pain on time as a result they went on strike. Dr. Austin Bridgwater is requesting that an electronic system could be made so that not only there is a proper way of storing student and staff information but to organise their school store so to prevent a shortage and causing another crisis. Write a program using C, to create a datebase for the school. Program should be able to do the following: Write, read and edit file for Student's Information. (Name, Date of Birth, Age, Address, Class) Write, read and edit file for Teacher's Information. (Name, Date of Birth, Age, Address, Class, Trained/Untrained, ) Write, read and edit file for other staff Write, read and edit Equipment Inventory) (Serial Number, Name, Number of) Checking out the number of Equipment available, and alert the user it there is a shortage. Looking for a name of Students or Teachers. Calculate Teacher's Pay (including 3.5% Social Security and 3% Social Level Deductions) Student Report Card (example Below) First Name: Djavan Middle Name: Kayode Last Name: Martin Date of Birth: 11 August 2006 Age: 16 Class: Grade 11 Grades: Mathematics Informartin Technology Science Social Studies English Spanish 86% 100% 92% 100% 98% 88% This table is to calculate the grades of the students. 1. If grades are 95% and above then a A+ is given 2. If grades are between 90% and 95% then a A- is given 3. If grades are between 85% and 90% then a A is given 4. If grades are between 80% and 85% then a B+ is given 5. If grades are between 75% and 80% then a B- is given 6. If grades are between 70% and 75% then a B is given 7. If grades are between 65% and 70% then a C+ is given 8. If grades are between 60% and 65% then a C- is given 9. If grades are between 55% and 60% then a C is given 10. If grades are between 55% and 50% then a D is given 11. If grades are below 50% then a F is given 12. Calculate GPA Requirements for Teacher Salary 1. If qualifications is trained graduate, then the basic hourly pay is $40 2. Gross salary = basic hourly pay * hours of day * days of the week * week of the month 3. Social Security = 5% of gross salary 4. Social Levi = 3.5% of gross salary 5. Deduction = Social Security + Social Levi 6. Net Salary = Gross Salary Deductions 7. If qualifications is graduate, then the basic hourly pay is $30 8. Gross salary = basic hourly pay * hours of day * days of the week * week of the month 9. Social Security = 5% of gross salary 10. Social Levi = 3.5% of gross salary 11. Deduction = Social Security + Social Levi 12. Net Salary = Gross Salary Deductions 13. If qualifications is trained, then the basic hourly pay is $25 14. Gross salary = basic hourly pay * hours of day * days of the week * week of the month 15. Social Security = 5% of gross salary 16. Social Levi = 3.5% of gross salary 17. Deduction = Social Security + Social Levi 18. Net Salary = Gross Salary Deductions 19. If qualifications is substitute or untrained, then the basic hourly pay is $25 20. Gross salary = basic hourly pay * hours of day * days of the week * week of the month 21. Social Security = 5% of gross salary 22. Social Levi = 3.5% of gross salary 23. Deduction = Social Security + Social Levi 24. Net Salary = Gross Salary Deductions Must have a main menu (Including an exit number and an option to go back to main main from any report)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

5. To determine the financial benefits and costs of the program.

Answered: 1 week ago