rovide relational algebra (NOT SQL) queries to find the following information SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY (SNo, PNo, JobNo, Quantity) List the names of Suppliers who have supplied the Part with the name “Fufful Valve”. List the names of Projects that have had Parts supplied by “Insightly Co#” or a Supplier located in Dubai. List the details of any supplier who has supplied parts to a project that stared in 2020 and (the project is) located in Singapore. List the name of any part that was not used on a project that commenced in 2020.

rovide relational algebra (NOT SQL) queries to find the following information SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY (SNo, PNo, JobNo, Quantity) List the names of Suppliers who have supplied the Part with the name “Fufful Valve”. List the names of Projects that have had Parts supplied by “Insightly Co#” or a Supplier located in Dubai. List the details of any supplier who has supplied parts to a project that stared in 2020 and (the project is) located in Singapore. List the name of any part that was not used on a project that commenced in 2020.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter3: The Relational Database Model

Section: Chapter Questions

Problem 10P

See similar textbooks

Similar questions

student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) Write the following SQL query for the schema above: Print the name(s) and sid(s) of the student(s) enrolled in the most classes.
) Consider the following relations: BRANCH (branch_no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff_no, Fname, Lname. address, position, salary, branch_no) Create a database called company that has these tables or write the SQL command to create the database and the tables Write the following queries in SQL: 1. Find all the staffs name works in branches in Texas city. 2. List all stalf who their first name ends with 'sam' ordered by position. 3. Find all the staff names that works in branch 345. 4. delete all the data of the table BRANCH.
Provide relational algebra (NOT SQL) queries to find the following information SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY (SNo, PNo, JobNo, Quantity) List the quantity of parts supplied on JobNo 4745. List the name of any part that was not used on a project that commenced in 2020. List the name of any part that has been supplied to all projects that commenced in 2020.
In terms of the following relations: (Primary Key, Foreign Key) Student (StudentNumber, StudentName, CourseCode) Enrolment (StudentNumber, OfferingNumber) Offering (OfferingNumber, UnitCode, Semester, Year) Unit (UnitCode, Title) Course (CourseCode, CourseTitle) Formulate relational algebra (NOT SQL) expressions for each of the following: List the StudentNumber of the student with the name ‘Bob Builder’ List the StudentNumber of students who have taken ICT285 or ICT284 in 2020 List the StudentNumber of students who have taken ICT285 but not ICT284 in 2020 List the StudentNumber of any students who have taken ALL units offered in Trimester 2, 2020
Explain the SQL function categories. Describe the important features and applications of SQL functions. Normalize the relation given below OrderNum OrderDate PartNumber PartName UnitPrice PartQuantity SupplierNumber SupplierName SupllierStreet SupplierCity SupplierSate SupplierZip
Considering the attached E-R diagram; provide SQL statements for the following cases: Create above relations for the E-R diagram above After creating each relation, insert at least 6 rows (tuples) for each relation (table) with data that you invented SALE_ITEM relation should include at least two same SaleID Update a “Price” value of a row in the ITEM relation Updated ITEM (ItemID) should be in SALE_ITEM The solution should include screenshots of your relations with data. Discuss issues while solving the above problems and any assumptions that you made.
Consider the following schema and write the following queries in relational algebra. Product(pid, pname, pcolour, price, supplier, year_manufacture) Select the records where product is 'shoes'. Select the records where product colour is 'red' and 'price' is 450. 3. Select records from Product table where supplier is 'Davidson' and price is 500 or those products manufactured after 2018 . 4.Project the columns named as pid and supplier from the Product table.
Write SQL code for the following questions: Add a new table called SALES_YourFirstName. Please note that “YourFirstName” is your first name. this table should have a minimum of 4 attributes, with at least one foreign key. Write the code to delete the above table from the database. Show the age of the oldest employee. For each employee show their full name, start date, and the name of the department that they work for. Add a new product to the Products table. The product quantity must be in the range of 1-100. Show the name and email address for Suppliers that have “@money” in their email address. For each product that has a quantity less than 50, show its name, quantity, department name, and supplier name. Show a list of products ordered by quantity, from smallest to largest. Include only the product name and the quantity in stock. Prompt the user to enter a date and show the full name and DOB of employees born on that date. For each supplier, show the number of products that are…
Consider the following relations: BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff no, Fname, Lname. address, position, salary, branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area '34 east 2. Find staff whose salary is greater than the salary of evcry member of staff at branch 71. 3. List all stalf who their last name ends with ith'. 4. Find all the staff that works in branch 345 and have salary between 15000 and 45000.
Create tables for the following, where the first 2 are entity-types and the last one is relationship. Feel free to add additional fields that you think are appropriate.Course: courseNum, department, semester, maximumEnrolled Instructor: ssn, instructorid, firstName, lastName.Teaches: instructorid, courseNumPay special attention to assigning primary key and foreign key in each table and use appropriate data types.Print out the SQL commands that you use to create the tables.Then populate your tables with at least 2 rows each and print out the contents of each table with SELECT. (Include the content of the print-out in your homework).
Create tables for the following, where the first 2 are entity-types and the last one is relationship. Feel free to add additional fields that you think are appropriate.Course: courseNum, department, semester, maximumEnrolled Instructor: ssn, instructorid, firstName, lastName.Teaches: instructorid, courseNumPay special attention to assigning primary key and foreign key in each table and use appropriate data types.Print out the SQL commands that you use to create the tables.Then populate your tables with at least 2 rows each and print out the contents of each table with SELECT. (Include the content of the print-out in your homework). I want answers for this part Get to know the HR database, its tables, and their contents. Show the SQL query and the output.Use INNER JOIN for multiple table query.1- Display details of jobs where the minimum salary is greater than 10000.2- Display the first name and join date of the employees who joined between 2002 and2005.3- Display first name and join…
Using SQL data definition language, write the SQL statements to create each of the following relations. i. student(student id, name, dept id, total credits)ii. department(dept id, building, budget)iii. lecture_hall(hall id, campus, capacity)iv. course(course id, title, dept id, credits) v. takes(student id, course id, semester, year, grade)