Question: Branch Data Length 4 60 60 8 Keys Primary Ke Column Name Branch no Street Cit Postcode Data Type In Varchar Varchar In Staff Data

 Branch Data Length 4 60 60 8 Keys Primary Ke Column

Branch Data Length 4 60 60 8 Keys Primary Ke Column Name Branch no Street Cit Postcode Data Type In Varchar Varchar In Staff Data Type Integer Integer Varchar Varchar Varchar Char Date Double Data Length 4 Keys Column Name Staff no Branch no Fname Lname Position Pri Ke Date of Birth Sala Salary v alue given in table is monthly salary Figure 2: Staff Brach Relation a) Create a database named 'Staff Brach b) Create the tables/schema given in Figure 2, using 'Staff Branch' database (18 marks) c) Write query to display Staff no, Fname and Lname and calculate employee's annual (2 marks) (5 marks) d) Write query to display the salary and calculate the estimated total salary for the next 5 years for all the employees without any increment associated to the salary (5 marks) e) Write SQL insert statement to insert the value given below into the Branch table (5 marks) Branch no Street Ci Postcode an street 12/33 Cheras 63450 f) Update the Branch information that you have just insert in question (e) with the Information given below (5 marks) Street Sultanah street 12/33 Ampang 63450 Branch no Ci Postcode

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!