Renaming the tables in database

[mgrabovac22]

One and only task is to rename the whole database to match the requirements:

It has to be on english and acording to some rules, like the tables should be in lower case and the words should be connected with the "_".

[mgrabovac22]

this is renamed database.

[mgrabovac22]

File that contains era diagram will be on discord!

[dljubas20]

users, shows and books are plural, but writer and movie are singular. Is there a reason to this? There is also an inconsistency in book_genres, genre_shows and genre_movies.

P.S. writer => authors.

[mgrabovac22]

Well, changing the name was a little tricky because of parenthing tables and all that but I will try to change the names of the tables and then in code, but I am not sure what you mean by inconsistency.

[dljubas20]

Instead of having book_genres, genre_shows and genre_movies, you could have book_genres, show_genres and movie_genres

[mgrabovac22]

now ok?

[dljubas20]

The attributes of your tables are still not complete. For example, "zanr" in show_genre_fk_table or writer" in book table and book_author_fk_table.

[mgrabovac22]

now ok?

[mgrabovac22]

I'll wait for this issue to be sorted out, before I continue DAO issue, because I wouldn't wanna do crossover work, if I change something here to change something there

[dljubas20]

It's ok now.

[mgrabovac22]

Finished!