Student Database Application

Scenario: You are a Database Administrator for a university and need to create an application to manage student enrollments and balance.

Your application should do the following:

  • Ask the user how many new students will be added to the database
  • The user should be prompted to enter the name and year for each student
  • The student should have a 5-digit unique ID, with the first number being their grade level
  • A student can enroll in the following courses:
History 101
Mathematics 101
English 101
Chemistry 101
Computer Science 101
  • Each course costs $600 to enroll
  • The student should be able to view their balance and pay the tuition
  • To see the status of the student, we should see their name, ID, courses enrolled, and balance
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.