design the database using the given fields and criteria
Create an Android app that will be used to enter student grades for college courses.
Develop three screens as follows:
• The first screen should allow the entry of a student id, first name, last name, class id, and class name.
• The second screen should allow the entry of a grade for each student and class that they took. The grade entry will be a number which can range from 0 – 100.
• The third screen should show the student name and overall letter grade for the semester based on the classes that they took. Note: Use the grade conversion table below:
Points Grade
100-90 A
80-89 B
70-88 C
60-69 D
Below 60 F
Use the sample students and grades below:
Student ID Student Name Class ID Class Name Grade
1 Sally Smith 100 Biology 70
1 Sally Smith 110 Gym 90
2 Mark Front 120 English 40
2 Mark Front 110 Gym 10
3 Rick Hart 130 Science 85
3 Rick Hart 100 Biology 90
3 ick Hart 110 Gym 45
4 Justin Jones 140 Computers 45
4 Justin Jones 120 English 70
Design the database using the following fields and criteria:
StudentID VARCHAR(8),
FirstName varchar(20),
Lastname varchar(20),
ClassID varchar(20),
Grade Integer(3),
Lettergrade Varchar(2)
