Reference no: EM13327468
SQL (DDL)
a. Provide ALL of the SQL statements required to insert the details of the following: A customer, John Smith, of 47 Moodle Street, Highwater, WA, 6709, Australia (email: [email protected]) has sold a work of art called "Gorillas in the Mist" by the renowned French artist, Gallic Symbol (b. 1973) to the Gallery (i.e., the Gallery purchased it from him). It is a unique Watercolour on Paper and is 45 * 30cm signed by the Artist. The purchase price was $4500 and the transaction took place on 27th July 2013.
b. You have been given the following specifications of a simple database for a netball association that keeps record of players, teams and matches.
Give the SQL to create the Match table. You may assume that the Player and Team tables have already been created, and that the MatchID, PlayerID and TeamID colums are of the data type VARCHAR2(5). The result of the match refers to the result for the HomeTeam and can be only W, L or D (win, lose or draw).
c. Your match table must also include a column that records the scores of both teams in the match. Provide the SQL to amend the original table design to allow for this change in requirement. It is most unlikely (impossible) that a team would ever score more than 999 goals in a
match.
|
Define conceptual design
: Water meters must be replaced when they have been in use for 5 years. We can assume that a meter will never be damaged or become unserviceable and will not be re-assigned to another service address.
|
|
Find the magnitude of the average force of the wall on ball
: A tennis ball (m = 0.2 kg) is thrown at a brick wall. It is traveling horizontally at 16 m/s just before hitting the wall, find the magnitude of the average force of the wall on the ball
|
|
How would you change the current design
: How would you change the current design and how does your new design address the problems you have identified with the current design.
|
|
What is the range of the baseball
: A baseball thrown off a pedestrian pathway, 36 m above the Erie Canal, What is the range of the baseball
|
|
Provide the sql to amend the original table design
: You have been given the following specifications of a simple database for a netball association that keeps record of players, teams and matches.
|
|
What is its recoil speed
: A .30-06 rifle fires a bullet with a mass of 10 g at a velocity of 800 m/s. If the rifle has a mass of 4 kg, what is its recoil speed
|
|
List the sales for each customer
: Each query is worth 2 marks. These tables exist in sphinx and are owned by the user dtoohey. You may, if you wish, create your own copies of the tables under your own account. If you do so, you should ensure that you copy the sample data in dtoohe..
|
|
Problem on relational algebra
: The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)
|
|
Define relational database design
: List the details of any works of art (including the Artist who created the work) that have more than one copy recorded in the database.
|