Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Millionaire Next Door The Surprising Secrets Of Americas Wealthy

Authors: Thomas J. Stanley, William D. Danko

1st Edition

1589795474, 978-1589795471

Students also viewed these Databases questions

Question

What is ahead?

Answered: 1 week ago

Question

What are the details of banks in making decisions?

Answered: 1 week ago