Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem: Let consider the given tables:

WORKS (Pname, Cname, salary)
LIVES (Pname, Street, City)
LOCATED (Cname,City)
MANAGER (Pname, Mname)

prepare down a query in the SQL for the given:

a) List all the names of people who work for the company Wipro all along with the cities they live in.

b) Find out the people who work for the company ‘Infosys’ having salary more than Rs. 50000/-.

c) List all the names of people, all along with the street and city addresses.

d) Find out the persons whose salaries are more than that of all of the ‘oracle’ employees.

e) Find out the name of the persons who don’t work in ‘infosys’.

f) Find out the average salary of the employee in company named ‘accenture’.

g) Make a table for the above relations by using SQL-DDL

h) Make a view comprising of the person name all along with their manager name and company name.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M911860

Have any Question? 


Related Questions in DBMS

Ngocbo database projectthe purpose of this project is to

NGO/CBO Database Project The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Database Specifications In view of ...

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

Assignmentdeliverablesall files are located in the

Assignment Deliverables All files are located in the subdirectory of the project. The project should function as specified: When you visit the Personnel form page (frmPersonnel.aspx), a record should be saved in the tblU ...

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

Organizations want information organizations need

Organizations want information. Organizations need information. However, information must be in an organized format that supports the creation of business intelligence. Otherwise, according to Rebecca Wettemann, vice pre ...

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

Assignment business intelligence and data

Assignment: Business Intelligence and Data Warehouses Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a man ...

Salaries for database administrators database

SALARIES FOR DATABASE ADMINISTRATORS Database administrators (DBAs) are among the highest paid professionals in the information technology field. Many people work for 10 to 20 years to get a promotion to DBA. Connect to ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro