Your next project entails your company creating a database for a small music store. The store sells products to customers, so you will need a basic sales database that allows customers to buy instruments, sheet music, supplies, etc. In addition to selling products, the company also arranges music lessons with local teachers. There are currently 32 teachers that teach a variety of instruments and charge different hourly rates for their lessons. Some teachers only teach one instrument while other teachers may offer lessons on multiple instruments. Lessons should be incorporated in the sales database as a product so customers can "order" them. You should incorporate any feedback received from Lab 1 into your ERD and you may need to expand the number of attributes needed. 1. Redo the Music store ERD from the previous lab assignment. This time, create a supertype of product and have three subtypes for product. These subtypes should be sheet music, instruments for sale, supplies, and recorded music. Determine what fields these items all share in the supertype and then provide at least three attributes for each subtype that are 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 might exist in a movie. Include at least two attributes that would be specific to that subtype. You might want to look at imdb. com if you need more info about the types of people that work on a movie and some of the specific types of information that might be stored about these job types. Complete an 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….any online database, I don’t care. Ok, I care a little….keep it PG13, please and you can’t use IMDB because I’m going to use that for examples. Spend a few minutes getting familiar with what you can search for, what data a search returns, etc.
a. For each database, list three entities that you think exist in the database. For example, if I do imdb. com, I would imagine that there is an actor table, a title table, a director table, etc
b. For each table, identify two possible primary keys. Some of these are likely to be composite keys to increase likelihood of uniqueness.