Write a Java program that allows university administrators to print the teaching record of an instructor.

Start by having the user input the login ID and password; then open the proper connection.

The user is asked next for a search substring and the system returns $($ID$,$ name$)$ pairs of instructors whose names match the substring. Use the like $(\text{'}\%$substring$\%\text{'})$ construct in SQL to do this. If the search comes back empty, allow continued searches until there is a nonempty result.

Use the BCNF decomposition algorithm to find a BCNF decomposition of R$.$ Start with A $$ BC$.$ Explain your steps.

For your decomposition, state whether it is lossless and explain why.

For your decomposition, state whether it is dependency preserving and explain why.