Question: Using what you have learned from the Banas database create a songbook database. Each book has 10 songs. It has a publication date and a
Using what you have learned from the Banas database create a songbook database. Each book has 10 songs. It has a publication date and a name. Each song has a name, a publication date, a genre and an author. Each author may have multiple songs but each song has a single author. Each genre will have multiple songs but each song has only one genre. Create and use foreign keys to connect the books and songs, the songs and their author, and the songs and their genre. Submit two scripts - one to create the database and one to populate the database. Do your own work. type it out yourself so that you contineu to learn the syntax.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
