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

本次加拿大CS 代写主要为Mysql数据库的assignment

Objectives

The purpose of this activity is to practice how to design front and middle tier of a Database Application.

SPECIAL Note:

• The recommended language/tool to design the frontend and application is Java language. If you want
to use some other language/tool, then first consult the instructor and get permission for that. Your
application must support Java SE 8 from the following link. If you want to use any variation of Java
that is not supported in SE8 then you must provide a fully functional executable that works on all
kinds of systems:
https://www.oracle.com/ca-en/java/technologies/javase-downloads.html

• Your solution to this assignment will be based on your solution to Assignment2 and you can re-use
your code from Assignment2.

• All implementation details that are not mentioned are left to your imagination and you are free to
opt an approach as per your understanding.

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.