Write and execute statements that will create all tables needed for this database. Name the tables exactly the same as the entity sets, and the columns exactly the same as the attributes except that all names should be purely lowercase and all hyphens have been replaced by underscores. For example, one of your tables should be named person_recording. When adding columns to a table to keep track of a relationship, add them after all columns representing entity attributes. For all of the associate tables, add the column copied from PERSON before the column copied from the other side. The table for TRACK requires a special column ordering: cdid, trknum, rcdid, compid. You can derive appropriate types for the

PERSON- RECORDING *psnrcdrole PERSON *psnid puntname psniname PERSON- COMPOSITION pscomprole pscomporder PERSON-CD pncorder COMPOSITION *compld comptitle compyear CD RECORDING rcdid rediength roddate TRACK *trknum LABEL *cdid cdlblid cdtitle cdyear *Ibltitle Iblstreet Ibicity Iblstate Ibipostcode Ibination PERSON- RECORDING *psnrcdrole PERSON *psnid puntname psniname PERSON- COMPOSITION pscomprole pscomporder PERSON-CD pncorder COMPOSITION *compld comptitle compyear CD RECORDING rcdid rediength roddate TRACK *trknum LABEL *cdid cdlblid cdtitle cdyear *Ibltitle Iblstreet Ibicity Iblstate Ibipostcode Ibination