04) By Using the following schema, answer the following SQL queries and commands: Product(P_code,P_name, P_price, P_on_hand,vend_code) Vender(vend_code, vend_fname, vend areacode, vend_phone) 1- find the venders names who sell products in TN-5 area and their names include "dan". 2- find the code, name and vender code of product that has price between 1500$ and 2500$ and the product that has price between 4800$ and 5600$. 3- Find the name, and code of venders who had 5 microwaves that has price less than 3500$.

Q: a) Write SQL queries for the following. 1) Display details of those patients whose age is either 25…

A: Structured Query Language (SQL) is an acronym for Structured Query Language. It is a language that…

Q: Given the following relational schema (Hint: the bold text represents a primary key), Department…

A: From the above question, we have the condition as ,dept_code and stu_num are primary keys that means…

Q: (a) Write the sql syntax to create a table name customer with the following restrictions;…

A: A) create table customer(cid varchar(50) primary key,cname varchar(50) not null,address varchar(100)…

Q: (a) Write the sql syntax to create a table name customer with the following restrictions;…

A: SQL Query for create table ;-  CREATE TABLE customer (                                           cid…

Q: 28. Show the employee name and the employee job title by the same field give the field new name.…

A: As per Q and A guidelines, we are only allowed to solve 1 question, so solving Q8. only. Please post…

Q: Write your SQL syntax solution to return the information needed to complete each of the following…

A: 1. Answer: Select category.name,rental_duration,max(length) from film join film_category using…

Q: Consider the following tables: Employee (Emp_no primary key, Name, Emp_city, Company_name, Salary)…

A: table creation syntax:-  create table tableName(columnName datatype(size) ); use like operator to…

Q: Consider the following schema(keys are underline);  Product(pid,name,type,manufacturer,price),…

A: Answer (a) Query 1 - Relational Algebra π cname σ manufacturer = 'sears' Customer ⨝ Customer.cid =…

Q: SQL - Enter and run your own SELECT statements In these exercises, you’ll enter and run your own…

A: We have given a SQL script and we need to run it in our own way that can save time and remove all…

Q: Consider the following SQL queries. Now, translate these queries into an equivalent Relational…

A:

Q: Ex 5) Write SQL statement to retrieve the names of all students who took both sections 112 and 119.…

A: A query is a question or inquiry about a set of data.

Q: Consider the following schema(keys are underline);  Product(pid,name,type,manufacturer,price),…

A: Given Tables : Product(pid,name,type,manufacturer,price) Buys(cid,pid)…

Q: a) Consider the following tables: Employee (Emp_no, Name, Emp_city, Company_name, Salary) i. a)…

A: Since there are multiple questions asked in the same query so we will be answering the first three…

Q: Q.      With respect to this relative schema, write SQL statements for the subsequent queries:…

A: Given: Q.      With respect to this relative schema, write SQL statements for the subsequent…

Q: Enroll(SIN: Integer, CID: String, Term: String, Grade: Integer); Teaches(CID: String, Term: String,…

A: Constraints are the rules enforced on the data columns of a table. These are used to limit the type…

Q: Consider the following tables: Employee (Emp_no primary key, Name, Emp_city, Company_name, Salary)…

A: The table is created by using CREATE TABLE command and followed by the table name. This will create…

Q: onsider the following schema: Course(CID, CName, Semester, Credit, Year). Convert the following SQL…

A: Answer :  Here we have Create Table table name is Course and we have set value by own if you want…

Q: Consider the following schema (keys are underlined): Product(pid , name, type, manufacturer, price),…

A: Given:-

Q: Write the appropriate SQL query for each of the following questions:  A) Display ALL the activities…

A: The given problem is related to database SQL queries where the tables are given and requirement is…

Q: 51. The given SQL statement is intended to either (1) list the customer numbers, customers names,…

