BA 212 : Database Management Systems - Assign2 1. List all tapes, and if a tape is currently rented out to a member, include the member's number and name in your report for each tape, else leave those columns blank (List tape number, member number, and member name) 2. (Movies ) add 1 to the number of bonus units for each member who has rented at least 10 units. Print the updated table. 3. Chap 3 - (Movies ) Q 6 4. Chap 3 - (Movies ) Q 8 5. Chap 3 - (Chazy) Q 12 6. Chap 4 - (Chazy) Q 6 7. Chap 4 - (Movies ) Q 6 8. Chap 4 - (Movies ) Q 12 9. Chap 5 - (Movies ) Q 4 10. Chap 5 - (Movies ) Q 8 11. List the total nominations received by each director through his/her movies.(List DIRNO, Name and total_noms). 12. Create a view to show all PCs and employees to whom they are assigned. Print the view. Note: Whereever a table is chaged due to update, delete, or insert, print the after table and turn it in. For all querries turn in the query and the output also.