[Solved] SOLVED:Database for student solution

In this task, you are going to develop a database program to store information related to the students of a university. Information to be stored related to a student

Each student record in the database contains the following information.<table<tr<tdName</td </tr<tr<tdID</td <tr<tdCourse</td e.g. 1612 Master of Computer Studies (cannot be NULL)</td</tr<tr1. year (4 digits)</br2. session (one char A/S for autumn/ spring)</br3. code (7 characters)</br4. credit (2 digits, i.e., if the credit point is 6, it will be represented a 06)</br5. Mark (0 to 100 or e or w)</bre enrolled, w means withdraw</brYou may assume each student can be associated with at most 30 subjects</td</tr<tr<tdGPA</td</table

GPA is defined as:

Sum of {credit of all subjects multiplied by their scores} divided by Sum of {credits of all subjects}All subjects here means subjects that is not of the status e and w.

A sample data file (a plain text file) is given below to illustrate the format.

The ###START### and ###END### are used to mark the starting and ending of the file, while ###RECORD### is used to illustrate the starting of a new record.


Your database program supports the following commands (the should be shown in the first level menu)

**Main Menu**<table<tr<tr<tdq</td <tr<tdi</td // the function asks for a file name and import all records from the file</br// IF record with duplicated ID exists, your program should display the information of both records and ask the user to choose one</td</tr<tr<tde</td // the function asks for a file name and output all records to this file</br// IF the file already exists, your program should ask if the user would like to overwrite the file or cancel</td</tr<tr<tds</td

You can assume the maximum size of your database is 1000. The import function will take in the maximum allowable records, return to the main menu and display the number of imported records.

**Search Menu**

The following commands are supported in the search menu<table<tr<tr<tdr</td <tr<tdn</td the function asks for a name (support one single wild card *)</br* means everything, e.g. *n means any name that ends with the letter n and that A*n means any name that starts with A and ends with n</td</tr<tr<tds</td return a list of students taking the subject matching the search criteria</brpromote the user for year, session and code</brfor each input, the user can use the wild card *</td</tr<tr<tdg</td for =, any result within 1 point of the specified GPA is considered a match</brThat is, if the user want to search for students with GPA = 5.5, it will display all students whose GPA is from 4.5 to 6.5 (inclusive)</td</tr<tr<tdNOTES</td

**Display Menu**

The following commands are supported in the search menu

<table<tr<tr<tdr</td <tr<tds</td <tr<tdn</td <tr<tdp</td <tr<tde</td Upon completion, it shows the old and edited record and ask the user for confirmation.</brAfter that, it returns to the search menu.</brFor all options, if the user just press enter, it means keeping the existing value.</brIf the newly entered ID is not unique, it gives an error and ask the user to re-enter the value.</td</tr<tr<tdd</td Ask the user to confirm the deletion. If confirmed, it deletes the record and return to the main menu.</td</tr</table

**Addtional Menu**<table<tr<tdI</td<tr<tdE</tdrequirement is that it has to be compatible with the Import from a binary file function.</td</tr<tr<tdC</tdcourse name. Display the conflicting records and ask the user to choose one of thetwo options:</br– ignore</br– all records to one of these conflicting names</td</tr<tr<tdO</td fields: Name, ID and GPA</brRecords should always be displayed according to the sort key and order.</brDefault option is shown below:</brFirst Sort Key: ID , ascending</brSecond Sort Key: Name, ascending</brThird Sort Key: GPA, descending</br<iRemark: it means that records should be ordered according to the first sort key. Ifthey have the same first sort key, they are ordered according to the second sortkey… (For easy implementation, it is possible for the user to set all three sort key tothe same field)</i</brRecords should always display according to the setting in this menu.</td</tr</table

All commands are case sensitive. If the user enters an invalid input, your system shouldprompt the user to re-enter. You can assume the user will never enter anything longer than100 characters.