Northeast Texas Instruments $($NTI$)$

Northeast Texas Instruments $($NTI$)$ rents guitars to bands playing local concerts. They began serving

musicians in the Greater Houston area and recently expanded into the Dallas$$Fort Worth metroplex. As a

part of its strategic plan, NTI wants to implement DMBS technology to streamline its operations.Please create an ER diagram for NTI based on 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