A: Given SQL query: SELECT CUSTNUM, CUSTNAME, HQCITY FROM CUSTOMER WHERE HQCITY= 'Los Angeles' Given 2…

Q: consider the following schema: Product(pid, name, type, manufacturer, price) Buys(cid, pid)…

A: Product(pid, name, type, manufacturer, price) Buys(cid, pid) Customer(cid, cname, age, gender)…

Q: rovide relational algebra (NOT SQL) queries to find the following information SUPPLIER (SNo,…

A: According to the question below the Solution:

Q: onsider the following schema: Product(pid, name, type, manufacturer, price), Buys(cid, pid),…

A: a) relational algebra:  π cname σ manufacturer = 'sears' Customer ⨝ Customer.cid = Buys.cid Buys ⨝…

Q: Based on the following ER Model, write SQL statements to create the tables. USING SQL NOT MYSQL…

A: A relational database contains tables also known as relations. A relation contains tuples and…

Q: Need this code in PL/SQL for Procedures and Functions, URGENT!! Feature 10: Print out names, phone…

A: I am doing this project in SQL Language The column name I have taken is People name: name People…

Q: consider the following schema: Product(pid, name, type, manufacturer, price) Buys(cid, pid)…

A: PART 1:- The names of all customers who have purchased all products manufactured by sears in…

Q: (a) Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary…

A: Answer to the above question is in step2.

Q: Display all patients that have been treated by ‘Filling and Repairs’ and ‘Teeth Cleaning’.Use the IN…

A: Given that Display all patients that have been treated by ‘Filling and Repairs’ and ‘Teeth…

Q: The following two SQL queries attempt to find the names of sailors with higher ranking and less than…

A: Given two SQL queries attempt to find the names of sailors with higher ranking and less than 25…

Q: 1) The difference between PH 2) In SQL DB, the two fu are..... and 3) Create a variable called car

A: .

Q: using sql develpper or sql live oralce Create the DONORS table with the following columns:…

A: As per our company guidelines we are supposed to answer ?️only first 3️⃣ sub-parts. Kindly repost…

Q: 5.4 The following two SQL queries attempt to find the names of sailors with higher ranking and less…

A: The question is to answer two SQL queries.

Q: questions. Write the SQL code to enter the rows shown in the following Figure inside the table…

A: SQL statements are written for MySQL or Oracle database.   b. Inserting values into table EMP_1…

Q: Assume that you have following database relations. BIIT_Student ( CNIC, sName, sAge, sCity,…

A: 1. Display all CNIC numbers of BIIT students and NUST students. CNIC number must not repeat. Syntax:…

Q: Question No. 4:…

A: 1-Display names of all those students who have "A" grades: We must join Student to display student…

Q: QUESTION 2. Write a PL/SQL PROCEDURE that can list the Top-N customers (id and name) and the amounts…

A: ANSWER: PL/SQL Procedure:

Q: Write the syntax to create a table named Product in SQL with the following restrictions;…

A: According to the question below the Solution:

Q: 2. Write a SQL query to solve Question-2-2 (the second sub-question). 3. Write a SQL query to solve…

A: Answer: Looking up for the rating of a sailor using his/he need creating a clustered index in the…

Q: Question 5: (Question that needs to be done) Assuming the current semester is semester 1 2020:…

A: SQL query  to write : To retrieve the list subjects and their names that each student is enrolled in…

Q: Please help with this SQL assignment: Use simple example of an EXCEPT expression. No correlated…

A: Except meaning in general is  A={4,5,7,8} B={7,8} A except B= {4,5} Set of values which are not in B…

Q: 1 (a) Write two equivalent relational algebra for the following SQL: SELECT ENAME, BUDGET FROM EMP,…

A: First, the flow-structure of queries that are listed after that.

Q: a. Describe the important features and applications of SQL functions  b. Explain the SQL function…

A: A. Features and Application of SQL functions: Features: 1. Easy to implement, because they use a…