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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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