Reference no: EM133369463
Databases For Business Analytics Assignment
Assignment
Use the Michelin one-star rated restaurant data set from Kaggle. Download the one-star- michelin-restaurants.csv file. Please open the file in Excel and examine it. Then complete the following and provide answers for each step.
Step 1. Format the columns to ensure it has the fields required for the Restaurant table. Be sure to pay attention to those fields that are NOT NULL. You have two choices:
Choice A: Add data for those fields per record. Choice B: Alter the table to eliminate the column constraint. If you selected CHOICE A: Include a screenshot of the formatted Excel document to show the data added.
Here is an example of how to modify a column constraint on an existing table:
Step 2. Use Excel to omit any records for restaurants not in New York City (You can do this by filtering the data).
Save the file in Excel as a .csv file with utf-8 encoding. This file you save will likely need to be converted from a utf-8 with BOM encoding to utf-8. You use a text editor like BBEdit (on Mac) or Notebook++ (on PC). Use either of these programs to save it in a utf-8 only encoding.
Step 3. Use BBEdit or Notepad++ to modify the restaurant names that include unknown characters. For example, Le Grill de Jo*l Robuchon should be renamed to Le Grill de Joel Robuchon. At least 5 or so places where this data needs to be edited.
Include a screenshot of your formatted restaurant names.
Step 4. Insert the records into the Restaurant table using the Table Data Import Wizard in MySQLWork- Bench. Write a query to show the new records in the Restaurant table. Include the SQL query and the output as a screenshot.
Step 5. Write a query to show the restaurant count by cuisine type. Include the SQL query and the output as a screenshot.
Step 6. Describe how you might redesign the database to accommodate different star ratings, such as 1-5 stars versus Michelin stars.
Attachment:- one-star-michelin-restaurants.rar