Project 2

Q.NO.1

• First I right click on the graphical interface, then I select create schema and given apply

Q.NO.2

• I right click on the ecommerce, then table data import
• Then I choose the path file and select the option drop table if exists
• Then clicking next,next and Then finish.

Q.NO.3

• I first Selected the Database ecommerce by USE command
• Then, I use DESC command to see the structure of the table.

Q.NO.4

• Then I use the test cursor to execute the select statements and by using the limit it displays first 1000 rows.
• Then printing the statement.

Q.NO.5

• I open excel and in the data tab select mysql and open the datatbase in the excel.
• I have selected the respective tables and click the Import mysql data and provide the checkbox add LIMIT 1500.

Q.NO.6 - Q.NO.11

• I have created the views and by using Not null function I have cleaned the data and stored in that views.

Q.NO.12

• I have created procedure and by using the LOWER() command to perform the lower_case for the name, fathername, mothername.

Q.NO.13

• I have selected the respective tables and click the Import mysql data and provide the checkbox add pivot table.
• Then I select loaction to make a pivot chart.

Q.NO.14

• I have created the procedure and given the parameter then I use begin to start
• Then I declare the list to store the names in COLLEGE A and I open cursor as per given name
• Then I open cursor and by using the Loop statement to fetch the details as shown in the figure
• I have set the fieldname and concatenate the values.
• Then I call the stored procedure and using Select statement to fetch the data as shown in the given question.

Q.NO.15

• I have created the procedure and given the parameter then I use begin to start
• Then I declare the list to store the names in COLLEGE B and I open cursor as per given name
• Then I open cursor and by using the Loop statement to fetch the details as shown in the figure
• I have set the fieldname and concatenate the values.
• Then I call the stored procedure and using Select statement to fetch the data as shown in the given question.

Q.NO.16

• I use subquery and Union function to perform the percentage of the career choice.