a. Database Development 3 marksDesign and build your database in MySQL using PhpMyAdmin. Your database should becreated on the Infotech server and be named with your username followed by Ass2 (eg:rmason10Ass3). Referential integrity and any other constraints must be created, asrequired by your design.Assignment 3 2016-S1 CSC00228 Database Systems 1 Page 4b. Database Design 3 marksChoice and consistency of table and attribute naming conventions used, selection ofdata types, primary and foreign keys.c. Sample Data 3 marksYou must provide enough valid data in your database to run the SQL queries belowsuccessfully with at least 5-10 resulting rows.d. Use of Views 1 markThe database should be capable of producing the query results below. To get therequired results, you may need to build underlying queries or views. Where appropriate,these views should incorporate the use of standard practical informative columnheadings that fit the expected use of the view.e. Export Script 1 markOnce your database is finalised, you must create an export script (.sql) to create abackup of all database structures, including table definitions and data. Name this SQLscript as yourusernameAss3.sql eg: rmason10Ass3.sql.f. Proof of Testing 1 markThe results of your queries should be presented in a Word document using a basicreport layout with a title page, page numbers etc. The query that you create for each ofthe parts below should be pasted into your report (not screenshots), followed by ascreenshot of your results. Snipping Tool on Windows is useful for taking screenshots ofquery results. This report is similar to that required for Assignment 2.g. SQL Queries:Important Note: your result sets should not display any 'extra' columns – such assurrogate keys. Use surrogate keys in your progressive testing by all means, but yourfinished test results should not include surrogate keys unless specified in the question.i. Club membership list 0.5 markCreate a club membership list for one of your clubs. Results should be sorted byfamily name of the member, and should include all contact details and clubposition status (eg: President, Vice President, Secretary or Treasurer, or null forordinary member).ii. Club members count 0.5 markCreate a query that counts the number of members in each club in theAssociation. Results should have the club name and the number of members,and be sorted by the number of members.iii. Owing memberships 1 markThe Association would like to identify members that have not paid their fullmembership fees. Assuming association fees are $100.00 per annum, create aquery that shows the club, member name, email address, contact number andamount paid for the year for all members that have not paid their full fees.iv. Regatta information 0.5 marksCreate a query that displays a list of Regattas, with the regatta name, date,place and organising club and contact member details including name and emailand phone number, sorted by date.Assignment 3 2016-S1 CSC00228 Database Systems 1 Page 5v. Race information 0.5 marksCreate a query that displays the list of races scheduled for one particularRegatta. Races should be sorted by heat and then race number, and display theregatta name, heat, race name and starting time.vi. Winner list 0.5 marksCreate a query to display the list of winners for each Regatta, showing Regattaname, Heat, Race number, Race name, winning club name and winning time,sorted by Regatta name, Heat and Race number.vii. Particular member race list 1 markCreate a query that displays a list of races in 2014 regattas for which LucasMorse (or use another name from your member data) was registered. Resultsshould be sorted by Regatta name, date and time and provide all detailsdisplayed on the race registration form.viii. Boats used in regattas 1 markCreate a query that displays a list of boats which were registered in races in2014, and calculate how many races each were registered in. Include and sortby club name and then boat name.ix. Qualification list 1.5 marksCreate a query to show a list of all association members who have coach orsweep qualifications. Your query results should be sorted by the club, then themember's last name and first name. You must include the following:• Club name;• Member's last name, first name, phone number;• Level of coach qualifications (if applicable) and date of certification;• Level of sweep qualifications (if applicable) and date of certification.x. Refresher Training list 1 markThe Association would like to offer refresher training to all coaches who werecertified more than 3 years ago. Create a query to show a list of these coaches,with their club name, coach name, contact details and date of last training.