Regarding the sample data, you must insert all of the data into your designed database.The sample data is a very small subset of a small industrial example. The full system has XXXXXXXXXXrows in some...

Regarding the sample data, you must insert all of the data into your designed database.The sample data is a very small subset of a small industrial example. The full system has 40 000-65000 rows in some data files which is actually not a large real world example. The Task does not prescribe how you do that (and you may do independent research to identify ways to efficiently do so). You can utilise Microsoft Excel and other tools to assist you so long as you submit sql insert statements that match your designed tables. You may use temporary tables within the database to convert the supplied data into your design. Look at online tools like sqlizer; however, it will not provide correct structure and datatypes and is only a stepping stone in the process. Mysql Workbench has an export function that may also assist here - it should be available on your system and is the database interface I requested be used for this course. Exporting/Inserting excel data into Mysql DB per Table, Steps 1. You must have excel with mysql option. A. Check does your excel sheet, contains mysql option, after selecting Data tab? If yes Then fine, you are ready to insert data. Then start reading from Step E. B. If NO then follow below link to install mysql for Excel, click on below download link. https://dev.mysql.com/downloads/windows/excel/ Then it will ask you to login or signup (DO NOT HAVE TO DO EITHER) UNDERNEATH you can see No thanks, select this option, then it starts downloading. C. Once its downloaded (MAKE SURE YOUR MICROSOFT EXCEL FILES ARE CLOSED), go to the downloaded folder and run, select all default choices it will take few mins time to install, once installed and finish. D. Open Excel sheet, and Check can you able to see mySql option, after selecting Data tab. E. Select option mySql, it will give small wizard select one of the option --> New Connection. F. Click on that option -> another pop wizard will appear on screen give meaningful Connection name at *Connection Name Field*. Do not have to set/change any other settings, click ok. (**BEFORE TO THE NEXT STEP Make sure your Wamp/Xampp are running, prior to this step, YOUR DATABASE IS READY WITH PRIOR CREATED ALL REQUIRED TABLES**). G. Now you can see your supplied connection name under Local Connections. H. Double click on YOUR connection name(At Step F) it will give List of databases(Which you created) select your DB from list, and then click on next -> now you can see tables inside that DB. I. select table which required to imported and then select Append Excel Data to Table --> gives popup window if your excel sheet have column names, Then check First Row Contains Column Names check box --> then select append. If everything is fine then Data will get inserted with a success message.