ITC521 | Assessment 3: Database and Multithread Programming | IT

Home Recent Questions ITC521 | Assessment 3: Database and Multithread Programming | IT

Task 1: Grade Processing (7.5 marks)
University grading system maintains a database called "GradeProcessing" that contains number of tables to store, retrieve and manipulate student marks. ‘Java2’ is one of the tables which contains following attributes for all the students enrolled in "Java2": “ID”, “Name”, “Quiz”, “A1”, “A2”, “Exam”, “CumulativeMark” and “Grade”. A sample of the table may look like as follows:

Write a JAVA Graphical User Interface (GUI) program that would perform following tasks:
• Create Table: Create a table that is capable to store above information.
• Insert Record: If the user of your program wants to insert a record, your program should ask for all the fields of the record and insert them in the table.
• Search: The user of your program should be able to search a particular record by ID or any other field.
• Update: The user of your program should be able to update any field/s of a particular record. The record for update operation will be selected by ID.
• Calculate Results: The Cumulative Mark of a student would be calculated using the following formula: CumulativeMark = (Quiz * 0.05)+(A1* 0.15) +(A2* 0.2) + (Exam * 0.6)
• Calculate Grade:

HD: CumulativeMark>=85
DI: 75<=CumulativeMark<85
CR: 65<=CumulativeMark<75
PS: 50<=CumulativeMark<65
FL: CumulativeMark<50
Note that, ID must be 8-digit number, A1, A2, and Exam marks must be between 0 and 100 (inclusive), and CumulativeMark must be floating-point numbers with two decimal places.

Task 2: Sorting Animation using Multi-threading and JavaFx GUI(7.5 marks)
Write a multi-threading animation program for selection sort, insertion sort, and bubble sort using JavaFx GUI. Some sample outputs of the program is shown below. Create an array of integers 1,2,...,30 and shuffle the elements of the array randomly. Create a pane to display the array in a histogram. You should invoke each sorting method in a separate thread. Each algorithm uses two nested loops. When the algorithm completes an iteration in the outer loop, put the thread to sleep for 0.8 seconds, and re-display the array in the histogram, color the last bar in the sorted sub-array.

This assessment task will assess the following learning outcome/s:

• be able to create, manage and manipulate objects via the Java Collections Framework.
• be able to design and implement multithreaded Java applications.
• be able to design and construct Java Graphical User Interfaces (GUI) that interact with problem domain objects.
• be able to create, connect to and update a relational database using the Java Database Connectivity (JDBC).

Search Here

Latest Reviews

  • Kannon
    13 Jul, 2019

    I asked for essay help from Assignment Help 4 Me and I am happy that the essay writers completed my task on time. The prices they asked for are worth in comparison to the services rendered.

  • Liam
    13 Jul, 2019

    Assignment Help 4 Me is the best help provider. I took assistance to get my essay completed and I am glad that the writers delivered the quality content as they promised within the time committed.

  • Silas
    12 Jul, 2019

    Accounting is a very interesting subject but when it comes to assignment writing, I feel hard to get through the same. But, since the assignments have to be completed somehow, I preferred to avail online help from Assignment Help 4 Me. All thanks to them that they helped me complete my work on time at reasonable prices.

View All Reviews


Assignment Help 4 Me