Question: Database Systems Given the following relation schemas: CAR = (serialN, model, advertisedPrice) SALES = (salespersonID, serialN, date, salesPrice) SALESPERSONS = (salespersonID, Name, Address) Express the

Database Systems

Given the following relation schemas:

CAR = (serialN, model, advertisedPrice)

SALES = (salespersonID, serialN, date, salesPrice)

SALESPERSONS = (salespersonID, Name, Address)

Express the following by SQL statement

1) List the name and ID of every salesperson who sold at least two cars with salesprice greater than $10000.

2) List all attribute of unsold car with advertisedPrice greater $20000 (i.e all attributes of the table CAR).

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!

Q:

Task 7 1. A discrete random variable has a mean of 400 and a variance of 64. What is the standard deviation? (Points : 1) 20 64 8 400 None of the above Question 2. 2. Data for a particular...

Q:

Computer Science - Database Systems Given the following relation schemes: Teacher = [CourseN, Quarter,TeacherName] Course = [CourseN,CourseName, Nunit) LocationNTime = [CourseN, Quarter , DayTime,...

Q:

SECTION A: Answer ALL (30 marks) QUESTION 1 (a) Briefly describe three functions of Database Management Systems (DBMS). [6 marks] (b) Given the following attributes in the form of first...

Q:

Fundamentals of Database Systems Consider the following ERD Where - PatientId: It is the identification number of each patient - PatientName: It is the name of the patient - Patientddr: It is the...

Q:

Database Management Systems Given the following database instance, answer questions 1.1 through 1.3 Employee Plan EC14 EC15 EC16 EC17 EC20 JC2 JC4 JC1 JC3 JC2 Term Life Stock Purchase Long-term...

Q:

introduction to database systems Given relation schemas in a database, use SQL queries to solve the following questions. Tables: 1. Authors-stores information about authors - Columns: - author_id...

Q:

PLEASE BE DONE IN RELATIONAL ALGEBRA DATABASE SCHEMA - Given the following relational database schema Supplier ( SupplierCode, Name, Address, City) Product (ProductCode, Name, Brand, Model) Catalog...

Q:

Database Systems Consider the following schema: Employee (person-name, street, city) Works (person-name, company-name, salary) Company (company-name, city) Manages (person-name, manager-name) Write...

Q:

About database systems 5. The following tables form part of a database held in a relational DBMS Hotel (lhotelNo, hote IName, city) (roomNo, hotelNo, type, price) Booking Guest Room contains room...

Q:

Database Systems Specify the following queries in SQL on the Company relational database schema: 1. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the...

Q:

Design the Number puzzle game using JavaFx GUI library. Each level will display one crossword Math block. Use the following blocks for 4 levels of the games. Use the Next button to move to the next...

Q:

What benefits does a small business get by offering customers credit?

Q:

Since the benefit of increased financial leverage is fairly abstract and difficult to value relative to the cost of that increased leverage, which is highly visible to firm management, firms tend to...

Q:

Assume you have a company that has the following financials for fiscal year 2020 for scenario 1 & 2: $300 million in cash $600 million in book value of debt $500 million in market value of debt...

Q:

4. Are there any disadvantages?

Q:

3. What are the main benefits of using more information technology?

Q:

start to review and develop your employability skills