Q1/ Consider the fruit database with fruit and market tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Fruit(ID, fruit_name, fruit_color, price_KG) Market(market_name, city, street, fruit_name) 1- Find the names of all red fruits that has price less than 25 dinars. 2- Find the names of markets that sell banana in Atlanta city. 3- Find the name of fruits that has yellow color and sell in Glasgow market

Q1/ Consider the fruit database with fruit and market tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Fruit(ID, fruit_name, fruit_color, price_KG) Market(market_name, city, street, fruit_name) 1- Find the names of all red fruits that has price less than 25 dinars. 2- Find the names of markets that sell banana in Atlanta city. 3- Find the name of fruits that has yellow color and sell in Glasgow market

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: Write SQL statements to (1) create the BREED table, (2) insert the data in Figure 3-21 into the…

A: Given: Write SQL statements to (1) create the BREED table, (2) insert the data in Figure 3-21 into…

Q: Answer the given question with a proper explanation and step-by-step solution. Using SQL Server…

A: In this question we have to write a SQL Based Query using SQL server and the AdventureWorks2012…

Q: Create an SQL database of the above ER-diagram using “create table” statements. The type of…

A: ER DIAGRAM: Please run each query one by one

Q: help with sql class 1.Report the student name, email, and entry date of all female students. The…

A: 1. Report the student name, email, and entry date of all female students. Query: SELECT student_name…

