“COUNT()” function: In SQL, the “COUNT()” function will return the total number of rows in the table with satisfying the criteria mentioned in the “WHERE” clause. Table creation: Query to create “INVOICE” table: CREATE TABLE INVOICE (INV_NUMBER INTEGER PRIMARY KEY, CUS_CODE INTEGER, INV_DATE DATE); Query to insert values into “INVOICE” table: INSERT INTO INVOICE VALUES (1001, 10014, '16-Jan-18'); INSERT INTO INVOICE VALUES (1002, 10011, '16-Jan-18'); INSERT INTO INVOICE VALUES (1003, 10012, '16-Jan-18'); INSERT INTO INVOICE VALUES (1004, 10011, '17-Jan-18'); INSERT INTO INVOICE VALUES (1005, 10018, '17-Jan-18'); INSERT INTO INVOICE VALUES (1006, 10014, '17-Jan-18'); INSERT INTO INVOICE VALUES (1007, 10015, '17-Jan-18'); INSERT INTO INVOICE VALUES (1008, 10011, '17-Jan-18');

Question

Unit 1 Assignment 1 – Loops and Methods (25 points) Task: You are working for Kean University and given the task of building an Email Registration System. Your objective is to generate a Kean email ID and temporary password for every new user. The system will prompt for user information and generate corresponding credentials. You will develop a complete Java program that consists of the following modules: Instructions: 1. Main Method: ○ The main method should include a loop (of your choice) that asks for input from five users. For each user, you will prompt for their first name and last name and generate the email and password by calling two separate methods. Example о Enter your first name: Joe Enter your last name: Rowling 2.generateEmail() Method: This method will take the user's first and last name as parameters and return the corresponding Kean University email address. The format of the email is: • First letter of the first name (lowercase) + Full last name (lowercase) +…

Answer 1

Question

100%

Chapter 7, Problem 26P

Program Plan Intro

“COUNT()” function:

In SQL, the “COUNT()” function will return the total number of rows in the table with satisfying the criteria mentioned in the “WHERE” clause.

Table creation:

Query to create “INVOICE” table:

CREATE TABLE INVOICE (INV_NUMBER INTEGER PRIMARY KEY, CUS_CODE INTEGER, INV_DATE DATE);

Query to insert values into “INVOICE” table:

INSERT INTO INVOICE VALUES (1001, 10014, '16-Jan-18');

INSERT INTO INVOICE VALUES (1002, 10011, '16-Jan-18');

INSERT INTO INVOICE VALUES (1003, 10012, '16-Jan-18');

INSERT INTO INVOICE VALUES (1004, 10011, '17-Jan-18');

INSERT INTO INVOICE VALUES (1005, 10018, '17-Jan-18');

INSERT INTO INVOICE VALUES (1006, 10014, '17-Jan-18');

INSERT INTO INVOICE VALUES (1007, 10015, '17-Jan-18');

INSERT INTO INVOICE VALUES (1008, 10011, '17-Jan-18');

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Unit 1 Assignment 1 – Loops and Methods (25 points) Task: You are working for Kean University and given the task of building an Email Registration System. Your objective is to generate a Kean email ID and temporary password for every new user. The system will prompt for user information and generate corresponding credentials. You will develop a complete Java program that consists of the following modules: Instructions: 1. Main Method: ○ The main method should include a loop (of your choice) that asks for input from five users. For each user, you will prompt for their first name and last name and generate the email and password by calling two separate methods. Example о Enter your first name: Joe Enter your last name: Rowling 2.generateEmail() Method: This method will take the user's first and last name as parameters and return the corresponding Kean University email address. The format of the email is: • First letter of the first name (lowercase) + Full last name (lowercase) +…

I have attached my code, under I want you to show me how to enhance it and make it more cooler and better in graphics with following the instructions.

Using R language