1)create a database useing sql or java to store the data for Email, First Name,

Question

1)create a database useing sql or java to store the data for Email, First Name, and Last Name.

2) Create a class named Customer that stores data for the user’s id, email address, first name, and last name.

3) Create a class named CustomerDB that contains the methods necessary to get an array list of Customer objects, to get a Customer object for the customer with the specified id, and to add, update, or delete the specified customer.

4) Create a CustomerManagerFrame class like the one shown above. This frame should display a table of customer data as well as the Add, Edit, and Delete buttons. This class should use the Customer and CustomerDB classes to work with the customer data.

5) Create a CustomerForm class that allows the user to add or edit customer data.

Customer Manager Email First Name Last Name frankiones@yahoo.com Frank John pohnsmith@hotmail.com Smith Green seagreen Clevii com Cynthia wendykewarners.com Wendy wolski Add Edit Delete

Explanation / Answer

1)syntax to create database databasename;

create database CustomerManager;

CREATE TABLE Customer (
CustomerID int,

Emailid varchar(255),
LastName varchar(255),
FirstName varchar(255)
);

2)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.