ER diagram for sql_story

SQL
1

I am doing the SQL course so I would like to inform you only if i can have (sql_story) ER diagram or a diagram for it.
BEST REGARD

2

Is it sql_store you are referring to?
If so I’m pretty sure you can reverse engineer the database in MySQL workbench and it will produce the ER diagram.

3

Hi Sir exactly I meant ‘sql_store’ + 'payment & payment methods ’
I am just a beginner now I am in “Retrieving Data From Multiple Tables” from the course
So I wanna make it my project for college that’s why I need it er diagram or whatever diagram I find from you. THANKS IN ADVANCE.
best regards

4

payments & payment methods are tables in the sql_invoicing database
So in MySQL workbench hit ctrl + r or select database → reverse engineer → select…next & then next again → Then select the databases you want (sql_store & sql_invoicing) and that should produce and ER diagram for the selected databases

1 Like
5

thanks a bunch, Sir…