ER diagram for the Branch user views of StayHome showing primary keys. Directs Director 1..1 directorNo 1..* Video Plays
Posted: Sun May 15, 2022 1:59 pm
- 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 52 times
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