Show the count of the class after deleting

Assignment Help Database Management System
Reference no: EM13335314

In this project, you are to implement a database.  The database shows the students registered in COSC 333.  The database will only include the student's first name, last name, ID, GPA, and phone number.   The student's information is listed below.

You will save all the information below in an input file called "COSC333".

You will read from the file to perform the operations listed below.

 

First Name   Last Name            ID                      GPA                      Phone

James           Smith               50346               3.4                   301 234 5608

Amanda        George               53246              3.8                   471 222 4567

Lucy            Williams             56782              2.6                   301 213 7754

Adam           Howard              54327              2.8                   301 339 5577

George         Brown                57021              3.5                   301 854 9921

Willy           Gates                  52178             3.9                   571 754 8123

Ashley        James                  54108             3.8                   301 891 2314

Dan            Edwards               55321              3.6                   410 643 9104

David         Sammy                 57632              3.9                   410 449 3267

Racheal      John                      56012              1.8                   301 981 1205

Brandon     Jackson                 53786              3.9                   301 912 3305

Dina           Lowe                    51976              3.7                   301 832 1750

Brad          Green                    51742              1.8                   410 772 1032

Kevin        Day                        52876              3.8                   571 880 3123

Katty        Hill                         53906              3.5                   301 991 6549

Philips     Bush                        53316              1.7                   301 871 0921

Hellen     Edwards                  53987              3.9                   410 110 1099

Heidi       Abraham                 58132              3.8                   301 330 1212

Brandon      Lowe                   56196              3.4                   301 661 9910

Tiffany        Green                  51901              2.8                   410 221 9966

Edward        Smith                  54901              1.7                   301 334 0675

 

Display a Menu, so the user would be able to select any of the following operations:

CreateClassList

Insert

Delete 

Sort

Search

Update

HonorStudents

WarnStudents

Print

Update

Quit

Your program should include all the following functions:

CreateClassList: To read the student's information from the input file and  place all student's names along with their information  in a linked list, in alphabetically order, by last name. Call the print function  after you create the list.

Insert: Will insert any first name, last name, ID, GPA, and phone number, in the proper location in the list sorted alphabetically by last name.  After insertion, you should show the count of the class.  Then print the list after you insert

Delete:  You should be able to delete the student's record, once you enter student's first name followed by last name, or by using the student's ID.  If the student is not registered in the class, a message should appear indicating that the student is not registered.  Show the count of the class after deleting.  Then print the list after you delete.

Sort:  You should be able to sort the list by first name, GPA, and ID.  You could use any sorting algorithm.  Then print the list after you sort.  You should ask the user how you want to sort, either by first name, or  GPA, or  ID.  When you print, you will have to use a different print function than the one described below, because the one below prints the names sorted alphabetically by last name.

Search:  By giving the student ID, you should be able to search for that student in the list.  You should return the student's first name, last name, ID, GPA,  and phone number.  If the student is not found in the list, you should print a message indicating so. 

Update:  You should be able to update the student's GPA and/or phone number.  So you should be able to ask the user which student's information they want to update.   The user will provide you with the new GPA and/or phone number. You should show update the student's information and print the updated student's information.

HonorStudent:  Prints the number of students and names of  students whose GPA is greater than 3.6. 

WarnStudent:  Prints the number of students and the names of the students whose GPA is less than 2.0.

Print: Prints all the students information alphabetically, sorted by last name, and the total number of students in the class.

Reference no: EM13335314

Questions Cloud

Determine the volume charge density of the atmosphere : In a particular region of Earth's atmosphere, the electric field above Earth's surface has been measured to be 144 N/C downward at an altitude of 240 m and 177 N/C downward at an altitude of 390 m
Why do we have laws that prohibit discrimination in pay base : Why do we have laws that prohibit discrimination in pay based on gender or race but permit employers to discriminate in pay based on education or experience?.
Define what is the solubility of zinc phosphate : Zinc phosphate (Zn3(PO4)2) has a solubility product constant Ksp = 9.0 x 10^-33. What is the solubility of zinc phosphate in the following problems. answer them seperately... a) ...pure water? b) ...0.02 M ZnCl2? c) ...0.005 M Na3PO4
What is the expected return and standard deviation of the : What is the expected return and standard deviation of the stock?
Show the count of the class after deleting : Will insert any first name, last name, ID, GPA, and phone number, in the proper location in the list sorted alphabetically by last name.  After insertion, you should show the count of the class.  Then print the list after you insert.
Determine to what height will it rise : At the Earth's surface a projectile is launched straight up at a speed of 8.5 km/s. To what height will it rise
Explain why should nec accept the project : Tom Edison, the company's chief financial officer, has evaluated the project and determined that the project's unlevered cash flows will be $3.1 million per year in perpetuity.
Explain acid catalyzed reaction of cyclohexanol : Using structural formula, write a balanced equation for the phosphoric acid catalyzed reaction of cyclohexanol to give cyclohexene.
Evaluate the final molarity of bromide anion : Suppose of nickel (II) bromide is dissolved in of a aqueous solution of potassium carbonate. Calculate the final molarity of bromide anion in the solution

Reviews

Write a Review

Database Management System Questions & Answers

  Design scheme for determining wine bottle which poisoned

Design a scheme for determining exactly which one of the wine bottles was poisoned in just one month's time while expending O(logn) taste testers.

  Create a report which identifies five most expensive bicycle

Create a report which identifies five most expensive bicycles. The report must list bicycles in descending order from most expensive to lease expensive, the quantity on hand for each, and the markup percentage for each.

  Create query that spans both tables

Create a query that spans both tables. Eliminate redundant fields. Modify the Query to select only those Customers that had service dates in October and November 2006.

  Explaining business activity in new is with a database

Assume you manage business activity which needs a new IS with a database. The development team is divided on which DBMS you must use. One faction wishes to use oracle,a second wants to use MtSQL, and a third wants to use SQL server.

  Mark the words as index entries behavior and favorable

Mark the following words in the document as index entries: behavior (four instances), favorable (five instances), and impression (eight instances).

  Draw the e/r diagrams for the business rules

Draw the E/R diagrams for the business rules

  Does the resulting relation have an mvd

Does the above have one or more functional dependency (do not list FDs by applying derivation rules)? If so, what is it? Show how you will remove it by decomposition.

  Create a gis database of information about vietnam

You are asked to create a GIS database of information about Vietnam at scale of 1:100,000. Database will include the following: Which of these features are best represented by raster model? Explain why?

  Design an relational model model of a database

Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises. (Hint: You may choose to translate the 2 ER model designs you created ).

  What problems could be caused by not having indexes

What problems could be caused by not having appropriate indexes and what problems could be cause by having too many indexes?

  Find the decryption function and decipher

Find '(2007), '(2008), and '(b), where b is the integer obtained from the last four digits of your student number.

  List different entities-objects-logical processes-data flows

List the different entities or objects, logical processes, data flows, and data stores that are involved, starting from the time you submitted your time sheet.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd