Question: Give Tutorial d formulations for the following updates to the suppliers-parts-projects data-base; (a) Insert a new shipment with supplier number S1, part number P1, project

Give Tutorial d formulations for the following updates to the suppliers-parts-projects data-base;
(a) Insert a new shipment with supplier number S1, part number P1, project number J2, quantity 500.
(b) Insert a new supplier S10 into table s (the name and city are Smith and New York, respectively; the status is not yet known).
(c) Delete all blue parts.
(d) Delete all projects for which there are no shipments.
(e) Change the color of all red parts to orange.
(f) Replace all appearances of supplier number S1 by appearances of supplier number S9 instead.

Step by Step Solution

★★★★★

3.38 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a INSERT SPJ RELATION TUPLE S SS1 P PP1 J JJ2 QTY500 b INSERT S RELATION TUPL... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

CS-DB (48).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Give SQL formulations for the following updates to the suppliers parts projects database: a. Insert a new supplier S10 into table S (the name and city are Smith and New York respectively; the status...

A chilled orange juice ware-housing operation in New York City was experiencing too many out-of-stock situations with its 96-ounce containers. To better understand current and future demand for this...

Red Corporation, which owns stock in Blue Corporation, had a net operating income of $400,000 for the year. Blue pays Red a dividend of$60,000. Red takes a dividends received deduction of $48,000....

Solve Ex 4.1 4.1 Fig. 4.5 shows some sample data values for an extended form of the suppliers-and base called the suppliers-parts-projects database. Suppliers (S), parts (P), and projects uniquely...

Need help with the transaction set. Journal & ledgers ASAP OPERATING INSTRUCTIONS Introduction After you register for Seaside Marina, you will receive an email from Ivy Software containing three...

Questions: Assume a period of time has passed. Can you Assess your communication/education plan. Has the plan been implemented as specified? Have the objectives of the plan been achieved? How have...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

1.) Please write a SELECT STATEMENT FOR each of the following queries. a.) Get the total number of projects supplied by supplier S1. b.) Get the total quantity of part1 supplied by supplier 1, and...

1 Math 133 Project #1: Descriptive Statistics You will use GapMinder.org to access data for the purpose of exploring descriptive statistics and graphs with Microsoft Excel. The entire assignment is...

1.1 Convert the following ER diagram into relational model. The referential integrity constraints must be identified in the relational model. Name SECRETARY D.O.B. Department Salary EMPLOYEE ISA...

Why can a decrease in tax rates increase AS as well as AD, whereas an increase in government purchases will increase AD but not AS?

True or False? Bankers acceptances are short-term debt securities issued by large firms that are guaranteed by the issuing firm.

The switch in Figure P32.23 is open for t 4,00 8.00 0.0 V 4.00 1.00 H

A typical light dimmer used to dim the stage lights in a theater consists of a variable inductor L (whose inductance is adjustable between zero and L max) connected in series with a lightbulb B, as...

An ac generator with emf = m sin w d t, where m = 25.0 V and w d = 377 rad/s, is connected to a 4.15F capacitor. (a) What is the maximum value of the current? (b) When the current is a maximum,...

Why is manufacturing overhead considered an indirect cost of a unit of product?

(Postretirement Benefit Worksheet) Using the information in *E20-22, prepare a worksheet inserting January 1, 2010, balances, showing December 31, 2010, balances, and the journal entry recording...

If you observed a country with a rapidly growing trade surplus over a period of a year or so, would you be more likely to believe that the country's economy was in a period of recession or of rapid...

Daily Enterprises is purchasing a $9,000,000 machine. The machine will depreciated using straight-line depreciation over its 7 year life and will have no salvage value. The machine will generate...

The risk-free rate r F is 4%. The market risk premium (E[r M ]-r F ) is 6%. According to the CAPM, the Expected Return on Stock with the beta of is A 1.10 E[r A ] = #38 % B 0.90 E[r B ] = #39 % In...

Intro You have $190,000. Below are quotes for the Japanese yen from two banks: Bank Bid Ask Alpha Bank $0.00929 $0.00932 Delta Bank $0.00935 $0.0094 Attempt 1/10 for 10 pts. Part 1 How many yen can...