North Texas Instruments $($NTI$)$ Database Requirements North Texas Instruments $($NTI$)$ is a musical supplies company that rents guitars to musicians playing in local concerts. The firm primarily serves Denton, TX and wants to expand its operations further into the Dallas$$Fort Worth metropolitan area. As part of its growth strategy, NTI plans to implement a database and has asked you to develop a prototype. They have provided you with the following requirements: NTI$$s database will keep track of guitars, bands, and concerts. o Each guitar is identified by a unique serial number. They also have a manufacturer, model $($comprised of brand name and model year$),$ string type, and condition $($optional$).$ Guitars have two subtypes: acoustic and electric. A guitar must have a subtype and it can also be a hybrid $($acoustic$-$electric$).$ Acoustic guitars have a wood type. Each electric guitars come with an optional amplifier. o Each band is identified by a unique band ID$.$ Bands have a unique band name, a manager, and the names of each bandmember $($multivalued$).$ o Each concert is identified by a unique concert ID$,$ comprised of a date, time, and venue. Concerts also have a tour name, ticket price, and projected attendance $($calculated$).$ Bands are allowed to rent guitars and perform concerts. o A band may rent multiple guitars, or no guitars. A guitar can only be rented by one band, or not rented at all. o A band may perform multiple concerts, or no concerts. A concert must be performed by at least one band, and can also be performed by multiple bands.

$(1)$ create an ER diagram, $(2)$ create a relational schema, and $(3)$ write the SQL code to create any

two tables in the database