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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!