Create Mysql Music Database Help
-
Hi, I am going to create a database in MySql to show the information on the website page. I have data in my excel sheet it is related to Bollywood Movies / Songs. Excel Sheet coloum details : Songs Title, Movie Name, Year, Singer, Music Director, Lyrics, Picturised, Actors, Banner, Producer, Director, Music Company. I have Posters of Movies, pictures of all actors, Music directors, Singers etc. Now my question is : How can I design the database to show the record on the page. 1. If any user click on the particular Movie the table should show the details are : Song title | Singer | Music Director | Lyrics | Picturised Poster of the movie will show on left / right side of the same page 2. If any user click on the particular singer the table should show the singer's filmography details are : Movie | Year | Music Director | Music Company 3. If any user click on the particular Movie the point no. 1 will be repeat 4. If any user click on the particular Music Director the table should show the Music Director's filmography details are : Movie | Year | Director | Music Company 5. If any user click on the particular Movie the point no. 1 will be repeat it will be same for any actor, Music Director, Lyrics, Director, Banner etc.. ===== How many tables should I make and the table structure with primary / foreign key info for above said. Thanks in advance Muveen
-
Hi, I am going to create a database in MySql to show the information on the website page. I have data in my excel sheet it is related to Bollywood Movies / Songs. Excel Sheet coloum details : Songs Title, Movie Name, Year, Singer, Music Director, Lyrics, Picturised, Actors, Banner, Producer, Director, Music Company. I have Posters of Movies, pictures of all actors, Music directors, Singers etc. Now my question is : How can I design the database to show the record on the page. 1. If any user click on the particular Movie the table should show the details are : Song title | Singer | Music Director | Lyrics | Picturised Poster of the movie will show on left / right side of the same page 2. If any user click on the particular singer the table should show the singer's filmography details are : Movie | Year | Music Director | Music Company 3. If any user click on the particular Movie the point no. 1 will be repeat 4. If any user click on the particular Music Director the table should show the Music Director's filmography details are : Movie | Year | Director | Music Company 5. If any user click on the particular Movie the point no. 1 will be repeat it will be same for any actor, Music Director, Lyrics, Director, Banner etc.. ===== How many tables should I make and the table structure with primary / foreign key info for above said. Thanks in advance Muveen
Muveen_Delhi wrote:
How many tables should I make
That depends on the design; I'd recommend to normalize the database-model, that way you'll have a guaranteed correct and consistent design. Alternatively, you can download a pre-built design on databaseanswers.org[^].
Muveen_Delhi wrote:
How can I design the database to show the record on the page.
Databases do not show things; they store things. What kind of app would use the database? A webapplication, a desktop application, something on a phone?
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
Muveen_Delhi wrote:
How many tables should I make
That depends on the design; I'd recommend to normalize the database-model, that way you'll have a guaranteed correct and consistent design. Alternatively, you can download a pre-built design on databaseanswers.org[^].
Muveen_Delhi wrote:
How can I design the database to show the record on the page.
Databases do not show things; they store things. What kind of app would use the database? A webapplication, a desktop application, something on a phone?
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
I want to develop a website using PHP for that use I need this database.
-
I want to develop a website using PHP for that use I need this database.
Do a search for tutorials creating a music application (book would be similar), work through the tutorial. You question shows a dramatic lack of understanding of what you are attempting, the tutorials will deepen that understanding and allow you to ask sensible questions. Never underestimate the power of human stupidity RAH