Question: Using Visual studio 2 0 2 2 C# ASP.NET core web app give me a very detailed step by step to do the following I

Using Visual studio 2022 C# ASP.NET core web app give me a very detailed step by step to do the following I need to know how to do everything like I know absolutely nothing
For this project, create a Web-based ASP.NET Application.
This application will be used by a high school to keep track of teachers, students, and student exam scores.
You must create a user interface that allows a user to view, insert, update, and delete data from the following tables: the database is called school.db
I need the code for the models how to set up the views and scaffolding controllers everything step by step with code for everything
Teacher
Student
Exam
The teacher table has the following columns:
TeacherId (int)
FirstName (string)
LastName (string)
The student table has the following columns:
StudentId (int)
FirstName (string)
LastName (string)
The exam table has the following columns:
ExamId (int)
StudentId (int)
Score (int)
Access the SQLite database that contains these tables (opens in a new tab)ZIP compressed file. You will notice there is no data included in the tables. After you design your application, enter at least 5 teachers, 5 students, and 10 exam scores into the database using your user interface. This is an excellent opportunity to test your application.
The database is set up to automatically increment the ID columns (e.g., TeacherId, StudentId, and ExamId), so you don't need to worry about adding these values when inserting new records.
You must use the program design skills you have learned in this course. So you know what is expected, review the rubric for more information.
You must use the user interface principles that you learned in this course. Make sure that your application looks good and is easy for users to use (review the rubric for more information on this). Make sure to validate the exam scores that users enter (use range checks).
Lastly, create a Report page that displays the total number of letter grades by type (A, B, C, D, and F). If 10 exams are entered in the database, then the total number of letter grades in the report is 10(Tip: A simple way to generate this report is to use the same method that you created to retrieve all data from the exam table). Create an MVC model that you pass to the report page. You can create this report in any format that you would like (e.g., table or chart).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!