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

  Create a context level dfd

Create a context level DFD. You should take your DFD to your tutorial for feedback before starting on the ER.

  How protocol ensures serializability and deadlock freedom

To lock any other vertex, the transaction must have visited all the parents of that vertex and must be having a lock on one of the parents of the vertex. Show that the protocol ensures serializability and deadlock freedom.

  Write the application for university admissions office

Write the application for university admissions office. Prompt user for a student's High School Grade Point and an admission test score.

  Prepare the relational schema for database

Prepare the relational schema for database

  Describe a minimum of three heuristics to optimize queries

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

  Create erd models

Select one of the Real World Scenarios and use the experience you have that is related to the scenario you have chosen or research online; and then post your comments and solutions about your experience.

  Write program to ask user to enter last name of customer

Write a program that will ask the user to enter the last names of our candidates in a class officer's president election and the number of votes received each candidate.

  Create an oracle database

Populate your database with at least 3 rows of data and import your IDEF1X diagram into Oracle and create the appropriate tables and relationships.

  Create a database design - relational data model

Create a database design specification Enhanced Entity Relationship Diagram (EERD) and Relational Data Model from the given business description - Database Management System

  Explain it project to coordinate and maintain records

The system should support notifications to management personnel whenever their direct reports have submitted documentation. The system should also notify employees if their deadline to complete professional-development requirements is approaching ..

  Develop view for sum of number ordered multiplied by price

Develop a view named OrdTot. It comprises the order number and order total for each order presently on file. (Order total is sum of the number ordered multiplied by quoted price.

  Write long term problems when constraints are implemented

Why are these so significant yet so frequently ignored by developers? Write the long term problems when these constraints are not implemented? "

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