Writing a program to manage a student database

Assignment Help Database Management System
Reference no: EM13842106

The fourth programming project involves writing a program to manage a student database. The interface to the program should be a GUI that looks similar to the following: A combo box should allow the user to select one of the four database actions shown.

The database should be implemented as a HashMap, with the ID field as the key and a student record consisting of a name and major as the value. The operation should be performed when the user clicks the Process Request button. If the user attempts to insert

a key that is already in the database an error message should be displayed using a JOptionPane message dialog box. If the user attempts to delete, find or update a record that is not in the database, a message should also be displayed. After each successful

operation is completed a JOptionPane window should be displayed confirming the success. In the case of a successful Find request, a window should pop up containing the student's ID, name, major and current GPA. When the user selects the Update request, the

following JOptionPane windows should be displayed to gather information about a course that has just been completed: This program must consist of two classes. The first class should define the GUI and handle the database interactions. It should be hand-coded

and not generated by a GUI generator. The second class named Student, should define the student record. It must have instance variables for the student name, major and two variables that are used to compute the GPA. A variable that contains the total number

of credits completed and a second variable that contains the total quality points, which are the numeric value of the grade received in a course times the number of credit hours. It should not contain the student ID. The class should have the following three

methods: A constructor that is used when new student records are created. It should accept the name and major as parameters and initialize the fields that are used to compute the GPA to zero. The second method courseCompleted should accept the course grade

and credit hours and update the variables used to compute the GPA. It will be called when an Update request is made. The third method should override toString and return a labeled string containing the student name, major and GPA. Be sure that all instance

and class variables are declared as private. Also any exceptions thrown by nonnumeric inputs should be properly handled. Finally when a student has not yet completed any course, the GPA should be displayed as 4.0.

Reference no: EM13842106

Questions Cloud

Ethically responsible for what occurred : Identify a company you believe is/was ethically responsible for what occurred. How would you have approached this differently as the CEO/Marketer to ensure this hadn't happened? Be sure to share the URL with your fellow students of the organization y..
Relationship between customer and products : relationship between customer and products
Relationship between physical health and stress : What is the relationship between physical health and stress? How does optimism and negative affect impact the stress response? What can individuals do to mitigate the health risks associated with prolonged stress
Develop a context diagram and a diagram 0 dfd : Develop a context diagram and a diagram 0 DFD for TIMS. Include notes to identify any assumptions or other issues. Depending on program used, either include URL or raw file of program, PLUS a common format (jpg/pdf).
Writing a program to manage a student database : writing a program to manage a student database
Inner causes-interpersonal causes and external causes : Aggression can be triggered by inner causes, interpersonal causes, and external causes. Explain and give examples of each type of cause. Which – inner, interpersonal, or external – do you think are most powerful? Why?
Explain the strengths and limitations of dispositional : Differentiate between the various dispositional, biological and evolutionary personality theories. Explain the strengths and limitations of dispositional, biological and evolutionary personality theories
Which technique of social influence do you use on others : Describe the two types of social influence. Give a personal example of how you have been influenced by each type. Which technique of social influence is most effective when used on you? Explain using an example. Which technique of social influence do..
Restrictions set customs have had negative effect on impot : Choose a country and then explain the way in which some of the restrictions set by customs have had a negative effect on the import/export business.

Reviews

Write a Review

Database Management System Questions & Answers

  Evaluation team in order to meet sarbanes-oxley compliance

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley compliance.

  Brief summary of the data architecture of the company

Understand the challenges and evaluate the risks in managing the security of an information system  Critically analyse using a threat and risk assessment.

  Provide an entity relationship model

Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements.Note:The graphically depicted solution is not included in the required page length.

  Create the corresponding relational data model

Create the corresponding relational data model by implementing the database for myFlicks.com within the course's mySQL site, linked on the course's homepage within Blackboard. Be sure to populate your tables with dummy data, providing me with the..

  Fishing in the public waterbodies of victoria rivers creeks

fishing in the public waterbodies of victoria rivers creeks lakes and reservoirs is controlled by the freshwater

  Write the vbscript code

Write the VBScript code that initializes all the variables in the numArray(100) to the value numArray(0)=1, numArray(1)=2,&#-123;,numArray(100)=101

  When conflict is good for teams

Normal 0 false false false EN-US X-NONE X-NONE When conflict is good for tea..

  Develop an e-r diagram for the library database

Develop an E-R diagram for the library database. The relation schemas for the library database. Normalization of the relations (your relations should be in 4NF)

  Describe how harrahs treats customer data

Describe how Harrah's treats customer data. What is customer lifetime value? Do you think this is an easier metric to calculate at Caesars or Wal-Mart? Why?

  What types of relationships are possible in a database

Define operational excellence. How can information systems help achieve it? What types of relationships are possible in a relational database? Describe and give an example of each.

  Improved processesdatabases are installed to help solve

improved processesdatabases are installed to help solve problems improve processes or provide a benefit to the

  Draw an initial entity-relationship model

Normalise the Project Allocation form (Fig 1) to arrive at third normal form entities. Show all the steps of normalisation clearly.

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