Rate this Solution

Question: Database Project You are the lead database engineer at a startup company. The company intends to …

Database ProjectYou are the lead database engineer at a startup company. The company intends to develop a web-based product similar to the Yelp website. The website will allow users to rank and comment on area businesses. Each business can be categorized under multiple categories. The rating scale is from 1-star to 5-star.As part of your lead role, you are initially responsible for meeting with the product engineers and gathering requirements. You are then scheduled to design the data model and implement a working prototype to demonstrate the validity of the data model. Your specific tasks are broken down as belowRequirements GatheringAs part of the requirements phase, develop a minimum of 10 business rules that apply to the website. Each business rule must be related to a data model feature and must be clearly demonstrated in the data model (developed in phase-2).[Deliverable: Word doc containing business rules]Database DesignDevelop a database model (ERD) based on the business rules developed in Phase-1. Use the Crow’s Foot notation, indicate all attributes, primary/foreign key relationships, cardinalities and relationship strengths.[Deliverable: ERD]ImplementationImplement the table structure based on the ERD developed in phase-2. Assume 10 businesses in a minimum of 3 cities and 15 users.Write the SQL code to create the needed tables. Ensure all primary keys, foreign keys and constraints are defined.After implementing the table structures, insert dummy data for 45 ratings.[Deliverable: Text file containing SQL statements]ValidationTo validate the data model you have developed in phase-3, you are asked to write some queries and verify the results with expected results.Write the SQL statements that provide the following information:List of all businesses with 4-star rating and aboveBusiness with most number of ratings in a particular cityCity with most number of businesses with 5-star ratingsUser with most number of ratingsList of all businesses with their ratings[Deliverable: Text file containing SQL statements]

Leave a Reply