In this assignment, you will complete several different tasks related to database design. The following is a description and instructions for carrying out each task.

An agent who books instrumentalists for local gigs wants a database to track the musicians they hire. For example, a local charity recently wanted a solo trumpet to provide music for a fundraising gala. They needed someone with good feedback from our clients but was more affordable given this was a charity event. If they were able to query a well-designed database, they would be able to be more efficient and cost-effective in their hiring. Assuming each musician plays exactly ONE instrument and we want to also what to catalog descriptions of the instruments, respond to the following:

Name the entity or entities they would need in this database to collect data about to efficiently query the database to get the information they need? Keep this simple and stick to the given scenario.

In your Word document create the table(s) for your entity(ies) and identify attributes that would make sense to collect about each entity. Be sure to consider what they want to be able to do and the example I provided in determining attributes. Be sure to label each table with the entity name right above the table and identify the PRIMARY KEY by underlining it and identify any FOREIGN KEY(s) by italicizing it and adding (FK) after the attribute name. (Tips: You might want to add top & bottom margins to your table cells so the underlines are easy to see. You can also add (PK) after the attribute name to make it crystal clear.)