Answer Happy

12:00 1 Back Assignment.docx Branch Registration Stall Client Property For Rent Figure 1: list of tables Note: _: Primary key * : Foreign Key Write an SOL query to create a table "REGISTRATION as shown in Fig. 1, make sure it satisfies all the referential integrity constraints. Write an SQL query to insert a new tuple into a branch table where branch is located in Kuala Lumpur with B017 and in street '08 Jalan Gombak' with postcode JG53100
12:00 1 Back Assignment.docx ...Write an SOL query to delete all those tuples from BRANCH where city name contains ris" Write an SQL query to retrieve the Branchno, total number of staff working in each branch from staff table. Write an SQL query to update (increase the salary of those staff by 500 whose position is manger in STAFF table Write an SQL query to retrieve the details of all the staff from STAFF table who are not 'male and are not managers vi Write an SQL query: from each branch with more than member of staff, find the number of staff in each branch and their sum of their salaries and sort by branch no. Use nested questo
12:001 Back Assignment.docx Write an SQL query to retrieve the details of all the staff from STAFF table who are not "male" and are not managers Write an SQL query: from each branch with more than 1 member of staff, find the number of staff in each branch and their sum of their salaries and sort by branch no. Use nested queries/subqueries VEL Write an SQL query to delete tuple in the PROPERTYFORRENT table where property is in city "Aberdeen" staff salary is equal to 9000 I Write an SQL to retrieve the name, Iname, position, salary of those staff who are working in city London or Glasgow *Write an SOL query to update the DATEJOINED 10 31=DEC-99 in Registration Table where registration is handled by the staff name as Ann Beech and client PREFTYPE is 'House"