Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started