Expert answer:basic sqlplus assignment
Expert answer:Please follow the instruction attached belowShould be simple and entry level assignment
itd.docx
Unformatted Attachment Preview
Database Project (200 points)
You are the lead database engineer at a startup company. The company intends to develop a webbased 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 1star 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 below
Phase 1 – Requirements Gathering (50 points)
As 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]
Phase 2 – Database Design (50 points)
Develop 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]
Phase 3 – Implementation (50 points)
Implement the table structure based on the ERD developed in phase-2. Assume 10 businesses in a
minimum of 3 cities and 15 users.
1. Write the SQL code to create the needed tables. Ensure all primary keys, foreign keys and
constraints are defined.
2. After implementing the table structures, insert dummy data for 45 ratings.
[Deliverable: Text file containing SQL statements]
Phase 4 – Validation (50 points)
To 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 above
Business with most number of ratings in a particular city
City with most number of businesses with 5-star ratings
User with most number of ratings
List of all businesses with their ratings
[Deliverable: Text file containing SQL statements]
Submission Instructions
All deliverables must be combined and submitted as a single zip file on Blackboard. The SQL file must
be in plain text format (filename with .sql extension).
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades