Java and SQL Exercises

Question 1

Given is the sample string. Answer the following questions below

abcddda bc cbbcaaaa cc

1. Create a Java function that will remove all spaces from a string. You can't use replace/trim/split/stream/replace all/substring.

2. Create a Java function that will find the number of chars repeating in a row 3 times or more.

3. Create a Java function that will find the longest repeated char in a string.

4. Write n! function.

Question 2

SQL

• Students
  • Student_id
  • First_name
  • Last_name
• Grades
  • Student_id
  • Course
  • Grade
• Bonuses
  • Course
  • Bonus

1. Find the full name of students which participate in C++ course

2. Find the minimum grade of each student

3. Find the full name of the students which have not failed any course (failed < 55)

4. Find the students first name and grade including the bonus (if exist) given for each course.

5. Build ERD for customers and their addresses where each address can belong to more than one customer and each customer can have more than one address