Database Management ER Diagram and SQL workbench.

bishnu

Missingthings.docx

Home >Computer Science homework help >Database Management ER Diagram and SQL workbench.

The following things are missing.

The ER diagram should be drawn in this website https://www.draw.io

I need the snapshot of the query along with the result.

Example:

Graphical user interface, text, application Description automatically generated

I need the snapshot of the query as well.

1)Project goals.

2) Database description: A general description of the database, what data is stored in the database.

How the database will benefit the users.

ER/EER diagram, 8 tables

MUST use https://www.draw.io to draw the ER diagram, and then take a snapshot.

4) Implementation: o Use MySQL Server and MySQL Workbench to create the database/tables. Include a snapshot of the SQL code in your report

o Populate each table with a minimum of 20 rows of sample data. Make sure the entered data is descriptive (not just random numbers and letters. Include a snapshot of the SQL code in your report.

o Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For each query, provide the following in Report 2: Snapshot of the code and the output in the report. In about 2 lines, explain what the query returns.