Question: Write SQL statements for those queries; using attached S-SP-P relations [each 2 marks except last one which is 1 marks, total 7]: 1. Insert a

$Insert a new row in the parts (P) table PART\# =P7 part$

Write SQL statements for those queries; using attached S-SP-P relations [each 2 marks except last one which is 1 marks, total 7]: 1. Insert a new row in the parts (P) table PART\# =P7 part name = NUT part colour = blue part weight =15 part stored in Berlin 2. Get all the information in P table [ 1 marks] 3. Get part names for parts stored in "Berlin" 4. List part numbers stored in unknown location . Tables (S-SP-P) Supplier (S) \begin{tabular}{|l|l|l|} \hline S\# & P\# & Qty \\ \hline S1 & P1 & 300 \\ \hline S1 & P2 & 200 \\ \hline S1 & P3 & 400 \\ \hline S1 & P4 & 200 \\ \hline S1 & P5 & 100 \\ \hline S1 & P6 & 100 \\ \hline S2 & P1 & 300 \\ \hline S2 & P2 & 400 \\ \hline S3 & P2 & 200 \\ \hline S4 & P2 & 200 \\ \hline S4 & P4 & 300 \\ \hline S4 & P5 & 400 \\ \hline SP & & \\ \hline \end{tabular} Parts (P)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

Learning Objectives: Learn to define constraints on tables Lean to define primary keys and foreign keys Exercise In Lab 09, we will continue the practice of creating tables. You will need to write...

Refer to Table 1. Write the Excel formula for each cell marked with ? in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without...

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Database for the "Online Movies and download " Pty Ltd Objectives of the unit: Demonstrate evidence of the knowledge set and skill set required by the database designer Assignment Tasks: Read the...

Question 1 Construct an entity relationship diagram ( ERD ) for the following situation. [ 1 5 marks ] A person may own any number of cars, including noneEach car has exactly one ownerEach car must...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

The escape speed from the Earth is 1.12 X 104m/s, so gas molecule travelling away from Earth near the outer boundary of the Earths atmosphere would, at this speed, be able to escape from the Earths...

When observed data are used to develop the prior distribution in Bayesian procedures, the methods are often referred to as empirical Bayes methods. These methods are in contrast to standard Bayesian...

Consider the following historical performance data for A portfolios, the Standiard Consider the following historical performance data for A portfolios, the Standiard

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

KEY QUESTION Assuming the level of investment is $16 billion and independent of the level of total output, complete the accompanying table and determine the equilibrium levels of output and...

KEY QUESTION Assume there are no investment projects in the economy that yield an expected rate of return of 25 percent or more. But suppose there are $10 billion of investment projects yielding...

KEY QUESTION Why do economists include only final goods in measuring GDP for a particular year? Why dont they include the value of the stocks and bonds bought and sold? Why dont they include the...