1. Use MySQL Workbench forward engineer tool (the tool is available in database pull down tab as shown below): Save the SQL generated by the Workbench as createMusicStore.sql (SQL DDL).

Include a statement to drop the database if it already exists. Include statements to create and use the database. Include statements to drop and create tables of the database. Include any foreign keys and indexes for each table. Specify the utf8 character set for all tables. Include a part of the script (i.e., createMusicStore.sql) in your report

i) Write SQL statements (i.e., insert statements) to populate database tables. Each table must have at least 3 tuples.

ii) Write SQL scripts to retrieve tuples of each table populated.

iii) Write a SQL script to retrieve music file names purchased by each customer