Question: Question 4 (a) Write a SQL query to retrieve the van numbers, the makes and models and the mileages for those vans that are 'Mercedes'

Question 4 (a) Write a SQL query to retrieve the van

numbers, the makes and models and the mileages for those vans that

Question 4 (a) Write a SQL query to retrieve the van numbers, the makes and models and the mileages for those vans that are 'Mercedes' vans and that have more than 100000 miles on their counters. [08 Marks] (b) Write a SQL query that lists all the details of the FORD' vans that are owned by the 'IKEA company or the 'Argos' company. [10 Marks] (c) Explain the following Data Control Language (DCL) statement. GRANT SELECT, UPDATE (companyTelNo) ON Company TO Personnel; [02 Marks] -Signature... is shown on figure 1. Carefully consider this conceptual ERD and answer the questions below. Staff staffid[PK] staffFullName staffMobileNo {mandatory, and Van goes for Vehicle_Service undertakes Mechanic Driver vanNo{PK) vanNbPlate(AK) vanMakeModel van Mileage 1..1 0. serviceRefNo(PK) servStartDateTime 0.. servEndDate Time finalCost 1.1 expertiseLevel driving LicenseNo 1 1..1 {optional, or conducts owns Road_Test Standard Service Elite_Service includes 1..1 cleaning Product testRefNo(PK) testStartDateTime testendDate Time testLocation Company 1..1 0..1 0.. companyNo[PK] company Name company TelNo Figure 1: Conceptual ERD for the VinyVan van servicing management system

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!

(a) Write a SQL query to retrieve the van numbers, the makes and models and the mileages for those vans that are 'Mercedes' vans and that have more than 100000 miles on their counters. (b) Write a...

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

Create a query that retrieves total number of allergies per patient. Your query must display patient first and last names. Your output must resemble the one below Question 1 [05] Create a query that...

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

Use the Gauss-Jordan method to solve the following system of equations. Question list K 2x - 5y + 5z = 9 2x + 3y - 2z = 14 4x - 2y + 3z = 23 O Question 1 O Question 2 Select the correct choice below...

Discuss the essential differences between a traditional IRA and a Roth IRA.

1c) A different water filtration system design using an annular porous media is sketched in the figure below. The outer radius of the tank is 2.5m whereas the outer and inner diameters of the porous...

This pricing approach most closely describes: design a good product - > determine product costs - > set price based on cost Group of answer choices Point - of - view pricing Price skimming Cost -...

help with 15 15. Udon Inc. adopted dollar-value LIFO (DVL) as of January 1, 2018, when it had an inventory of $710,000. Its inventory as of December 31, 2018, was $904,800 at year-end costs and the...

3 Identify six potential sources and causes of risk in global supply chains. Use the reference to Peck (2003) below to propose counter measures.

1 Why is time important to competitive advantage? Identify and explain six key contributions that speed can make to logistics strategy.

2 What are the potential negatives of WDTs new JIT system in terms of limiting customer choice and short-circuiting the design process? Sid Beckett, the Managing Director of Wiltshire Distribution...