2023年11月25日

MySQL数据库代写 | LE/EECS 3421 Assignment 3: Frontend and Application Design

本次加拿大代写是MySQL数据库相关的assignment

Question 1: Front end to Insert Data 

Design a Java class that displays a suitable screen/frontend (GUI) to user using which user can insert data
for a new CFP; the class must be named Q1_yourID. This class will work as a frontend for your solution
to Qeustion2 in Assignment2; therefore, in the design take care of all necessary issues.

• Your frontend must support all three types of events.

• Your frontend class must not process and insert the data to the database, rather only collect the
data and pass it to the middle tier class, which you will design in Qeustion3.

You are required to:
• Submit the code for this class in a java file. Name this file as Q1_yourID.java.

Question 2: Front end for Queries

Design a Java class that displays a suitable screen/frontend (GUI) to user using which user can see the
results of the two queries that we have designed in Question4 of Assignment2; the class must be named
Q2_yourID. This class will work as a frontend for your solution to Qeustion4 in Assignment2; therefore,
in the design take care of all necessary issues.

• Your frontend must support both queries and provide a way of selection.

• Your frontend class must not process and retrieve the data to the database, rather invoke the
suitable methods in the middle tier class, which you will design in Qeustion3.

You are required to:
• Submit the code for this class in a java file. Name this file as Q2_yourID.java.

Question 3: Middle Tier 

Design a Java class Q3_yourID. In this class, provide suitable methods that will support the frontends
designed in Question1 and Question2 so that the data can be properly inserted to the database or can be
retrieved from the database as desired. This class will support both the classes in Question1 and Question2;
therefore, in the design take care of all necessary issues.

• The method(s) supporting Question1 and Question2 must be separate.

• The CFPCount table that we have created in Question1 of Assignment2 is also part of schema and
it must be updated appropriately.

You are required to:
• Submit the code for this class in a java file. Name this file as Q3_yourID.java.