SQL database design and modeling

[PabloEmidio]

Modeling the database and how it will work

to know: this isn't a coding task, but a concept and planning task

[PabloEmidio]

The main database server will be MySQL

[PabloEmidio]

First data modeling proposition.

[PabloEmidio]

Review tasks

• [x] Assert that this model satisfies project needs
• [x] Check table and column name
• [x] Check relationship proposition
• [x] Check how queries are going work on that model

[PabloEmidio]

data modeling proposition after relationships and name first review.

[PabloEmidio]

sql files to test creation, insert and select:

• create_sample.txt
• insert_sample_datas.txt
• query_sample_data.txt

copy theirs contents and paster into SQL client.