You must create an ER model for Upwork before forward engineering the database in MySQL. A database design project typically begins with requirements analysis to identify the business rules, entities, and relationships to form an ERD, which is then converted into a database.
You must create an ER model for Upwork before forward engineering the
Assumptions:
- A client/freelancer can sign up and create an account via email.
- A freelancer cannot be a client.
- Clients can leave feedback on the freelancers.
- The system should keep track of all bids for each project.
- The total bid amount can be calculated by assuming an 8-hour workday. [(freelance hourly rate * total number of days * 8) = Bid Amount] Other functionality not mentioned in the assumptions section is out of scope.
Hint:
How to get started:
- Writing down your design before implementing it in MySQL will help you better understand the relationships.
- Examine the screenshots provided to learn how the website works.
- Determine which entities are required and which may be required.
- Record attributes for each entity and identify functional dependencies.
- Determine the connections between entities. When writing the relationship statement, begin each sentence with one/each. For example: one/each department has many employees; one/each employee works for one department.
- Recognize cardinalities. You don't need to be concerned about the assignment's minimum cardinality. When the minimum cardinality or zero is used, the query joins become outer joins. We don't need to worry about the assignment's minimum cardinalities because our goal isn't to write queries to retrieve the data. - Use MySQL Workbench to implement the ER model.
- Create the physical database with MySQL Workbench's forward engineering feature.
- Fill each table with at least five records. This is required for the third task.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