Q: Consider the following schema: Publisher (name, phone, city), PK: name. Book (ISBN, title, year,…

A: select b.title from Book b inner join (select e.bISBN from Edit e group by e.eSSN having count(*)…

Q: One of the TAL Distributors database's denormalized tables is as follows: The Customer table is no…

A: The answer is given below step.

Q: hay have any number of Pets, who are identified by a sequential number that carts at 1 for each…

A: SQL query for Client table:- Create table Client (ClientID int(20) (Primary key), FirstName…

Q: 6. Create a view Course_Grades showing GPA of all the students in a class with Class_Code: 11794.…

A: 6. CREATE VIEW Course_Grades AS SELECT S.Stu_Num…

Q: the HR department needs the department name, manager first name, manager last name, and job title.…

A: SQL: SQL stands for Structuref Query Language. It is used to access and manipulate the database…

Q: Consider the following relational schema and answer the following questions. Employee (Employee_Id,…

A: - The schema provided is about employees with their data like their name, salary and multiple ids.

Q: Write a simple PL/SQL function which has the following definition. Refer to the "EMP" below for…

A: PL/SQL which refers to the one it is the purpose of PL/SQL in order to combine database language…

Q: Build the Students Table that is shown in the picture using python SQL hint: The SQL command to…

A: Since the table is stored in db, there is no output. I'll directly post python code.

Q: You are working with a database table that contains invoice data. The table includes columns for…

A: The answer to the above question is given in step 2

Q: Please give a detailed answer and code examples for all the questions. What are the types of SQL…

A: What is a SQL join A SQL Join is a special form of generating a meaningful data by combining…

Q: Write a SQL query. List names of all employees who have sold to customer Rachel Patterson (Note: You…

A: In this database problem, we are tasked with creating an SQL query that lists the names of all…

Q: Consider a database table named "EMPLOYEES" with the following columns: E_EMPLOYEEID, E_FIRSTNAME ,…

A: Understand the Requirement:Identify the table: In this case, the table is named "EMPLOYEES."Identify…

Q: Write and execute a SQL query to list all patient numbers and encounter ids which do not have any…

A: Actually, SQL stands for Structured Query Language.

Q: Consider the following relational schema and answer the following questions. Employee (Employee_Id,…

A: SQL (Structured Query Language) is used for managing and manipulating relational databases. SQL…

Q: Consider the following relational schema and answer the following questions. Employee (Employee_Id,…

A: The SQL query is given below for the above given question:

Q: Use JOINS (inner, self, left and right, cross and full ) in these tables with sql:

A: SQL INNER JOIN:-The INNER JOIN keyword selects records that have matching values in both…

Q: 1. What is the difference between the DELETE and DROP statements? 2. What is a subquery in SQL? se…

A: SQL means Structured Query Language is a standard language for creating, storing, retrieving and…

Q: Create a table in SQL developer and name it as ‘MyCrush’. The table should consists of only three…

A: Please give positive ratings for my efforts. Thanks. ANSWER SQL Satements to create and insert…

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

Q1/ Consider the fruit database with fruit and market tables,
where the primary keys are underlined. Give an expression in
SQL for each of the following queries.
Fruit(ID, fruit_name, fruit_color, price_KG)
Market(market_name, city, street, fruit_name)
1- Find the names of all red fruits that has price less than 25 dinars.
2- Find the names of markets that sell banana in Atlanta city.
3- Find the name of fruits that has yellow color and sell in
Glasgow market

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

given a table Products with columns (id, name, price, QTY) and 2 records in the table, and rows with the following SQL display? productid, name from Products where 1=2;
(a) Write the sql syntax to create a table name Client with the following restrictions; Client(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “vacoas". client is at least 25 years old. Salary is above Rs 30000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the client table with the following data definition; (Column “gender" of char data type and field size of 1). ii. Using SQL, write the command to insert the values in the Client table. cid address age occupation salary Payment_mode gender cname 123 sam vacoas 31 manager 60000 cash m 124 david flacq 38 administrator 45000 credit m iii. Write the SQL query to display the cid of all employees. iv. Write the SQL code to list all administrators whose salary is greater than Rs…
Use the given database to output the results of the following SQL queries: For these queries you need the student, takes, section, and teaches tables. I gave you all the resources you need. a.) SELECT ∗FROM Student AS S, Takes AS TWHERE S.ID = T.ID AND T.semester = 'Fall'; b.) (SELECT S.course id, S.semester, S.yearFROM Section AS SWHERE S.room number = 101)INTERSECT(SELECT T.course id, T.semester, T.yearFROM Teaches AS TWHERE T.ID = 83821); c.) SELECT T.course idFROM takes AS TWHERE T.semester IN(SELECT Z.semesterFROM teaches AS ZWHERE Z.ID = 10101)ORT.semester IN(SELECT X.semesterFROM section AS XWHERE X.time slot id ='B');
4. This question continues from Q3. (a) Write the insert SQL to populate the Zoom, BB, and the QR tables with the values given below. For each table, use only one insert to complete the insert task. The Duration column is initially empty. (b) Can you insert the ZOOM table first? Provide a reason according to the relational database theory if it is not possible. (c) Write a Delete SQL to remove student ‘M M’ from the BB table. If it is not possible to remove the row, provide a reason according to the relational database theory. You must not use SID in the SQL because only the name is given. (d) Write an Update DML that will compute and update the duration in minutesin the Zoom table. Show the updated table and the DML.
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have not taken any courses. APPENDIX STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
use oracle sql developper or Oracle sql developper problem in picture the database CREATE TABLE MEMBERSHIP( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY,MEM_FNAME VARCHAR(30) NOT NULL,MEM_LNAME VARCHAR(30) NOT NULL,MEM_STREET VARCHAR(15),MEM_CITY VARCHAR(10),MEM_STATE CHAR(2),MEM_ZIP CHAR(5),MEM_BALANCE NUMBER (2)); ALTER TABLE MEMBERSHIPMODIFY MEM_STREET VARCHAR(25);CREATE TABLE RENTAL( RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENT_NUM_PK PRIMARY KEY,RENT_DATE DATE,MEM_NUM CHAR(3),CONSTRAINT RENTAL_MEM_NUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP); CREATE TABLE PRICE(PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICE_CODE_PK PRIMARY KEY,PRICE_DESC VARCHAR(20),PRICE_RENTFEE NUMBER (3,1),PRICE_DAILYATFEE NUMBER(3,1)); CREATE TABLE MOVIE(MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIE_NUM_PK PRIMARY KEY,MOVIE_NAME VARCHAR(30) NOT NULL,MOVIE_YEAR CHAR(4),MOVIE_COST NUMBER(5,2),MOVIE_GENRE VARCHAR(15),PRICE_CODE CHAR(1),CONSTRAINT MOVIE_PRICE_CODE_FK FOREIGN KEY (PRICE_CODE) REFERENCES…
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have taken courses in both the Computer Science and Mathematics departments. APPENDIX - You may detach this page from the exam: STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
Please show all work and write it in PL/SQL and copypaste what you have.