create a console-based gradebook that allows a professor to input GPAG for students in different courses using Entity Framework Core.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Your task is to create a console-based gradebook that allows a professor to input GPAG for students in different courses using Entity Framework Core. Write an Entity Framework Core console app that models the following business rules:

1. A student can enroll in many classes.

2. Each course can have many students enrolled in it.

Student

PK

Fina LastName

Course

PK Could

Course

NOTE: This ERD lacks the foreign keys and navigation properties. You must make it implementable in your code and add any additional properties as required by the features listed below.

Requirements

1. Use a SQLite database and store student and course data persistently. Add a property to store each student's GPA in each specific course.

2. Seed the database with at least 2 courses and 4 students. Enroll each student into one or more courses so that each course has at least 2 students. These can be hard coded.

3. Allow the user to LIST all the courses allong with students and their GPA in each course. List the students underneath each course along with their GPA.

Within each course, sort the students by GPA from highest to lowest

4. Allow the user to UPDATE the GPA for each student in a specific course. Ensure that the inputted GPA is between 0.0 and 4.0.

5. Handle all invalid input without crashing including invalid students and courses.

6. Extra Credit: Allow the user to DROP a student from a course. The student should still exist in the database but

won't be associated with that course anymore.

7. Remember to comment your code.

Your app should implement the above requirements in a separate class for LIST, UPDATE, and DROP similar to Homework 2 and Homework 4 using a separate class and methods within that class. Those features should be available to the user through a text interface menu.

This exam is meant to be completed INDIVIDUALLY. Cheating or copying on this exam will result in a ZERO for the exam and at the professor's discretion, a zero for the entire course. Notes are allowed

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of