movies database design ...
<br> I am designing a movies management database. Each movie can have one or more producers , directors and many actors.<br> What would be a good design?<br><br><b>
What I have done initially is :</b><br><br>
I have <b>6</b>  tables that are <b>movies,producers,directors,actors,albums,songs</b><br><br>
movies table with movie_id,title,date_released columns<br>
A producers table with producer_id,producer_name,producer_age,movie_id(foreign key) columns
and similar table columns for directors and actors.<br>
An album table with album_id,title,year,movie_id<br>
A songs table with songs_id,album_id,singer,writer.<br><br>
<b>
The design seems to me very bad. How can I make it good ?
</b>
movies database design ...
===

<br> I am designing a movies management database. Each movie can have one or more producers , directors and many actors.<br> What would be a good design?<br><br><b>
What I have done initially is :</b><br><br>
I have <b>6</b>  tables that are <b>movies,producers,directors,actors,albums,songs</b><br><br>
movies table with movie_id,title,date_released columns<br>
A producers table with producer_id,producer_name,producer_age,movie_id(foreign key) columns
and similar table columns for directors and actors.<br>
An album table with album_id,title,year,movie_id<br>
A songs table with songs_id,album_id,singer,writer.<br><br>
<b>
The design seems to me very bad. How can I make it good ?
</b>