A relational database is created to store infor car is repaired by Each mechanic work database containing the following pieces of information: mation about car repairs. Each a mechanic; a mechanic can repair any number of cars. s on a number of jobs. These are stored in tables in the 4. Car: a unique 8 character reference number, a make, a model, a . telephone number of owner. Mechanic: a unique 5 character staff reference, a name. . . Job: a unique job reference, a job end date, the car, the mechanic. (a) Write SQL CREATE TABLE statements for these three tables. (8 mar (b) Write SQL statements to perform the following tasks: (i) Create a new entry in the mechanic table for "John Sparkie", staff number 12345 12 ma (ii) List the job name for all jobs being worked on by "John Smith". 3 ma (i) List the names of all the mechanics in the database, and beside each name give the number of jobs that they are working where the end date is on or before 1st January 2016. 3 ma (c) Consider the following table of mechanics consisting of four entries. 1234 John Smith 23456 'John Doe' 34567 John Smith 23456 'Richard Here' Correct the above table to make it a legal one. Note that there are many ways to make this a legal table. 14 m