Create a database in MySQL

A) Create a new database and import the above datasets in MYSQL.

B) Visualize the dataset in MySQL so that you can view their actual column names in the first row (You may write the names of the columns in a piece pf paper).

C) By implementing SQL queries Change  col 1, col 2, col 2 to their actual column names.

 D) Take screenshots of the query and the tables with their newly created columns, upload

E) From the diabetes column show the Glucose column having the entries greater than 125 and the age column having the less than 50

F) Inner join chol column of heart and BloodPressure of diabetes

G) Take BMI column of diabetes and age from heart union the columns and order them by BMI.

Take the screenshots of E, F and G queries and their outcomes and upload.

  

heart.csv 21:198:288:01 INTENSIVE PROGRAMING Quizzes Final Exam age SASHEGRGSGR2322%STAKRABANGSAGHERRDEG 52 53 70 61 62 58 58 55 46 54 71 43 34 51 52 34 51 54 50 58 60 67 45 63 42 61 44 58 56 55 44 50 57 70 50 46 rutgers.instructure.com 51 sex 1 1 1 1 0 1 1 1 1 0 1 1 0 0 1 0 1 1 0 1 0 0 0 1 0 1 0 1 0 1 1 1 1 1 trestbps chol 125 140 145 148 138 100 114 160 120 122 112 132 118 140 128 118 140 124 120 140 140 106 104 135 120 145 130 136 130 180 120 120 130 160 129 150 125 400 212 203 174 203 294 248 318 289 249 286 149 341 210 298 204 210 308 266 244 211 185 223 208 252 209 307 233 319 256 327 169 244 131 269 196 231 213 071 10 Download O + ATS Canvas Support i Info ZOOM + X Close