Question: ADVANCE DATABASE MANAGEMENT SYSTEMS Use the Address and the Position relations to answer the following questions Address bachstreetcity BOOS 22 Mantse St Accra B007 16

ADVANCE DATABASE MANAGEMENT SYSTEMS

Use the Address and the Position relations to answer the following questions Address bachstreetcity BOOS 22 Mantse St Accra B007 16 Otumfour St Kumasi B006 25 Nii St Acer 163 Togbe St Ho B004 32 Omanhene St Koforidus BOOZ 10 km Idiroko St Ota B001 17 Ayagitar St Navrongo B003 Greater Accra Ashanti Greater Accra Volta Eastern Lagos Upper East Position stato Name Name Position sex DOBES Branch SL15 Mutin Dark Manngar M 1-Oct-1977 3600 BOOS Eunice Fair Manager F 10-Nov-1978 3600 B007 SG14 Abigail Durk Supervisor F 24-Mar-1980 2400 B006 SG15 SA 19 SGS SLAS Valerie Muyiwa Charles Creme Coordinator Lala Manager Tall Assistant Manager Fair Supervisor F M M 19-Feb-1976 3-Jun-1985 13-Jun-1987 1200 3600 1200 B004 B002 B003 SA9 Pricilla F 15-May-1988 2400 B001 a. Assume that the column Salary in the Position relation represents monthly salary Write an SQL statement to produce a list of annual salaries all staff showing stuffNo. [3 marks) [6 marks) b. Write an SQL to produce the following output: D) Accra Kumasi Accra Ho Koforidus Ota Navrongo Accra Kumasi Ho Koforidun Oth Navrongo c. Write an SQL statement to list addresses of all branch offices in Kumasi or Ota [3 marks] [12 MARKS]

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!

Please read the case and answer the following questions for this case: Briefly analyze each of the business models for the industry analysis (Porter's 5 Forces, the 4'p of marketing, the PLC model,...

Using the Annual Report of your selected company answer the following questions in the Discussion: What are adjusting entries and why are they necessary? In your chosen company, which accounts might...

SQL Exercise Using the given query below and write queries (with subqueries) to answer the following questions. 1. Which publishers haven't published a cook book? 2. Which publisher has the highest...

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

Answer the questions below for this year and last year, using your SEC 10-K: Link to SEC 10-K:http://d1lge852tjjqow.cloudfront.net/CIK-0000315189/ceea88ae-ba2b-4204-9b4a-2c9a06e40401.pdf?noexit=true...

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

-- create database and tables create database expandedbookbiz go use expandedbookbiz go create ta... -- create database and tables create database expandedbookbiz go use expandedbookbiz go create...

There are 3 attachments. The first attachment are the instructions and questions that are to be answered. The following 2 attachments are useful items needed to complete the questions properly....

Hassan and Kiara are saving for their daughter Amira's college education. Amira just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses...

For the employees listed below, indicated as well as total taxes by type and by employee. security tax rate is 6.0%, the Medicare tax rate is 1.5% on all earnings, the state unemployment tax rate is...

International transactions are generally as effective as those governing domestic transactions.

what significance might being removed from the FTSE4Good index have for a company?

Question What is a Roth 403 (b) plan?

Question Can a TDA participant transfer funds from one annuity contract or mutual fund investment to another without adverse tax effect?

Question Can a Keogh plan fund be reached by the owners creditors?