Design a database table named that would allow an application that uses it to find restaurants and a table named that would hold reviews for any restaurant. Table structure Decide what fields and data types are necessary for the table. Bear in mind that the application must be able to filter restaurants by... - Category (i.e. genre of food) - Price tier (i.e cheap, medium, or expensive) - Neighborhood (a particular NYC neighborhood) - Opening hours (for simplicity, you can assume each restaurant has the same opening hours every day) - Average rating (out of 5 stars) - Good for kids (true or false) The application must also be able to allow users to leave reviews associated with any restaurant. Write the SQL commands to create the tables with the structure you determine is necessary. Practice data Insert realistic-looking dummy data for one thousand restaurants. Use mockaroo.com - a tool for generating mock data - helpful. A few non-obvious notes about Mockaroo: - Mockaroo's Row Number field type can be used to generate primary key numbers. - Mockaroo's Time field type can generate times in 24 hour format which is useful for generating opening/closing times necessary for restaurant data in this assignment. - Mockaroo's Custom List field type can randomly pick from a list of values you enter. This can be useful for randomly picking from a set of NYC neighborhood names for any restaurant. Include the practice data in a CSV file named in the directory named Write the SQLite commands necessary to import the data. Write a single SQL query to perform each of the following tasks: 1. Find all cheap restaurants in a particular neighborhood (pick any neighborhood as an example). 2. Find all restaurants in a particular genre (pick any genre as an example) with 3 stars or more, ordered by the number of stars in descending order. 3. Find all restaurants that are open now (see hint below). 4. Leave a review for a restaurant (pick any restaurant as an example). 5. Delete all restaurants that are not good for kids. 6. Find the number of restaurants in each NYC neighborhood. Hint The following SQLite code returns the current time of the day in 24 hour format UTC time - this may be useful in determining whether a given restaurant is currently open or not To see the return value of this command directly (not as part of a comparison operation), use the following syntax: strftime( 'H