Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

TASK 1. The required four tables, member, mechanic, app

Added on - 21 Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 3 of 7 pages
TASK 1The required four tables, member, mechanic, appointment and administration staff were createdsuccessfully.
TASK 2The data was populated in each of the four tables, as shown in below pictures –
TASK 3The relationships identified within the database are linked as follows –TASK 41.Find the first name, surname, suburb and phone of all the members who live in Lidcombe (donot show suburb in answer). Your query should arrange the data in ascending order ofsurname. Save the query as Suburb. Run the query. Take a screen print of the result and pasteit into the Word document.2.Find the first name and surname of all the members that live in a postcode that ends with thedigit “4”. Arrange the output of the query in descending order of first name. Save the queryas Postcode.
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document