Show the restaurant name and rating

Assignment Help PL-SQL Programming

Reference no: EM133365108

Databases For Business Analytics Assignment

Populating and altering the tables

Part 1
After creating the Restaurants database with three tables, finish populating the Rating table with data.

• Include your SQL code for populating the table.
• Then, query the table to show all records. Take a screenshot of the result set and include it in your assignment.

Part 2
Alter your Restaurants table to include the street address, city, state, zip code, and status. Be sure to update your E-R UML diagram AND your data dictionary. Google to find the restaurant information and update each record. If the restaurant is still open, set the status to open. If it has closed down, set the status to closed. Include your SQL code and issue a query to show all records. Include a screenshot of the results set.

Part 3
• Create a view that shows just the restaurant name and average rating for open restaurants. Include your SQL code and issue a query to show all records. Include a screenshot of the results set.
• Join your Restaurant and Rating tables to show the restaurant name and rating. Include your SQL code and include a screenshot of the results set.

Reference no: EM133365108

Questions Cloud

What are benefits from collaboration : What are benefits from collaboration? The Teamwork video file identifies five stages of teamwork. Which is NOT one of the five stages?

What are your thoughts on gastrodiplomacy programs : What are your thoughts on Gastrodiplomacy programs? If you had to choose a food/meal to introduce your culture to someone else, what would you choose and why?

How communism and socialism differ : How Communism and Socialism Differ: Bothsocialismandcommunismare essentially economic philosophies advocating public rather than private ownership

Analyzing phillis wheatley faith as expressed : Analyzing Phillis Wheatley's faith as expressed in "A Hymn to the Evening" and "On Being Brought from Africa to America." Write as fully as time permits.

Show the restaurant name and rating : Databases For Business Analytics Assignment - Create a view that shows just the restaurant name and average rating for open restaurants. Include your SQL code

List three strengths in an essay in content, organization : List three strengths in an essay in content, organization, and/or development Let America be America again. List three aspects of the essay

Milestones vertically and project members horizontally : Some organizations use a chart that lists project tasks and milestones vertically and project members horizontally.

Provide an in-text or parenthetical citation psychologist : Write one sentence that paraphrases part of this sentence from Lauren Migliore's article, and provide an in-text or parenthetical citation: "Psychologist

What did it lead to and how did anger help bring that about : Thinking of Gay's quote above, tell me about a time you can think of when anger led to creation or advancement rather than the bad kind of destruction.

User Account

All Pages