Answered: List the name of any part that was not…

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

Question

//Need typed version please

You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project.

The schema for the database used in this question is as follows: ( primary keys are shown underlined, foreign keys in bold).

SUPPLIER (SNo, SupplierName, City)

PART (PNo, PartName, Weight)

PROJECT (JobNo, JobName, StartYear, Country)

SUPPLY (SNo, PNo, JobNo, Quantity)

Provide relational algebra (NOT SQL) queries to find the following information.

NOTE:

You can use the symbols s, P, etc or the words ‘PROJECT’, ‘RESTRICT’ etc .
do not need to try to make efficient queries – just correct ones.
Where you use a join, always show the join condition.

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.

Expert Solution