For the following 'StaffBranch' table, write SQL query that for each branch, lists staff (defined by...

 

Transcribed Image Text:

For the following 'StaffBranch' table, write SQL query that for each branch, lists staff (defined by staff number and first and last name) who manage properties, including the city in which branch is located and the properties they manage in the table below. branchNo city B003 B003 B003 BOOS staffNo Name Name property No David Ann Ann Glasgow SG14 Glasgow SG37 $1.21 SG37 SG14 Glasgow SG37 London SLAI Julie Staff Branch staffNo sName SA9 SGS Give three advantages and three disadvantages of distributed database management systems (DBMS). The table 'StaffBranch' has redundant data (the details of a branch are repeated for every member of staff). Please decompose it into two smaller tables, 'Staff' and 'Branch'. Ford Beech Beech Lee PG16 PG21 PG36 PL94 John White Ann Beech David Ford Mary Howe Susan Brand Manager position salary branchNo bAddress Manager 30000 8005 Assistant 12000 8003 Supervisor 18000 8003 Assistant 9000 B007 24000 B003 22 Deer Rd, London 163 Main St, Glasgow Na Main St, Glasgo 16 Argyll St. Aberdeen 163 Main St, Glasg For the following 'StaffBranch' table, write SQL query that for each branch, lists staff (defined by staff number and first and last name) who manage properties, including the city in which branch is located and the properties they manage in the table below. branchNo city B003 B003 B003 BOOS staffNo Name Name property No David Ann Ann Glasgow SG14 Glasgow SG37 $1.21 SG37 SG14 Glasgow SG37 London SLAI Julie Staff Branch staffNo sName SA9 SGS Give three advantages and three disadvantages of distributed database management systems (DBMS). The table 'StaffBranch' has redundant data (the details of a branch are repeated for every member of staff). Please decompose it into two smaller tables, 'Staff' and 'Branch'. Ford Beech Beech Lee PG16 PG21 PG36 PL94 John White Ann Beech David Ford Mary Howe Susan Brand Manager position salary branchNo bAddress Manager 30000 8005 Assistant 12000 8003 Supervisor 18000 8003 Assistant 9000 B007 24000 B003 22 Deer Rd, London 163 Main St, Glasgow Na Main St, Glasgo 16 Argyll St. Aberdeen 163 Main St, Glasg