Question: Write SQL Query. PART B 10 MARKS STRUCTURED QUERY LANGUAGE QUESTIONS Answer ALL questions from this part. Each question is worth two (2) marks (5

Write SQL Query.

Write SQL Query. PART B 10 MARKS STRUCTURED QUERY LANGUAGE QUESTIONS Answer

ALL questions from this part. Each question is worth two (2) marks

(5 x 2-10marks) TABLES Share(Code, ShareName, ShareRegistryName) Foreign key ShareRegistryName references ShareRegistry

ShareRegistry (ShareRegistryName, ContactNumber) ShareTrade (Orderld.OrderDate,OrderType,Code, OrderedQuantity,OrderedPrice BrokeragelD) Foreign key Code references Share

PART B 10 MARKS STRUCTURED QUERY LANGUAGE QUESTIONS Answer ALL questions from this part. Each question is worth two (2) marks (5 x 2-10marks) TABLES Share(Code, ShareName, ShareRegistryName) Foreign key ShareRegistryName references ShareRegistry ShareRegistry (ShareRegistryName, ContactNumber) ShareTrade (Orderld.OrderDate,OrderType,Code, OrderedQuantity,OrderedPrice BrokeragelD) Foreign key Code references Share Foreign key Brokerageld references Brokerage Brokerage (BrokeragelD, BrokerageRatePercent) Share Code ShareName ShareRegistryName A2M The A2 milk company Link Market services AGL AGL Energy Limited Link Market services BHP BHP Billiton Limited Computer Share CSL CSL Limited Computer Share RIO RIO Tinto Limited omputer Share ShareRegistry ShareRegistryName ContactNumber Computer Share 1300787272 Link Market services 130055 Page 5 7

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!

Construct a simple MAC code, and apply it to the driven lid cavity problem described in Chapter 10.As a consideration staff part, I encourage him to hold patient to the extensive variety of different...

The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

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...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

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...

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...

You have been provided with the description of a programming language, J, intended for scripting applications. Its syntax is similar to a cut-down version of Java in that it consists of function...

Manoj gives 10% of his money to his eldest son, 20% of the remaining to his youngest son, 15% of the remaining to a school for poor boys. Still he has Rs. 1224. Find his total sum. 1. Rs. 1500 2. Rs....

The horizontal platform ABCD weighs 60 lb and supports a 240-lb load at its center. The platform is normally held in position by hinges at A and B and by braces CE and DE. If brace DE is removed,...

5 . ( LO 3 ) At the conclusion of the audit, the wrap - up process involves all of the following except: review of proper and complete execution of planned audit procedures. determination that all...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Why is there so much advertising in monopolistic competition and oligopoly? How does such advertising help consumers and promote efficiency? Why might it be excessive at times?

LAST WORD How was De Beers able to control the world price of diamonds over the past several decades even though it produced only 45 percent of the diamonds? What factors ended its monopoly? What is...

KEY QUESTION Explain the general meaning of the following profit payoff matrix for oligopolists C and D. All profit figures are in thousands. a. Use the payoff matrix to explain the mutual...