Learning Projects: 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