The Project In this project, you will create populate (that is, add data to), and query a database in the IBM DB2 RDBMS at EECS's DB2 server. Thus, you are to 1. create the relational schema (the tables) based upon an ER design which we are providing. 2. populate the tables with some example data, and then 3. write and execute an SQL query that demonstrates the viability of your schema. Step one is to create the tables. You must follow the rules for translating entities and relationship as described in the textbook and shown in class. There is not much room for flexibility here. In step two, you will populate your tables with some data about the rock group called "Led Zeppelin." While the band existed before most of you were born, they are a band with whom everyone should become acquainted! You can pull data from the Wikipedia page devoted to the band: Led Zeppelin Wikipedia. As for their albums and songs, you must include information about at least their first album, also named "Led Zeppelin". (You may include data from other albums of theirs, of course, as you wish.) Wikipedia lists only chart rankings for the albums, unfortunately, and not for individual songs. One song from that album, however, Good Times Bad Times," was released as a single. Thus chart information for this song/ single is available. Values for some attributes are not available in Wikipedia (such as homepages of the artists). You should leave these blank then (in the relationally appropriate way). For step three, once you have all the relevant information in your tables, you should compose the following query in SQL and run it against your database: List all songs that ranked in top 100 of any chart together with the orchestra that accompanied the band." The Project In this project, you will create populate (that is, add data to), and query a database in the IBM DB2 RDBMS at EECS's DB2 server. Thus, you are to 1. create the relational schema (the tables) based upon an ER design which we are providing. 2. populate the tables with some example data, and then 3. write and execute an SQL query that demonstrates the viability of your schema. Step one is to create the tables. You must follow the rules for translating entities and relationship as described in the textbook and shown in class. There is not much room for flexibility here. In step two, you will populate your tables with some data about the rock group called "Led Zeppelin." While the band existed before most of you were born, they are a band with whom everyone should become acquainted! You can pull data from the Wikipedia page devoted to the band: Led Zeppelin Wikipedia. As for their albums and songs, you must include information about at least their first album, also named "Led Zeppelin". (You may include data from other albums of theirs, of course, as you wish.) Wikipedia lists only chart rankings for the albums, unfortunately, and not for individual songs. One song from that album, however, Good Times Bad Times," was released as a single. Thus chart information for this song/ single is available. Values for some attributes are not available in Wikipedia (such as homepages of the artists). You should leave these blank then (in the relationally appropriate way). For step three, once you have all the relevant information in your tables, you should compose the following query in SQL and run it against your database: List all songs that ranked in top 100 of any chart together with the orchestra that accompanied the band