Question: Using the information from the provided screenshot please help complete the following ( this is not a class assignment this is a personal project that

Using the information from the provided screenshot please help complete the following (this is not a class assignment this is a personal project that I need help with) :
1.Goals: Clearly define the objectives of project.
2. Database Description: Provide a general description of the database, including the types of data stored and how the database will benefit its users.
3. Data Model & Design:
ER/EER Diagram: Create a complete ER/EER diagram with a minimum of five tables. Use draw.io to create the diagram and include a snapshot in the report.
Business Rules: Outline the business rules governing your database.
Data Dictionary: For each table, list the columns, data types, column restrictions, and descriptions.
Implementation:
1. Database Creation: Use MySQL Server and MySQL Workbench to create the database and tables.
SQL Code: Include a snapshot of the SQL code used to create the database and tables in your report.
Data Population: Populate each table with a minimum of 20 rows of sample data.
Ensure the data entered is descriptive, not just random numbers and letters.
SQL Queries: Write and run the following SQL queries using MySQL Server and MySQL Workbench. For each query, provide a snapshot of the code and the output, along with a brief explanation of what the query returns:
1 simple select query with ordering.
2 medium difficulty queries involving composite conditions, computations,
aggregate functions, and grouping.
1 subquery.
2 join queries (1 inner join, 1 left or right outer join).
1 view (query must use a join, hint: you can reuse one of the previous queries).
1 union query.
1 custom stored function.
1 custom stored procedure
Using the information from the provided

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!