1. Redo the Music store ERD from the previous lab assignment. This time,create a supertype of product and have three subtypes for product. Thesesubtypes should be sheet music, instruments for sale, supplies, andrecorded music. Determine what fields these items all share in thesupertype and then provide at least three attributes for each subtype thatare particular to that type of product.2. Create a supertype and a subtype for employees in a movie production.Create a supertype PERSON and then define at least 4 subtypes that mightexist in a movie. Include at least two attributes that would be specific tothat subtype. You might want to look at imdb.com if you need more infoabout the types of people that work on a movie and some of the specifictypes of information that might be stored about these job types. Completean ERD for this supertype/subtype structure.3. Look at three databases on the internet. Some examples, kbb.com,amazon.com, oldnavy.com, chemspider.com, baseballreference.com….anyonline database, I don’t care. Ok, I care a little….keep it PG13, please andyou can’t use IMDB because I’m going to use that for examples. Spend afew minutes getting familiar with what you can search for, what data asearch returns, etc.a. For each database, list three entities that you think exist in thedatabase. For example, if I do imdb.com, I would imagine that thereis an actor table, a title table, a director table, etcb. For each table, identify two possible primary keys. Some of these arelikely to be composite keys to increase like