ER diagram for the Branch user views of StayHome showing primary keys. Directs Director 1..1 directorNo 1..* Video Plays

[answerhappygod]

Er Diagram For The Branch User Views Of Stayhome Showing Primary Keys Directs Director 1 1 Directorno 1 Video Plays 1 (64.63 KiB) Viewed 50 times

Write down the SQL command for each one of the following
requests.
(1) List the videos on rent in branch B001 or B004.
(2) Summarize the average salary for each position sorted by the
average salary in descending order.
(3) Increase the salary of the staffs whose salary is below
average by $1,000.
(4) Summarize the number of unreturned videos for each member
registered in branch B001, including member names.
ER diagram for the Branch user views of StayHome showing primary keys. Directs Director 1..1 directorNo 1..* Video PlaysIn Actor catalogNo 1..* 0..* actorNo 1..1 Is Supervises Supervisee 1.. Has 0.. Video For Rent IsAllocated Branch Staff 1..1 1..* 0..1 Manages video No 1. * 1..1 branch No staffNo Supervisor 0..1 1..1 1..* 1..1 IsPartOf 1..1 Registers 0..* RentalAgreement Member Requests 0..* rentalno 0..* 1..1 memberNo