Describe how you might redesign the database

Assignment Help PL-SQL Programming

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

Reference no: EM133369463

Questions Cloud

What led to the fall of absolute monarchies in england : What led to the fall of absolute monarchies in England? Think about how the events leading up to the Glorious Revolution challenged the power of absolute

What could have been some alternatives to this decision : Which amendment from the Bill of Rights does this case relate to and why? (It might be more than one amendment) What factors led up to the case?

Stress response do to human body : What does activation of the stress response do to the human body in the short - term versus long - term

What are some examples of symbolic interaction : What are some examples of symbolic Interaction? How do we interact using symbols? How does it positively or negatively affect us?

Describe how you might redesign the database : Write a query to show the restaurant count by cuisine type. Include the SQL query and the output as a screenshot - Describe how you might redesign the database

Maquiladoras negatively impacting mexican communities : How are maquiladoras negatively impacting Mexican communities?

Primarily white neighborhoods : Why do you think police officers are more likely to conduct drug raids in low-income, black neighborhoods than in wealthier, primarily white neighborhoods?

Describe what the office is and does why it is important : Describe what the office is and does. Why it is important not just to the state, but how it could affect you and your community. What powers does it have?

What colors do you see in this scene : What colors do you see in this scene? Where are you? Are you in a room or are you not in a room? What kind of place are you in?

User Account

All Pages