View the step-by-step solution to:

Question

The database contains four tables (EMPLOYEE, DEPARTMENT, PROJECT, and ASSIGNMENT).

Execute SQL statements to

do the following:

a. Retrieve all the columns and rows from the department table

b. Retrieve all the columns about the InfoSystems department

c. Retrieve a unique list of the employees' first name.

d. Retrieve all the columns for employee(s) whose first name is Mary.

e. Retrieve all the information for the assignments with hours worked less than 40.

f. Retrieve all the columns for employee(s) whose first name starts with an M.

g. Retrieve all the columns for employee(s) whose first name ends with an e.

h. Retrieve all the columns for employee(s) whose first name ends with an e and not George.

i. Retrieve all the columns for employee(s) whose first name starts with a J and ends with an n.

j. Retrieve all the columns for employee(s) whose first name starts with M or J.

k. Retrieve all the columns for employee(s) whose first name starts with M or J and ends with n or e.

l. Retrieve all the columns for employee(s) whose first name is 5 letters.

m. Retrieve all the columns for employee(s) whose first name is 5 letters and ends with an a.

n. Retrieve all the columns for employee(s) whose first name is 5 letters and starts with a J and ends with an a.

o. What would happen if insert the following values in the Assignment table (1700, 22, 55). Would it work? If not, what type of error you would be getting? Why would you be getting this error? What do you need to do to be able to insert (1700, 22, 55) in the Assignment table? (Note: do not try to run INSERT statement as you do not have privilege, I need an answer based on your understanding to the tables' structure and the constraints).

Top Answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question